#metabrainz

Project bookbrainz-data-js build #1037: passed in 1 min 38 sec: https://travis-ci.org/bookbrainz/bookbrainz-dat...

milkii: I was just about to open a ticket on your behalf, but I see you did so yourself already (PICARD-1508). :)

PICARD-1508: Crash on opening options if dest dir is on unmounted drive https://tickets.metabrainz.org/browse/PICARD-1508

Freso: hehe, though i should log it properly

milkii: Good job. :)

(And thank you!)

Mr_Monkey: moin!

Hi iliekcomputers ! Sorry, had an alarm clock failure…

Hi zas ! Are you around today for a dns change?

No worries. I have a college thing in like 40 min. Do you wanna start once i get back?

Sure

iliekcomputers: roughly how long do you think?

10-15 min at most

Oh, OK :p

I'm gonna be here fully from 5 PM IST.

I was thinking 2-3 hours, thinking about lunch plans and all that :p

Ahh

When do you lunch?

I'll do that now-ish and be free at 5PM IST

Ah, cool!

Hopefully we're done in minutes :) :)

Mr_Monkey: how many tables does the db have?

Might be good to write a script to count number of rows in each table for a consistency check.

I can do that today.

That would be great :)

iliekcomputers: 240 tables

Yikes lol

61 of which are on the bookbrainz schema

Mr_Monkey: yup, just ping me when you need

Hello zas! Could you please change the DNS TTL to 5 minutes for BookBrainz.org?

Be around in just 10-15 min, if that's okay.

K

* I'll be around.

Mr_Monkey: ttl is on 300 seconds already

Ah, I hadn't realised, thanks zas

No rush iliekcomputers

Mr_Monkey: i'm here, sorry!

No worries !

Do you need more time?

nope, here totally now

yo!

All right, let's do this then :)

let's migrate the db once before bringing the site down.

I'm down with that. do you want to do the honnors?

yea, sure.

in the meanwhile, can you come up with a list of tables that we should check for consistency in rows?

Yep

new db created.

OK, time to take a dump.

I'm set up to compare rows

wokay, creating dump on the vm.

The dumps are so fast on BB

For now

not a bad place to pay people from, no?

if you sent your invoice in already, its paid. the rest of you: Slackers!

Damn, I always forget the month ends.

Enjoy, ruaok !

ok dump copied over

and imported into postgres master

sorry for the lateness, some network problems

OK, let me compare rows

https://bookbrainz.org/ returns a 404 atm

Did you stop the service iliekcomputers ?

yes.

do the rows look ok?

Ah, I thought we were doing a dry run. Well, zas it'll be down fora short period of time

iliekcomputers: Checking now

Mr_Monkey: do you have a script to test?

iliekcomputers: I'm checking manually

ah.

what tables, maybe I can do the counts on vm and you on bowie

iliekcomputers: Just saw this, sorry. It all looks good!

ahh

woohoo nice!

i checked new.bookbrainz and it looks sane to me.

search works.

Let me add an item to make sure

iliekcomputers: A-OK

cool, cool, cool.

i triggered the reindex.

Are you reindexing?

OK

{"success":true}

Great

ok, docker-server-configs changes to point bookbrainz.org

to gateways

zas: ping?

pooong

can you point bookbrainz.org to gateways?

On it for the PR

ok

Mr_Monkey: cool cool cool.

Mr_Monkey: i changed the callback url for the BB app to https://bookbrainz.org/cb

done, ttl is 5 mins

hmmm weird, i got an ssl error

iliekcomputers: imho you need to change https://github.com/metabrainz/docker-server-con...

zas: I just opened a PR for that

zas: yep, Mr_Monkey was doing that afaik.

lgtm

btw, when the switch will be fully completed, we'll make a snapshot of the gcloud VM and stop it

OK, liekcomputers, I'm pulling the merged PR and restarting containers

Ah, no need.

Mr_Monkey:yo!

it works for me.

login does too.

Well, it looks to me like we've just migrated.

wow, a release i didn't fuck up

nice!

You and me both !

last migration took me 15 hrs :D

High five !

<3 <3

Let me tweet tweet tweet

let's keep a look out on cron dumps

good job guys ! Next level: do it without any downtime ;)

right, i triggered a dump and it worked.

i'll update nagios checks for it

thanks zas !

Thanks zas! And yes as you pointed out that leaves cleaning up the VM

Oh, and putting the DNS TTL back to a sane value?

zas: mind if we keep the VM up for another few days, just in case?

yea, we probably should.

yes, few days, but when sure, ping me so i archive/stop it

Cool, thanks

i'll increase ttl again

done

now updating nagios stuff

Yay, we didn't faceplant! Thanks iliekcomputers

❤️❤️

nagios done