bitmap: hey, sorry, I don't remember the exact reason (should've put it in the commit), but I have a feeling the AB database wasn't showing up with that check, for some reason or the other.
2020-05-18 13902, 2020
Mr_Monkey
Moin
2020-05-18 13959, 2020
jmp_music joined the channel
2020-05-18 13939, 2020
prabal
Morningg
2020-05-18 13911, 2020
jmp_music
Morning!
2020-05-18 13901, 2020
Gazooo has quit
2020-05-18 13946, 2020
ZaphodBeeblebrox joined the channel
2020-05-18 13946, 2020
ZaphodBeeblebrox has quit
2020-05-18 13946, 2020
ZaphodBeeblebrox joined the channel
2020-05-18 13950, 2020
Gazooo joined the channel
2020-05-18 13954, 2020
CatQuest has quit
2020-05-18 13914, 2020
shivam-kapila
Morning
2020-05-18 13927, 2020
yvanzo
mo’’in’
2020-05-18 13951, 2020
diru1100
Mo''in' !
2020-05-18 13953, 2020
ruaok
'ooooin!
2020-05-18 13954, 2020
v6lur_ joined the channel
2020-05-18 13939, 2020
Mr_Monkey
ruaok: I just upgraded my local PG version, did the update kerfuffle, ran the tests and checked manually. No snag, everything working fine. I'mm adding a couple of steps to the migration document regarding BB
2020-05-18 13905, 2020
ruaok
very good. thanks for getting on that so quick. :)
2020-05-18 13952, 2020
ruaok
do you have postgres functions in BB? one of the changes that affects us are functions now need to be fully qualified with schema name. that is the only thing that I see as a real snag.
2020-05-18 13954, 2020
Mr_Monkey
One question I have is regarding the DB update script that's going to be run. I have no visibility on it (no access to metabrainz/docker-postgres-cluster ?) so I just want to make sure there's nothing else I need to do to point to BB's database
2020-05-18 13917, 2020
Mr_Monkey
I wouldn't even know what a function looks like, so I guess that's a no. i'll check.
2020-05-18 13939, 2020
ruaok
where are your DB creation scripts? gimme a link and I'll help.
2020-05-18 13936, 2020
ruaok
regarding the update process -- from your perspective, the DB will go down and eventually come back running 12.3.
2020-05-18 13900, 2020
ruaok
if no changes are necessary perhaps you need to do nothing at all.
2020-05-18 13904, 2020
Mr_Monkey
Right. Nothing to add to say "don't forgot database 'bookbrain' then. Perfect :)
and you've run through database creation and tests with PG12?
2020-05-18 13908, 2020
ruaok
if all that passes, then I think you're good to go.
2020-05-18 13952, 2020
Mr_Monkey
Haven't created a DB from scratch yet on 12; that's my next step. Tests all pass and I've ensured the triggers do work. Not sure if it's any different if they're recreated from scratch
2020-05-18 13900, 2020
Mr_Monkey
Gonna check all that now.
2020-05-18 13904, 2020
ruaok
the migration is scheduled for 5ish (CET) today. you should be at the ready to address issues as they come up. we're all pretty much going to be standing by and ready to jump if something goes wrong.
2020-05-18 13933, 2020
Mr_Monkey
Yep. I tweeted about planned downtime earlier.
2020-05-18 13948, 2020
ruaok
good thinking.
2020-05-18 13936, 2020
alastairp
this shouldn't affect AB, right?
2020-05-18 13949, 2020
alastairp
do you need any help with LB/MsB/CB?
2020-05-18 13902, 2020
ruaok
I dont anticipate it affecting AB, since AB has its own DB. But its a very inter connected system, so hard to tell.
2020-05-18 13911, 2020
ruaok
I think we're set on the other projects.
2020-05-18 13923, 2020
ruaok
but you being around during release time would be good.
2020-05-18 13940, 2020
alastairp
I'll be here
2020-05-18 13912, 2020
ruaok
sweet
2020-05-18 13918, 2020
iliekcomputers
No meeting today then, right?
2020-05-18 13939, 2020
ruaok
depends. if all goes well, we might have one.
2020-05-18 13920, 2020
iliekcomputers
ishaanshah[m]: we should probably cancel or reschedule our meeting today. The channel will be busy.
> we should probably cancel or reschedule our meeting today. The channel will be busy.
2020-05-18 13955, 2020
ishaanshah[m]
iliekcomputers: Sure, does 7pm IST good for you?
2020-05-18 13929, 2020
yvanzo
metabrainz/base-image:latest is the same as metabrainz/base-image:v0.9.22-1 by a few log files (using container-diff), is there something to know about other v0.9.22-X tags?
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | GSoC students start here: https://bit.ly/2NUaxgb | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Meeting agenda (today is "schema chance" day, might not be a meeting—stay tuned!): Reviews
2020-05-18 13918, 2020
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | GSoC students start here: https://bit.ly/2NUaxgb | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Meeting agenda (today is "schema change" day, might not be a meeting—stay tuned!): Reviews
2020-05-18 13956, 2020
cloverfield has quit
2020-05-18 13912, 2020
cloverfield joined the channel
2020-05-18 13906, 2020
ruaok
bitmap: the CAA needs to be taken down as well, right? I'm reviewing the migration doc...
2020-05-18 13913, 2020
bitmap
yeah, though I think we can leave the actual containers running - it'll come down at the gateway and the PG consul service will be down
2020-05-18 13904, 2020
ruaok
yeah, I'm looking at LB right now and we have a pile of containers and I think it might just be best to take them all down.
2020-05-18 13910, 2020
ruaok
how long do you think the downtime will be?
2020-05-18 13940, 2020
iliekcomputers
ruaok: I would not take cron down
2020-05-18 13956, 2020
iliekcomputers
It's doing a full dump.
2020-05-18 13909, 2020
iliekcomputers
Happy to merge #862
2020-05-18 13910, 2020
bitmap
I'm hoping for less than 1.5 hours... depends on how long vacuuming & backups take
2020-05-18 13929, 2020
ruaok
are you sure that isn't going to hold any connections to PG, iliekcomputers ?
2020-05-18 13909, 2020
bitmap
the actual pg upgrade is pretty fast. MB has to recreate some indexes which takes a bit of time too
2020-05-18 13910, 2020
MajorLurker has quit
2020-05-18 13922, 2020
bitmap
though I was testing this all on williams and it should be much faster on floyd, so
2020-05-18 13935, 2020
iliekcomputers
Can't say for certain. :/
2020-05-18 13953, 2020
iliekcomputers
Take it down, I guess. I'll trigger a full dump again today.
2020-05-18 13924, 2020
ruaok
let's try and keep it up. if a connection remains, let's take it down. I'll note that in the doc.
