#metabrainz

/

      • Bajax8 joined the channel
      • 2018-09-17 26034, 2018

      • Bajax8 has quit
      • 2018-09-17 26056, 2018

      • yeti1 joined the channel
      • 2018-09-17 26056, 2018

      • yeti1 has quit
      • 2018-09-17 26018, 2018

      • bukwurm has quit
      • 2018-09-17 26043, 2018

      • dshwang joined the channel
      • 2018-09-17 26045, 2018

      • dshwang has quit
      • 2018-09-17 26013, 2018

      • mr_yogurt26 joined the channel
      • 2018-09-17 26016, 2018

      • mr_yogurt26 has quit
      • 2018-09-17 26043, 2018

      • Leo_Verto_ joined the channel
      • 2018-09-17 26013, 2018

      • Leo_Verto has quit
      • 2018-09-17 26013, 2018

      • Leo_Verto_ is now known as Leo_Verto
      • 2018-09-17 26005, 2018

      • LogicalApex1 joined the channel
      • 2018-09-17 26007, 2018

      • LogicalApex1 has quit
      • 2018-09-17 26033, 2018

      • Gore|woerk joined the channel
      • 2018-09-17 26024, 2018

      • outsidecontext joined the channel
      • 2018-09-17 26026, 2018

      • github joined the channel
      • 2018-09-17 26026, 2018

      • github has left the channel
      • 2018-09-17 26059, 2018

      • github joined the channel
      • 2018-09-17 26059, 2018

      • github has left the channel
      • 2018-09-17 26054, 2018

      • MusicbrainzB0T joined the channel
      • 2018-09-17 26020, 2018

      • bavrogar2 joined the channel
      • 2018-09-17 26020, 2018

      • bavrogar2 has quit
      • 2018-09-17 26035, 2018

      • travis-ci joined the channel
      • 2018-09-17 26036, 2018

      • travis-ci
        metabrainz/picard#3756 (master - 79ee67e : Philipp Wolfer): The build passed.
      • 2018-09-17 26037, 2018

      • travis-ci
      • 2018-09-17 26037, 2018

      • travis-ci
      • 2018-09-17 26037, 2018

      • travis-ci has left the channel
      • 2018-09-17 26057, 2018

      • MusicbrainzB0T2 has quit
      • 2018-09-17 26028, 2018

      • travis-ci joined the channel
      • 2018-09-17 26029, 2018

      • travis-ci
        metabrainz/picard#3756 (master - 79ee67e : Philipp Wolfer): The build passed.
      • 2018-09-17 26029, 2018

      • travis-ci
      • 2018-09-17 26029, 2018

      • travis-ci
      • 2018-09-17 26029, 2018

      • travis-ci has left the channel
      • 2018-09-17 26024, 2018

      • UmkaDK joined the channel
      • 2018-09-17 26058, 2018

      • iliekcomputers
        Moin!!
      • 2018-09-17 26014, 2018

      • CatQuest
        morn!
      • 2018-09-17 26021, 2018

      • github joined the channel
      • 2018-09-17 26021, 2018

      • github has left the channel
      • 2018-09-17 26023, 2018

      • iliekcomputers
        ruaok: alastairp: the import worked with the PR i opened on saturday.
      • 2018-09-17 26015, 2018

      • adam-652049326 joined the channel
      • 2018-09-17 26017, 2018

      • adam-652049326 has quit
      • 2018-09-17 26048, 2018

      • ruaok
        moin!
      • 2018-09-17 26056, 2018

      • ruaok
        that's great. how many hours did that take?
      • 2018-09-17 26018, 2018

      • Sophist-UK has quit
      • 2018-09-17 26057, 2018

      • Sophist-UK joined the channel
      • 2018-09-17 26002, 2018

      • iliekcomputers
        ruaok: 50 min
      • 2018-09-17 26016, 2018

      • ruaok
        not that bad.
      • 2018-09-17 26039, 2018

      • ruaok
        so, now we have mostly up to date data in frank? can we start the actual migration which then copies the data we received since then?
      • 2018-09-17 26000, 2018

      • iliekcomputers
        only a different of 10k recordings between frank and spike.
      • 2018-09-17 26015, 2018

      • ruaok
        ok
      • 2018-09-17 26036, 2018

      • iliekcomputers
      • 2018-09-17 26048, 2018

      • iliekcomputers
        and then start the migration.
      • 2018-09-17 26049, 2018

      • ruaok
        I have a few random things I need to do this morning, but this afternoon -- should do the migration then?
      • 2018-09-17 26012, 2018

      • iliekcomputers
        in say 2-3 hours?
      • 2018-09-17 26021, 2018

      • iliekcomputers
        i'm down anytime tbh.
      • 2018-09-17 26044, 2018

      • ruaok
        should alastairp and zas be around for this?
      • 2018-09-17 26007, 2018

      • zas
        i'm around
      • 2018-09-17 26015, 2018

      • ruaok
        alastairp?
      • 2018-09-17 26008, 2018

      • ruaok
        iliekcomputers: how confident are you in getting this right without alastairp ?
      • 2018-09-17 26015, 2018

      • ruaok
        should we try and do it now?
      • 2018-09-17 26056, 2018

      • iliekcomputers
        should be okay.
      • 2018-09-17 26019, 2018

      • ruaok
        ok, then let's do it.
      • 2018-09-17 26034, 2018

      • ruaok
        get prepared, I'll post a quick blog post and a tweet. 2-3 minutes/
      • 2018-09-17 26050, 2018

      • iliekcomputers
        great, i'll merge the PR and push a new docker image first.
      • 2018-09-17 26023, 2018

      • github joined the channel
      • 2018-09-17 26024, 2018

      • github has left the channel
      • 2018-09-17 26049, 2018

      • iliekcomputers
        pushing image to docker hub.
      • 2018-09-17 26038, 2018

      • ruaok
        blog post up.
      • 2018-09-17 26005, 2018

      • ruaok
      • 2018-09-17 26051, 2018

      • iliekcomputers
        latest AB running on boingo
      • 2018-09-17 26013, 2018

      • ruaok
        tweeted.
      • 2018-09-17 26018, 2018

      • ruaok
        ready?
      • 2018-09-17 26021, 2018

      • iliekcomputers
        okay, gonna bring spike down now.
      • 2018-09-17 26023, 2018

      • iliekcomputers
        yeah.
      • 2018-09-17 26033, 2018

      • ruaok
        ok, go.
      • 2018-09-17 26044, 2018

      • iliekcomputers
        done.
      • 2018-09-17 26048, 2018

      • iliekcomputers
        should be down now.
      • 2018-09-17 26054, 2018

      • alastairp
        hi
      • 2018-09-17 26001, 2018

      • ruaok
        I get a sexy 502 on AB. :)
      • 2018-09-17 26003, 2018

      • iliekcomputers
      • 2018-09-17 26003, 2018

      • ruaok
        hi alastairp
      • 2018-09-17 26015, 2018

      • ruaok
        I'll update the doc as you go
      • 2018-09-17 26016, 2018

      • iliekcomputers
        let me bring the downtime page up now..
      • 2018-09-17 26028, 2018

      • ruaok
        k
      • 2018-09-17 26052, 2018

      • Freso
        Wizzup: You still don't have wiki access, right? legoktm never got back to you?
      • 2018-09-17 26028, 2018

      • github joined the channel
      • 2018-09-17 26028, 2018

      • github has left the channel
      • 2018-09-17 26002, 2018

      • iliekcomputers
        nginx restarted with new config
      • 2018-09-17 26053, 2018

      • ruaok
        502 page up.
      • 2018-09-17 26057, 2018

      • ruaok
        (still)
      • 2018-09-17 26006, 2018

      • ruaok
        start the data dumps, go back to the 502 page fix in a bit.
      • 2018-09-17 26010, 2018

      • iliekcomputers
        okay.
      • 2018-09-17 26006, 2018

      • iliekcomputers
        Creating incremental dumps with data between 2018-09-14 14:32:43.269234+02:00 and 2018-09-17 11:16:57.621327+02:00:
      • 2018-09-17 26049, 2018

      • iliekcomputers
        where do I see nginx logs? :P
      • 2018-09-17 26007, 2018

      • ruaok
        /var/log/nginx
      • 2018-09-17 26049, 2018

      • ruaok
        2018/09/17 11:18:23 [error] 12661#0: *107 connect() to unix:/tmp/acousticbrainz.uwsgi.sock failed (111: Connection refused) while connecting to upstream, client: 78.148.81.227, server: acousticbrainz.org, request: "GET /login/?next=/3d1bd371-faec-4a5a-bcd3-008b2d3e9925/low-level/view HTTP/1.1", upstream: "uwsgi://unix:/tmp/acousticbrainz.uwsgi.sock:", host: "acousticbrainz.org"
      • 2018-09-17 26055, 2018

      • iliekcomputers
        dump done.
      • 2018-09-17 26011, 2018

      • iliekcomputers
        dumping private tables.
      • 2018-09-17 26023, 2018

      • alastairp
        so, the is_down isn't working?
      • 2018-09-17 26034, 2018

      • ruaok
        uwsgi isnt running.
      • 2018-09-17 26049, 2018

      • alastairp
        shouldn't be an issue? it's an nginx feature
      • 2018-09-17 26039, 2018

      • iliekcomputers
        dumps done.
      • 2018-09-17 26047, 2018

      • ruaok
        keep going, iliekcomputers
      • 2018-09-17 26055, 2018

      • iliekcomputers
        downloading to boingo
      • 2018-09-17 26040, 2018

      • iliekcomputers
        downloaded.
      • 2018-09-17 26048, 2018

      • ruaok
        feh. screw the update that. :)
      • 2018-09-17 26013, 2018

      • iliekcomputers
        importing data.
      • 2018-09-17 26049, 2018

      • iliekcomputers
        why is the is_down not working...
      • 2018-09-17 26002, 2018

      • ruaok
        worry not.
      • 2018-09-17 26016, 2018

      • iliekcomputers
        creating constraints again.
      • 2018-09-17 26021, 2018

      • ruaok
        DNS record ready to be changed
      • 2018-09-17 26030, 2018

      • iliekcomputers
        okay incremental dump imported
      • 2018-09-17 26034, 2018

      • iliekcomputers
        gonna do the private tables now.
      • 2018-09-17 26038, 2018

      • ruaok
        k
      • 2018-09-17 26004, 2018

      • ruaok
        should I update the DNS record or do we want to do a sanity check on the new site?
      • 2018-09-17 26026, 2018

      • alastairp
        it'd be nice to have a sanity check of database contents
      • 2018-09-17 26037, 2018

      • ruaok
        ok, holding then.
      • 2018-09-17 26037, 2018

      • alastairp
        same number of rows, etc
      • 2018-09-17 26020, 2018

      • alastairp
        I'll do count(*) on spike on lowlevel, lowlevel_json, highlevel, highlevel_model
      • 2018-09-17 26025, 2018

      • alastairp
        iliekcomputers: can you do the same on new?
      • 2018-09-17 26030, 2018

      • iliekcomputers
        okay, great.
      • 2018-09-17 26037, 2018

      • iliekcomputers
        "user" is same on both.
      • 2018-09-17 26054, 2018

      • ruaok
        alastairp has no access to the new infrastructure yet.
      • 2018-09-17 26011, 2018

      • alastairp
        ruaok: correct, and I'm on that today or tomorrow
      • 2018-09-17 26012, 2018

      • iliekcomputers
      • 2018-09-17 26020, 2018

      • alastairp
        same
      • 2018-09-17 26027, 2018

      • iliekcomputers
      • 2018-09-17 26042, 2018

      • iliekcomputers
      • 2018-09-17 26054, 2018

      • iliekcomputers
      • 2018-09-17 26001, 2018

      • alastairp
        haha, I think frank is faster than spike. still counting lljson
      • 2018-09-17 26009, 2018

      • Mr_Queue24 joined the channel
      • 2018-09-17 26009, 2018

      • Mr_Queue24 has quit
      • 2018-09-17 26013, 2018

      • iliekcomputers
        :)
      • 2018-09-17 26023, 2018

      • zas
        down not working ? for ?
      • 2018-09-17 26035, 2018

      • zas
      • 2018-09-17 26045, 2018

      • ruaok
        zas: correct.
      • 2018-09-17 26047, 2018

      • iliekcomputers
        zas: that was the one i wrote up for spike.
      • 2018-09-17 26052, 2018

      • ruaok
        we gave up on it.
      • 2018-09-17 26004, 2018

      • iliekcomputers
        bringing the gateways down rn.
      • 2018-09-17 26014, 2018

      • iliekcomputers
        bringing the hetzner AB service*
      • 2018-09-17 26019, 2018

      • ruaok
        phew.
      • 2018-09-17 26025, 2018

      • iliekcomputers
        lol
      • 2018-09-17 26037, 2018

      • alastairp
        iliekcomputers: please confirm highlevel_model
      • 2018-09-17 26046, 2018

      • alastairp
        should have 180 million rows
      • 2018-09-17 26007, 2018

      • alastairp
      • 2018-09-17 26058, 2018

      • iliekcomputers
      • 2018-09-17 26000, 2018

      • iliekcomputers
        :/
      • 2018-09-17 26005, 2018

      • iliekcomputers
        wtf
      • 2018-09-17 26021, 2018

      • alastairp
        I suspect the dump is wrong