#metabrainz

/

      • alastairp
        there, I'm not sure. If you run cpanm install and there is a lower/different version number in the cpanfile I don't know if it will automatically update it
      • 2017-06-06 15730, 2017

      • MatthewGlubb
        Suck it and see
      • 2017-06-06 15737, 2017

      • alastairp
        ;)
      • 2017-06-06 15743, 2017

      • adhawkins
        alastairp: Ok, I'm trying to work out whether I should just get the updated code that works with 3.6.0, or downgrade the module.
      • 2017-06-06 15743, 2017

      • alastairp
        what could go wrong??!? :)
      • 2017-06-06 15700, 2017

      • reosarevok
        I mean it's already broken, right? :p
      • 2017-06-06 15701, 2017

      • adhawkins
        I think I'd prefer upgrading the code, if it's as simple as doing a git pull and then restarting processes.
      • 2017-06-06 15723, 2017

      • alastairp
        adhawkins: oh yeah, sorry. I forgot that - that he updated the code, not forcefully downgraded the dependency
      • 2017-06-06 15734, 2017

      • alastairp
        yes, that sounds like a better idea
      • 2017-06-06 15759, 2017

      • adhawkins
        Ok. I'll take a snapshot of my VM and try the git pull. Will see how that goes.
      • 2017-06-06 15738, 2017

      • adhawkins
        There seems to be a lot of changes since the last 'release'...
      • 2017-06-06 15737, 2017

      • adhawkins
        Ok, I've updated to the latest code, but I'm still getting the same error when I run admin/replication/ImportReplicationChanges
      • 2017-06-06 15719, 2017

      • adhawkins
        Wonder whether it'd be simpler to just downgrade the module? I notice the upgrade instructions for the schema change release now include this step. They didn't when I carried out the upgrade (I don't think).
      • 2017-06-06 15721, 2017

      • ZarkBit_ joined the channel
      • 2017-06-06 15733, 2017

      • reosarevok
        No, they didn't
      • 2017-06-06 15740, 2017

      • reosarevok
        It was added later when we figured this out
      • 2017-06-06 15711, 2017

      • adhawkins
        Ok. So should it work with the fixed code and the latest DBD::Pg module? Or should I drop the version of the module down?
      • 2017-06-06 15719, 2017

      • ruaok
        iliekcomputers, alastairp : if you have some time today, it would help me to get this PR merged today: https://github.com/metabrainz/listenbrainz-server…
      • 2017-06-06 15737, 2017

      • iliekcomputers
        Was looking at that just now :)
      • 2017-06-06 15755, 2017

      • ZarkBit has quit
      • 2017-06-06 15758, 2017

      • ZarkBit_ is now known as ZarkBit
      • 2017-06-06 15714, 2017

      • ruaok
        woo
      • 2017-06-06 15750, 2017

      • d4rkie joined the channel
      • 2017-06-06 15727, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-06 15749, 2017

      • sim6 joined the channel
      • 2017-06-06 15758, 2017

      • sim6
        Hello,
      • 2017-06-06 15749, 2017

      • sim6
        Firstly, thanks for your work.
      • 2017-06-06 15753, 2017

      • sim6
        Can I search for artist, album and song name in one query?
      • 2017-06-06 15734, 2017

      • adhawkins
        Using the web service, or the site in general?
      • 2017-06-06 15731, 2017

      • sim6
        Yes, I would like to do an https query with some words and get the artists, albums and songs with this words
      • 2017-06-06 15725, 2017

      • adhawkins
        Does this hepl?
      • 2017-06-06 15739, 2017

      • adhawkins
      • 2017-06-06 15751, 2017

      • adhawkins
        sim6: The web service is documented here: https://musicbrainz.org/doc/Development/XML_Web_S…
      • 2017-06-06 15757, 2017

      • ruaok
        iliekcomputers: did you see that I added flask-pika to requirements.txt ? see the bottom.
      • 2017-06-06 15704, 2017

      • ruaok
      • 2017-06-06 15714, 2017

      • iliekcomputers
        ruaok: I meant maybe we could make it Flask-Pika == 0.3.8 specifying the version also, just a nitpick
      • 2017-06-06 15730, 2017

      • ruaok
        oh, right yes. will fix.
      • 2017-06-06 15732, 2017

      • d4rkie has quit
      • 2017-06-06 15759, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-06 15739, 2017

      • github joined the channel
      • 2017-06-06 15739, 2017

      • github
        [listenbrainz-server] mayhem closed pull request #190: Use Flask pika connection pooler (master...flask-pika) https://git.io/vHwIR
      • 2017-06-06 15740, 2017

      • github has left the channel
      • 2017-06-06 15701, 2017

      • MatthewGlubb
        bitmap - replication now looks good on all our environments again. Thanks very much for your help on this!
      • 2017-06-06 15712, 2017

      • ruaok
        \ø/
      • 2017-06-06 15726, 2017

      • adhawkins
        Just wish I could get mine working again :)
      • 2017-06-06 15723, 2017

      • MatthewGlubb
        adhawkins - have you tried deleting any existing DB::Pg dependencies and refetching?
      • 2017-06-06 15757, 2017

      • adhawkins
        I was assuming that the fixed code would work with the 'latest' version of DBD::Pg?
      • 2017-06-06 15700, 2017

      • CatQuest
        +1 clint :D
      • 2017-06-06 15705, 2017

      • adhawkins
        I've checked my local codebase, and it seems to have the modifications in the pull requested by the ticket you mentioned.
      • 2017-06-06 15734, 2017

      • MatthewGlubb
        Ah. If you've already got the latest I would assume the same. We haven't tried with the fix, we just forced a lower version. Sounds like you may be the guinea pig :( What I know works is to not use the revision with the fix and manually force a lower version of the dep
      • 2017-06-06 15759, 2017

      • adhawkins
        MatthewGlubb: Ok. But presumably you've had to fetch the latest code to fix last night's replication issue?
      • 2017-06-06 15719, 2017

      • adhawkins
        Or did you just clear out the table as mentioned in the blog post?
      • 2017-06-06 15722, 2017

      • MatthewGlubb
        No. I didn't. It was a data issue.
      • 2017-06-06 15723, 2017

      • MatthewGlubb
        yes
      • 2017-06-06 15729, 2017

      • CatQuest
        🙌 zg-CN locale!
      • 2017-06-06 15742, 2017

      • adhawkins
        Oh ok. I might just revert my code, downgrade the module and then see what happens.
      • 2017-06-06 15743, 2017

      • MatthewGlubb
        There is a longer term fix I believe that will solve the cause of the problem for that
      • 2017-06-06 15705, 2017

      • adhawkins
        Will hang around for bitmap to see if he wants to look into this further. My server is hardly mission critical :)
      • 2017-06-06 15715, 2017

      • adhawkins
        Some of my music might have two week old tags...no real drama :)
      • 2017-06-06 15719, 2017

      • sim6
        adhawkins: I don't get the artists that contains the word if I use the recording query
      • 2017-06-06 15744, 2017

      • adhawkins
        sim6: Oh I see, I assumed you wanted the artists for the recordings that matched
      • 2017-06-06 15754, 2017

      • adhawkins
        In that case, I don't *think* you can search like that.
      • 2017-06-06 15726, 2017

      • MatthewGlubb has quit
      • 2017-06-06 15745, 2017

      • adhawkins
        sim6: Probably best to wait for a response from one of the MB developers then I think.
      • 2017-06-06 15709, 2017

      • CatQuest
        ahh finished reading the logs.. :D
      • 2017-06-06 15729, 2017

      • sim6
        adhawkins: thanks anyway
      • 2017-06-06 15745, 2017

      • CatQuest ponders if freso or reosarevok or anyone else that wants to look over his blogpost is around right now
      • 2017-06-06 15749, 2017

      • adhawkins
        sim6: No worries, sorry I couldn't help further.
      • 2017-06-06 15713, 2017

      • CatQuest
        well i guess not, I'll be buzy most of the day tho, so probably do this maybe tomorrow instead.. :D
      • 2017-06-06 15726, 2017

      • CatQuest
        \o bye and great work guys and gals!
      • 2017-06-06 15747, 2017

      • bitmap
        adhawkins: can you paste the error that occurs using the latest code?
      • 2017-06-06 15726, 2017

      • reosarevok
        CatQuest: I am actually :p
      • 2017-06-06 15733, 2017

      • reosarevok
        Just was answering some email
      • 2017-06-06 15735, 2017

      • lazka joined the channel
      • 2017-06-06 15745, 2017

      • bitmap
        also `git rev-parse HEAD` and `perl -e 'use DBD::Pg; print $DBD::Pg::VERSION;'`
      • 2017-06-06 15744, 2017

      • reosarevok adds MBS-9368 as per a (direct) support mail I just got
      • 2017-06-06 15710, 2017

      • reosarevok
        Didn't find a duplicate but it seems like a thing that might have already been requested
      • 2017-06-06 15716, 2017

      • reosarevok
        eh. BrainzBot, MBS-9368 ?
      • 2017-06-06 15717, 2017

      • BrainzBot
        MBS-9368: Ask for confirmation when leaving format empty https://tickets.metabrainz.org/browse/MBS-9368
      • 2017-06-06 15720, 2017

      • reosarevok
        Thanks :p
      • 2017-06-06 15721, 2017

      • reosarevok
        ruaok: yay more German mail for you
      • 2017-06-06 15759, 2017

      • adhawkins
      • 2017-06-06 15704, 2017

      • adhawkins
        Same error as far as I can see.
      • 2017-06-06 15745, 2017

      • adhawkins
        efba20ace00a0c0e5c9313a479016a9cc3e38300
      • 2017-06-06 15752, 2017

      • adhawkins
        3.6.0 is version of DBD::Pg
      • 2017-06-06 15744, 2017

      • bitmap
        hmm
      • 2017-06-06 15711, 2017

      • gcilou joined the channel
      • 2017-06-06 15711, 2017

      • gcilou
      • 2017-06-06 15729, 2017

      • bitmap
        let's try clearing the dbmirror tables, since it's continuing from a previous load which may have bad encoding
      • 2017-06-06 15742, 2017

      • bitmap
        echo 'TRUNCATE dbmirror_pending CASCADE; TRUNCATE dbmirror_pendingdata CASCADE;' | ./admin/psql READWRITE
      • 2017-06-06 15703, 2017

      • bitmap
        then try replication again
      • 2017-06-06 15725, 2017

      • adhawkins
        Ok
      • 2017-06-06 15728, 2017

      • adhawkins
        New error, duplicate values: http://paste.debian.net/969944/
      • 2017-06-06 15744, 2017

      • bitmap
        ah right, dang. give me a minute
      • 2017-06-06 15708, 2017

      • bitmap
        try clearing the dbmirror tables again, then do ./admin/replication/LoadReplicationChanges --limit=1 --process-arg='--skip-seqid=298357179'
      • 2017-06-06 15718, 2017

      • bitmap
        not sure if this'll work
      • 2017-06-06 15753, 2017

      • adhawkins
        Ok, it's skipped a large range of SeqIds, and is now continuing.
      • 2017-06-06 15726, 2017

      • adhawkins
      • 2017-06-06 15756, 2017

      • bitmap
        that part looks right
      • 2017-06-06 15729, 2017

      • adhawkins
        Finished, get this:
      • 2017-06-06 15730, 2017

      • adhawkins
        Tue Jun 6 11:50:10 2017 : Replication changes applied
      • 2017-06-06 15730, 2017

      • adhawkins
        Tue Jun 6 11:50:10 2017 : Checking that dbmirror_pendingdata is empty
      • 2017-06-06 15730, 2017

      • adhawkins
        dbmirror_pendingdata still contains data (rows=1993)! at /home/mbserver/musicbrainz-server/admin/replication/ProcessReplicationChanges line 231.
      • 2017-06-06 15709, 2017

      • adhawkins
        Clear the pending table again?
      • 2017-06-06 15747, 2017

      • bitmap
        hmm yeah, I guess it doesn't clear the ones you skip
      • 2017-06-06 15715, 2017

      • adhawkins
        Ok, cleared and running without the 'skip'. Seems to be proceeding now.
      • 2017-06-06 15723, 2017

      • adhawkins
        Got a couple of weeks of data to catch up on now :)
      • 2017-06-06 15748, 2017

      • bitmap
        :)
      • 2017-06-06 15758, 2017

      • bitmap
        glad it's working now (I hope)
      • 2017-06-06 15706, 2017

      • adhawkins
        Fingers crossed, will report back when it's done.
      • 2017-06-06 15707, 2017

      • ruaok
        LordSputnik: if they hand you a Pixel XL, make sure to get GoogleFi if that isn't included. Holy shit, totally worth it.
      • 2017-06-06 15741, 2017

      • adhawkins
        Processing replication packets from 19th May. That'll teach me to ignore the "Hmmm...that's odd" feeling I got after not getting any tag changes notified for several days...
      • 2017-06-06 15742, 2017

      • ruaok
        !m bitmap
      • 2017-06-06 15742, 2017

      • BrainzBot
        You're doing good work, bitmap!
      • 2017-06-06 15757, 2017

      • ruaok
        iliekcomputers: I'm really happy with how LB is coming together. the codebase is looking much nicer and things are a lot more solid all around. I can't wait to release this soon!
      • 2017-06-06 15707, 2017

      • iliekcomputers
        🎉 🎉
      • 2017-06-06 15723, 2017

      • iliekcomputers
        can't wait :)
      • 2017-06-06 15716, 2017

      • lazka has quit
      • 2017-06-06 15705, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-06 15733, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-06 15747, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-06 15713, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-06 15713, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-06 15713, 2017

      • github joined the channel
      • 2017-06-06 15713, 2017

      • github
        [critiquebrainz] gentlecat closed pull request #107: CB-230: Migrate completely off the ORM (master...complete-code-migration) https://git.io/vHgNh
      • 2017-06-06 15713, 2017

      • github has left the channel
      • 2017-06-06 15724, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-06 15750, 2017

      • D4RK-PH0ENiX has quit
      • 2017-06-06 15733, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-06-06 15752, 2017

      • kyan has quit
      • 2017-06-06 15733, 2017

      • github joined the channel
      • 2017-06-06 15733, 2017

      • github
        [listenbrainz-server] mayhem opened pull request #191: Listen counts (master...listen-counts) https://git.io/vHr8L
      • 2017-06-06 15733, 2017

      • github has left the channel
      • 2017-06-06 15705, 2017

      • dosoe joined the channel
      • 2017-06-06 15731, 2017

      • dosoe
        Hi! I'm trying without success to setup a musicbrainz server. Would anyone be able to help me?
      • 2017-06-06 15701, 2017

      • iliekcomputers
        dosoe: you should post the problem you're facing and the experts will help you when they see it :)
      • 2017-06-06 15743, 2017

      • dosoe
        I tried to go through the instructions on git https://github.com/metabrainz/musicbrainz-server/… but I got stuck at a few places: What are "appropriate values for MB_SERVER_ROOT and WEB_SERVER"? Where can I find pg_hba.conf and pg_ident.conf?
      • 2017-06-06 15733, 2017

      • gcilou
      • 2017-06-06 15749, 2017

      • dosoe
        I just skipped these two steps (I don't know how good this idea is...) and tried "plackup -Ilib -r" and then tried to access http://my.ip:5000 and http://localhost:5000 but none of them reacted
      • 2017-06-06 15701, 2017

      • dosoe
        Hello!
      • 2017-06-06 15718, 2017

      • dosoe
        what is it about?
      • 2017-06-06 15724, 2017

      • gcilou
        I didn't go in lol. Just came from the Vasa museum. So cool.
      • 2017-06-06 15733, 2017

      • ruaok
        gcilou: it sure seems that you're not in (ar)kansas anymore!
      • 2017-06-06 15738, 2017

      • ruaok runs
      • 2017-06-06 15746, 2017

      • ruaok
        dosoe: what is your end goal?
      • 2017-06-06 15756, 2017

      • ruaok
        what do you plan to use the server for?
      • 2017-06-06 15702, 2017

      • gcilou
        Lmao you're correct
      • 2017-06-06 15705, 2017

      • dosoe
        I want beets to be faster
      • 2017-06-06 15720, 2017

      • ruaok
        download the VM then. its a lot easier to work with.
      • 2017-06-06 15742, 2017

      • dosoe
        ok thanks!