#metabrainz

/

      • iliekcomputers
        Mr_Monkey: moin!
      • 2019-05-01 12123, 2019

      • chirlu has quit
      • 2019-05-01 12116, 2019

      • chirlu joined the channel
      • 2019-05-01 12138, 2019

      • Mr_Monkey
        Hi iliekcomputers ! Sorry, had an alarm clock failure…
      • 2019-05-01 12118, 2019

      • Mr_Monkey
        Hi zas ! Are you around today for a dns change?
      • 2019-05-01 12110, 2019

      • iliekcomputers
        No worries. I have a college thing in like 40 min. Do you wanna start once i get back?
      • 2019-05-01 12136, 2019

      • Mr_Monkey
        Sure
      • 2019-05-01 12140, 2019

      • Mr_Monkey
        iliekcomputers: roughly how long do you think?
      • 2019-05-01 12107, 2019

      • iliekcomputers
        10-15 min at most
      • 2019-05-01 12132, 2019

      • Mr_Monkey
        Oh, OK :p
      • 2019-05-01 12142, 2019

      • iliekcomputers
        I'm gonna be here fully from 5 PM IST.
      • 2019-05-01 12149, 2019

      • Mr_Monkey
        I was thinking 2-3 hours, thinking about lunch plans and all that :p
      • 2019-05-01 12115, 2019

      • iliekcomputers
        Ahh
      • 2019-05-01 12122, 2019

      • iliekcomputers
        When do you lunch?
      • 2019-05-01 12157, 2019

      • Mr_Monkey
        I'll do that now-ish and be free at 5PM IST
      • 2019-05-01 12122, 2019

      • iliekcomputers
        Ah, cool!
      • 2019-05-01 12134, 2019

      • iliekcomputers
        Hopefully we're done in minutes :) :)
      • 2019-05-01 12158, 2019

      • iliekcomputers
        Mr_Monkey: how many tables does the db have?
      • 2019-05-01 12159, 2019

      • michelv__ has quit
      • 2019-05-01 12130, 2019

      • iliekcomputers
        Might be good to write a script to count number of rows in each table for a consistency check.
      • 2019-05-01 12138, 2019

      • iliekcomputers
        I can do that today.
      • 2019-05-01 12109, 2019

      • Mr_Monkey
        That would be great :)
      • 2019-05-01 12147, 2019

      • Mr_Monkey
        iliekcomputers: 240 tables
      • 2019-05-01 12114, 2019

      • iliekcomputers
        Yikes lol
      • 2019-05-01 12127, 2019

      • Mr_Monkey
        61 of which are on the bookbrainz schema
      • 2019-05-01 12121, 2019

      • michelv__ joined the channel
      • 2019-05-01 12119, 2019

      • zas
        Mr_Monkey: yup, just ping me when you need
      • 2019-05-01 12137, 2019

      • Mr_Monkey
        Hello zas! Could you please change the DNS TTL to 5 minutes for BookBrainz.org?
      • 2019-05-01 12104, 2019

      • letaiv joined the channel
      • 2019-05-01 12119, 2019

      • iliekcomputers
        Be around in just 10-15 min, if that's okay.
      • 2019-05-01 12137, 2019

      • zas
        K
      • 2019-05-01 12154, 2019

      • iliekcomputers
        * I'll be around.
      • 2019-05-01 12103, 2019

      • zas
        Mr_Monkey: ttl is on 300 seconds already
      • 2019-05-01 12124, 2019

      • Mr_Monkey
        Ah, I hadn't realised, thanks zas
      • 2019-05-01 12129, 2019

      • Mr_Monkey
        No rush iliekcomputers
      • 2019-05-01 12147, 2019

      • michelv__ has quit
      • 2019-05-01 12121, 2019

      • iliekcomputers
        Mr_Monkey: i'm here, sorry!
      • 2019-05-01 12128, 2019

      • Mr_Monkey
        No worries !
      • 2019-05-01 12152, 2019

      • Mr_Monkey
        Do you need more time?
      • 2019-05-01 12111, 2019

      • iliekcomputers
        nope, here totally now
      • 2019-05-01 12131, 2019

      • Mr_Monkey takes deep breath
      • 2019-05-01 12135, 2019

      • iliekcomputers
        yo!
      • 2019-05-01 12137, 2019

      • Mr_Monkey
        All right, let's do this then :)
      • 2019-05-01 12109, 2019

      • iliekcomputers
        let's migrate the db once before bringing the site down.
      • 2019-05-01 12139, 2019

      • Mr_Monkey
        I'm down with that. do you want to do the honnors?
      • 2019-05-01 12123, 2019

      • iliekcomputers
        yea, sure.
      • 2019-05-01 12102, 2019

      • iliekcomputers
        in the meanwhile, can you come up with a list of tables that we should check for consistency in rows?
      • 2019-05-01 12118, 2019

      • Mr_Monkey
        Yep
      • 2019-05-01 12105, 2019

      • iliekcomputers
        new db created.
      • 2019-05-01 12145, 2019

      • Mr_Monkey
        OK, time to take a dump.
      • 2019-05-01 12145, 2019

      • Mr_Monkey
        I'm set up to compare rows
      • 2019-05-01 12100, 2019

      • iliekcomputers
        wokay, creating dump on the vm.
      • 2019-05-01 12156, 2019

      • Mr_Monkey
        The dumps are so fast on BB
      • 2019-05-01 12109, 2019

      • Mr_Monkey
        For now
      • 2019-05-01 12149, 2019

      • ruaok
      • 2019-05-01 12104, 2019

      • ruaok
        not a bad place to pay people from, no?
      • 2019-05-01 12122, 2019

      • ruaok
        if you sent your invoice in already, its paid. the rest of you: Slackers!
      • 2019-05-01 12125, 2019

      • ruaok runs off again
      • 2019-05-01 12135, 2019

      • Mr_Monkey
        Damn, I always forget the month ends.
      • 2019-05-01 12141, 2019

      • Mr_Monkey
        Enjoy, ruaok !
      • 2019-05-01 12120, 2019

      • iliekcomputers
        ok dump copied over
      • 2019-05-01 12129, 2019

      • iliekcomputers
        and imported into postgres master
      • 2019-05-01 12146, 2019

      • iliekcomputers
        sorry for the lateness, some network problems
      • 2019-05-01 12113, 2019

      • Mr_Monkey
        OK, let me compare rows
      • 2019-05-01 12147, 2019

      • iliekcomputers
      • 2019-05-01 12133, 2019

      • zas
        https://bookbrainz.org/ returns a 404 atm
      • 2019-05-01 12156, 2019

      • Mr_Monkey
        Did you stop the service iliekcomputers ?
      • 2019-05-01 12105, 2019

      • iliekcomputers
        yes.
      • 2019-05-01 12133, 2019

      • iliekcomputers
        do the rows look ok?
      • 2019-05-01 12142, 2019

      • Mr_Monkey
        Ah, I thought we were doing a dry run. Well, zas it'll be down fora short period of time
      • 2019-05-01 12149, 2019

      • Mr_Monkey
        iliekcomputers: Checking now
      • 2019-05-01 12129, 2019

      • iliekcomputers
        Mr_Monkey: do you have a script to test?
      • 2019-05-01 12140, 2019

      • Mr_Monkey
        iliekcomputers: I'm checking manually
      • 2019-05-01 12146, 2019

      • iliekcomputers
        ah.
      • 2019-05-01 12106, 2019

      • iliekcomputers
        what tables, maybe I can do the counts on vm and you on bowie
      • 2019-05-01 12121, 2019

      • Mr_Monkey
        iliekcomputers: Just saw this, sorry. It all looks good!
      • 2019-05-01 12128, 2019

      • iliekcomputers
        ahh
      • 2019-05-01 12131, 2019

      • iliekcomputers
        woohoo nice!
      • 2019-05-01 12147, 2019

      • iliekcomputers
        i checked new.bookbrainz and it looks sane to me.
      • 2019-05-01 12154, 2019

      • iliekcomputers
        search works.
      • 2019-05-01 12107, 2019

      • Mr_Monkey
        Let me add an item to make sure
      • 2019-05-01 12120, 2019

      • Mr_Monkey
        iliekcomputers: A-OK
      • 2019-05-01 12129, 2019

      • iliekcomputers
        cool, cool, cool.
      • 2019-05-01 12102, 2019

      • iliekcomputers
        i triggered the reindex.
      • 2019-05-01 12103, 2019

      • Mr_Monkey
        Are you reindexing?
      • 2019-05-01 12107, 2019

      • Mr_Monkey
        OK
      • 2019-05-01 12114, 2019

      • iliekcomputers
        {"success":true}
      • 2019-05-01 12120, 2019

      • Mr_Monkey
        Great
      • 2019-05-01 12145, 2019

      • iliekcomputers
        ok, docker-server-configs changes to point bookbrainz.org
      • 2019-05-01 12149, 2019

      • iliekcomputers
        to gateways
      • 2019-05-01 12155, 2019

      • iliekcomputers
        zas: ping?
      • 2019-05-01 12101, 2019

      • zas
        pooong
      • 2019-05-01 12103, 2019

      • iliekcomputers
        can you point bookbrainz.org to gateways?
      • 2019-05-01 12104, 2019

      • Mr_Monkey
        On it for the PR
      • 2019-05-01 12108, 2019

      • zas
        ok
      • 2019-05-01 12117, 2019

      • iliekcomputers
        Mr_Monkey: cool cool cool.
      • 2019-05-01 12147, 2019

      • iliekcomputers
        Mr_Monkey: i changed the callback url for the BB app to https://bookbrainz.org/cb
      • 2019-05-01 12111, 2019

      • zas
        done, ttl is 5 mins
      • 2019-05-01 12109, 2019

      • zas
        hmmm weird, i got an ssl error
      • 2019-05-01 12117, 2019

      • zas
        iliekcomputers: imho you need to change https://github.com/metabrainz/docker-server-confi…
      • 2019-05-01 12130, 2019

      • Mr_Monkey
        zas: I just opened a PR for that
      • 2019-05-01 12135, 2019

      • iliekcomputers
        zas: yep, Mr_Monkey was doing that afaik.
      • 2019-05-01 12115, 2019

      • zas
        lgtm
      • 2019-05-01 12141, 2019

      • zas
        btw, when the switch will be fully completed, we'll make a snapshot of the gcloud VM and stop it
      • 2019-05-01 12154, 2019

      • Mr_Monkey
        OK, liekcomputers, I'm pulling the merged PR and restarting containers
      • 2019-05-01 12131, 2019

      • Mr_Monkey
        Ah, no need.
      • 2019-05-01 12138, 2019

      • iliekcomputers
        Mr_Monkey:yo!
      • 2019-05-01 12144, 2019

      • iliekcomputers
        it works for me.
      • 2019-05-01 12147, 2019

      • iliekcomputers
        login does too.
      • 2019-05-01 12147, 2019

      • Mr_Monkey
        Well, it looks to me like we've just migrated.
      • 2019-05-01 12156, 2019

      • iliekcomputers
        wow, a release i didn't fuck up
      • 2019-05-01 12100, 2019

      • iliekcomputers
        nice!
      • 2019-05-01 12106, 2019

      • Mr_Monkey
        You and me both !
      • 2019-05-01 12109, 2019

      • iliekcomputers
        last migration took me 15 hrs :D
      • 2019-05-01 12111, 2019

      • Mr_Monkey
        High five !
      • 2019-05-01 12115, 2019

      • iliekcomputers
        <3 <3
      • 2019-05-01 12129, 2019

      • Mr_Monkey
        Let me tweet tweet tweet
      • 2019-05-01 12135, 2019

      • iliekcomputers
        let's keep a look out on cron dumps
      • 2019-05-01 12136, 2019

      • zas
        good job guys ! Next level: do it without any downtime ;)
      • 2019-05-01 12138, 2019

      • iliekcomputers
        right, i triggered a dump and it worked.
      • 2019-05-01 12120, 2019

      • zas
        i'll update nagios checks for it
      • 2019-05-01 12131, 2019

      • iliekcomputers
        thanks zas !
      • 2019-05-01 12138, 2019

      • Mr_Monkey
        Thanks zas! And yes as you pointed out that leaves cleaning up the VM
      • 2019-05-01 12157, 2019

      • Mr_Monkey
        Oh, and putting the DNS TTL back to a sane value?
      • 2019-05-01 12153, 2019

      • Mr_Monkey
        zas: mind if we keep the VM up for another few days, just in case?
      • 2019-05-01 12122, 2019

      • iliekcomputers
        yea, we probably should.
      • 2019-05-01 12130, 2019

      • zas
        yes, few days, but when sure, ping me so i archive/stop it
      • 2019-05-01 12143, 2019

      • Mr_Monkey
        Cool, thanks
      • 2019-05-01 12146, 2019

      • zas
        i'll increase ttl again
      • 2019-05-01 12134, 2019

      • zas
        done
      • 2019-05-01 12139, 2019

      • zas
        now updating nagios stuff
      • 2019-05-01 12141, 2019

      • Mr_Monkey
        Yay, we didn't faceplant! Thanks iliekcomputers
      • 2019-05-01 12135, 2019

      • iliekcomputers
        ❤️❤️
      • 2019-05-01 12118, 2019

      • zas
        nagios done
      • 2019-05-01 12103, 2019

      • iliekcomputers
        thanks zas ! <3
      • 2019-05-01 12110, 2019

      • michelv__ joined the channel
      • 2019-05-01 12132, 2019

      • amCap1712 joined the channel
      • 2019-05-01 12133, 2019

      • Mr_Monkey
        zas: I haven't seen an OK message from nagios for BB. Does it just take some time to take effect?
      • 2019-05-01 12136, 2019

      • Cyna joined the channel
      • 2019-05-01 12139, 2019

      • Cyna
        ```Then you'll need to pass it somehow. $form->options_parent_id($model) seems to give you the right thing on the Perl side, but not sure why it doesn't directly work if I try to pass it as a prop, so you might need some TO_JSON option which is not 100% straightforward``` I didnt get what you said
      • 2019-05-01 12102, 2019

      • Cyna
        reosarevok: If the options for parent id is in $form->options_parent_id($model) then is should also be inside $form. But such is not the case
      • 2019-05-01 12126, 2019

      • letaiv
        Hi guys, unfortunately I have to withdraw my GSoC application due to changes in my PhD program
      • 2019-05-01 12113, 2019

      • reosarevok
        Cyna: $form->options_parent_id() is a function provided by the class, not a variable
      • 2019-05-01 12154, 2019

      • reosarevok
        So unless you run it, you won't get the result
      • 2019-05-01 12110, 2019

      • Cyna
        I'll see it it works... Will bounce back in a but
      • 2019-05-01 12112, 2019

      • Cyna
        *bit
      • 2019-05-01 12117, 2019

      • letaiv has quit
      • 2019-05-01 12140, 2019

      • michelv__ has quit
      • 2019-05-01 12107, 2019

      • Cyna
        reosarevok: it worked thanks. could you tell me where can I find the classes defined in perl, for eg form class as you mentioned
      • 2019-05-01 12129, 2019

      • Cyna
        nevermind found it in /lib/musicbrainz/server