#metabrainz

/

      • Sophist_UK has quit
      • 2017-06-05 15605, 2017

      • antgel has quit
      • 2017-06-05 15619, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-05 15603, 2017

      • hibiscuskazeneko joined the channel
      • 2017-06-05 15610, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-05 15611, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-05 15617, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-05 15618, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-05 15644, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-05 15649, 2017

      • to81 joined the channel
      • 2017-06-05 15639, 2017

      • d4rkie joined the channel
      • 2017-06-05 15623, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-05 15631, 2017

      • to81 has quit
      • 2017-06-05 15607, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-05 15605, 2017

      • d4rkie has quit
      • 2017-06-05 15637, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-05 15604, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-05 15645, 2017

      • exogen has quit
      • 2017-06-05 15635, 2017

      • exogen joined the channel
      • 2017-06-05 15643, 2017

      • exogen has quit
      • 2017-06-05 15624, 2017

      • exogen joined the channel
      • 2017-06-05 15631, 2017

      • exogen has quit
      • 2017-06-05 15615, 2017

      • exogen joined the channel
      • 2017-06-05 15619, 2017

      • exogen has quit
      • 2017-06-05 15600, 2017

      • exogen joined the channel
      • 2017-06-05 15607, 2017

      • exogen has quit
      • 2017-06-05 15635, 2017

      • exogen joined the channel
      • 2017-06-05 15630, 2017

      • exogen has quit
      • 2017-06-05 15628, 2017

      • github joined the channel
      • 2017-06-05 15628, 2017

      • github
        [musicbrainz-server] mwiencek opened pull request #521: MBS-9309: Ignore swapped recordings in medium merges (master...mbs-9309) https://git.io/vHaVZ
      • 2017-06-05 15628, 2017

      • github has left the channel
      • 2017-06-05 15607, 2017

      • Slurpee has quit
      • 2017-06-05 15650, 2017

      • spuniun
        my slave replication has been choking
      • 2017-06-05 15624, 2017

      • spuniun
        I purged and reimported the full db dump yesterday cause replication barfed on some crazy unicode artist string
      • 2017-06-05 15627, 2017

      • spuniun
        and now today
      • 2017-06-05 15639, 2017

      • spuniun
        23505 DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "artist_alias_idx_primary"
      • 2017-06-05 15632, 2017

      • spuniun
        any easy way to safely fix or do I reimport again
      • 2017-06-05 15603, 2017

      • bitmap
        reimport and make sure you have DBD::Pg 3.5.3 if you're getting encoding errors
      • 2017-06-05 15622, 2017

      • bitmap
        actually, let me merge this fix now
      • 2017-06-05 15602, 2017

      • github joined the channel
      • 2017-06-05 15603, 2017

      • github
        [musicbrainz-server] mwiencek closed pull request #516: MBS-9342: Fix imports with DBD::Pg 3.6.0 (master...mbs-9342) https://git.io/vHWeL
      • 2017-06-05 15603, 2017

      • github has left the channel
      • 2017-06-05 15606, 2017

      • spuniun
        $ perl -e 'use DBD::Pg; print $DBD::Pg::VERSION;'
      • 2017-06-05 15606, 2017

      • spuniun
        3.5.9_1
      • 2017-06-05 15614, 2017

      • spuniun
        I had downgraded to this cause of that ticket
      • 2017-06-05 15633, 2017

      • spuniun
        I can downgrade further if that's needed
      • 2017-06-05 15656, 2017

      • spuniun
        oh, I can just pull master
      • 2017-06-05 15611, 2017

      • bitmap
        3.5.9? I don't see that version in CHANGES, so it might have been a 3.6 pre-release
      • 2017-06-05 15630, 2017

      • bitmap
        yes, just get master now
      • 2017-06-05 15640, 2017

      • spuniun
        I had just installed what was recommended in that issue
      • 2017-06-05 15658, 2017

      • spuniun
        I'll reimport overnight again
      • 2017-06-05 15629, 2017

      • bitmap
        ok, strange
      • 2017-06-05 15623, 2017

      • ferbncode
        alastairp: bitmap: Hi :). Importing from the dumps work. However, there is a strange problem. When both mbdump.tar.bz2 and mbdump-derived.tar.bz2 are imported then I get this error: https://gist.github.com/ferbncode/24489aec42b5cc0…. I tried importing both dumps from 31-05 and 03-06. But the same error pops in for both of them.
      • 2017-06-05 15657, 2017

      • bitmap
        are you sure both dumps were from the same date both times you tried?
      • 2017-06-05 15623, 2017

      • ferbncode
        yes, both of them were from the same dates
      • 2017-06-05 15658, 2017

      • spuniun
        I just imported 6/3 dumps last night without issue
      • 2017-06-05 15615, 2017

      • spuniun
        gunna do it again now
      • 2017-06-05 15633, 2017

      • spuniun
        doing full import of the entire set
      • 2017-06-05 15633, 2017

      • bitmap
        that's 'cause slave dbs don't add foreign keys
      • 2017-06-05 15609, 2017

      • bitmap
        and yeah, there are some ghost ids in event_meta, I'm not sure why these are there yet
      • 2017-06-05 15617, 2017

      • bitmap
        event_meta_fk_id doesn't exist in production...
      • 2017-06-05 15638, 2017

      • bitmap
        ferbncode: I'll fix that asap :/
      • 2017-06-05 15652, 2017

      • bitmap
        thanks for reporting that
      • 2017-06-05 15600, 2017

      • ferbncode
        bitmap: okay, thanks :)
      • 2017-06-05 15644, 2017

      • to81 joined the channel
      • 2017-06-05 15647, 2017

      • to81 has quit
      • 2017-06-05 15626, 2017

      • github joined the channel
      • 2017-06-05 15626, 2017

      • github
        [musicbrainz-server] mwiencek opened pull request #522: MBS-9365: Create event_meta_fk_id for old standalone DBs (master...mbs-9365) https://git.io/vHawQ
      • 2017-06-05 15626, 2017

      • github has left the channel
      • 2017-06-05 15637, 2017

      • bitmap
        I deleted those rows and created the FK in production. I'll run another fullexport now
      • 2017-06-05 15612, 2017

      • pingupingu joined the channel
      • 2017-06-05 15613, 2017

      • pingupingu has quit
      • 2017-06-05 15613, 2017

      • pingupingu joined the channel
      • 2017-06-05 15635, 2017

      • kyan has quit
      • 2017-06-05 15621, 2017

      • kyan joined the channel
      • 2017-06-05 15633, 2017

      • ZaphodBeeblebrox joined the channel
      • 2017-06-05 15622, 2017

      • CatQuest has quit
      • 2017-06-05 15652, 2017

      • drsaunders has quit
      • 2017-06-05 15633, 2017

      • to81 joined the channel
      • 2017-06-05 15604, 2017

      • to81 has quit
      • 2017-06-05 15605, 2017

      • boneskull joined the channel
      • 2017-06-05 15624, 2017

      • d4rkie joined the channel
      • 2017-06-05 15626, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-05 15655, 2017

      • pingupingu has quit
      • 2017-06-05 15642, 2017

      • samj1912 joined the channel
      • 2017-06-05 15652, 2017

      • drsaunders joined the channel
      • 2017-06-05 15627, 2017

      • danimal4 joined the channel
      • 2017-06-05 15640, 2017

      • gcilou joined the channel
      • 2017-06-05 15655, 2017

      • gcilou
        Good morning from Sweden :)
      • 2017-06-05 15636, 2017

      • CallerNo6
        Get outta town. Isn't that in another dimension or something?
      • 2017-06-05 15646, 2017

      • gcilou
        A dimention where night doesn't exist and I've been up for 20 hours and it's almost 7am, yes.
      • 2017-06-05 15657, 2017

      • gcilou
        Buuut I'm happy to be here at last :)
      • 2017-06-05 15605, 2017

      • agentsim has quit
      • 2017-06-05 15646, 2017

      • regagain joined the channel
      • 2017-06-05 15638, 2017

      • drsaunders has quit
      • 2017-06-05 15617, 2017

      • luks
        bitmap: the problem with DBD::Pg also affects slave servers? I'm using mbslave and get the same error. I think it's the replication packet that's wrong? or maybe the schema upgrade migration was wrong?
      • 2017-06-05 15654, 2017

      • to81 joined the channel
      • 2017-06-05 15632, 2017

      • hibiscuskazeneko has quit
      • 2017-06-05 15652, 2017

      • hibiscuskazeneko joined the channel
      • 2017-06-05 15644, 2017

      • danimal4 has left the channel
      • 2017-06-05 15607, 2017

      • d4rkie has quit
      • 2017-06-05 15609, 2017

      • beqn has quit
      • 2017-06-05 15609, 2017

      • yurrriq has quit
      • 2017-06-05 15609, 2017

      • LordSputnik has quit
      • 2017-06-05 15609, 2017

      • ocharles has quit
      • 2017-06-05 15653, 2017

      • LordSputnik joined the channel
      • 2017-06-05 15654, 2017

      • beqn joined the channel
      • 2017-06-05 15656, 2017

      • ocharles joined the channel
      • 2017-06-05 15659, 2017

      • yurrriq joined the channel
      • 2017-06-05 15605, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-05 15643, 2017

      • agentsim joined the channel
      • 2017-06-05 15603, 2017

      • agentsim has quit
      • 2017-06-05 15620, 2017

      • reosarevok
        Welcome to the civilised healthcare world gcilou!
      • 2017-06-05 15640, 2017

      • hibiscuskazeneko has quit
      • 2017-06-05 15641, 2017

      • agentsim joined the channel
      • 2017-06-05 15601, 2017

      • gcilou
        hahahaha thank you reosarevok :D
      • 2017-06-05 15645, 2017

      • gcilou
      • 2017-06-05 15656, 2017

      • to81 has quit
      • 2017-06-05 15643, 2017

      • reosarevok
        Yeah sorry you got to the North in the middle of a cold bunch of days
      • 2017-06-05 15655, 2017

      • reosarevok
        It's supposed to be much better in a few days but I guess you won't be there anymore
      • 2017-06-05 15610, 2017

      • drsaunders joined the channel
      • 2017-06-05 15610, 2017

      • gcilou
        Yeah we leave Stockholm on Wednesday
      • 2017-06-05 15644, 2017

      • drsaunders has quit
      • 2017-06-05 15608, 2017

      • samj1912 has quit
      • 2017-06-05 15657, 2017

      • agentsim has quit
      • 2017-06-05 15645, 2017

      • to81 joined the channel
      • 2017-06-05 15629, 2017

      • to81 has quit
      • 2017-06-05 15621, 2017

      • to81 joined the channel
      • 2017-06-05 15605, 2017

      • to81 has quit
      • 2017-06-05 15639, 2017

      • to81 joined the channel
      • 2017-06-05 15609, 2017

      • to81 has quit
      • 2017-06-05 15611, 2017

      • boneskull has quit
      • 2017-06-05 15651, 2017

      • boneskull joined the channel
      • 2017-06-05 15619, 2017

      • gcilou
      • 2017-06-05 15647, 2017

      • ruaok
        gamla stan?
      • 2017-06-05 15602, 2017

      • ruaok
        and welcome to the EU! Weather in the south is crap too.
      • 2017-06-05 15622, 2017

      • gcilou
        Yes gamla stan!
      • 2017-06-05 15658, 2017

      • gcilou
        Lol I hope it gets better later this week
      • 2017-06-05 15615, 2017

      • agentsim joined the channel
      • 2017-06-05 15647, 2017

      • rembo10 has quit
      • 2017-06-05 15625, 2017

      • arbenina joined the channel
      • 2017-06-05 15651, 2017

      • rembo10 joined the channel
      • 2017-06-05 15638, 2017

      • zas
        Moin!
      • 2017-06-05 15609, 2017

      • ruaok
        moin
      • 2017-06-05 15649, 2017

      • zas
        I did a second batch of 403 abusers blocking, it changes nothing on load but makes logs lighter, if someone complains of being blocked, just ask for IP
      • 2017-06-05 15619, 2017

      • alastairp
        hello
      • 2017-06-05 15630, 2017

      • Matthew joined the channel
      • 2017-06-05 15653, 2017

      • Matthew is now known as Guest29341
      • 2017-06-05 15611, 2017

      • ruaok
        ok.
      • 2017-06-05 15603, 2017

      • TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | Picard meeting (Tues, 18:00 UTC): Working document https://goo.gl/anENrc | MetaBrainz meeting agenda (now: 17 UTC!): reviews, spam review (ruaok), ws/2.5 (ruaok/zas)