zas: I'd like to move the postgres instance on williams to paco, rn williams is a bit too overloaded with json dumps, search index dumps, barman backups, jenkins builds, and slow disks
2020-05-17 13858, 2020
supersandro2000 has quit
2020-05-17 13801, 2020
supersandro20006 joined the channel
2020-05-17 13816, 2020
bitmap
can barely run a 200GB rsync locally without waiting 3 hours :/
2020-05-17 13854, 2020
bitmap
lmk if there's a better spot but looks like paco has enough space and is relatively underused
hey. so, pg12 coming tomorrow. I failed to put that on our radar.
2020-05-17 13850, 2020
ruaok
which means that PG 9.5 goes down and then comes back up and migrated as far as CB, LB and MeB are concerned.
2020-05-17 13812, 2020
iliekcomputers
Hmm, I saw the PR.
2020-05-17 13815, 2020
ruaok
I *think* it will be a non-event.
2020-05-17 13839, 2020
iliekcomputers
Does the password thing mean that we'll have to release new versions of LB and CB
2020-05-17 13840, 2020
iliekcomputers
?
2020-05-17 13851, 2020
iliekcomputers
Or is that for dev only?
2020-05-17 13854, 2020
ruaok
unsure. let me see about passwords in production.
2020-05-17 13836, 2020
ruaok
but I think that thing for us to do is to put passwords on all PG accounts going forward. that should avoid trouble.
2020-05-17 13839, 2020
ruaok
the password is specified in consul_config.py.ctmpl, so it should be fine.
2020-05-17 13808, 2020
ruaok
things even seem to work with the pg9.5 postgresql client inside docker images.
2020-05-17 13835, 2020
ruaok
however, the messybrainz tests are all failing and they are setup differently than the LB tests.
2020-05-17 13805, 2020
ruaok
can you please take a look and see how to set the password for the messybrainz tests?
2020-05-17 13815, 2020
iliekcomputers
Yeah, I can look at that.
2020-05-17 13820, 2020
ruaok
thx.
2020-05-17 13832, 2020
ruaok
once we get LB tucked away we need to look at MeB and CB.
2020-05-17 13857, 2020
iliekcomputers
I think it might be better if you take MeB, I'll take LB and then we'll circle back to CB
2020-05-17 13811, 2020
ruaok
sure, that works.
2020-05-17 13812, 2020
iliekcomputers
LB is mostly done anyways, thanks to your PR.
2020-05-17 13821, 2020
ruaok
on Meb as we speak.
2020-05-17 13832, 2020
ruaok
and CB is likely to be very similar to MeB.
2020-05-17 13832, 2020
CatQuest
Gratulerer med Dagen!
2020-05-17 13821, 2020
CatQuest
🇳🇴
2020-05-17 13802, 2020
Gazooo has quit
2020-05-17 13841, 2020
Gazooo joined the channel
2020-05-17 13815, 2020
ruaok
all meb tests pass with pg12.3
2020-05-17 13846, 2020
ruaok
iliekcomputers: should I look at how to install postgres-client-12 or have you looked into that already?
2020-05-17 13801, 2020
iliekcomputers
i'm looking at the tests
2020-05-17 13812, 2020
iliekcomputers
go ahead
2020-05-17 13816, 2020
ruaok
ok
2020-05-17 13820, 2020
iliekcomputers
that way i can cargo-cult :D
2020-05-17 13833, 2020
ruaok
obvs
2020-05-17 13802, 2020
iliekcomputers
8 messybrainz tests failing...
2020-05-17 13834, 2020
iliekcomputers
they seem to be actual issues
2020-05-17 13824, 2020
iliekcomputers
i don't think we run any of this code at all in prod
2020-05-17 13852, 2020
iliekcomputers
it's from kartikeya's gsoc project
2020-05-17 13832, 2020
ruaok
oh, that is why absolutely nothing made sense yesterday.
2020-05-17 13808, 2020
ruaok
messybrainz may have one problem we should look at.
2020-05-17 13856, 2020
ruaok
pg12 requires function names to be fully qualified. and when I import the msb data into timescale, which is pg12, there are problems resolving the array_agg function.
2020-05-17 13801, 2020
iliekcomputers
do we use array_agg somewhere in prod
2020-05-17 13813, 2020
ruaok
yes. array_agg is used by artist_sort. And neither calls to array_sort are qualified.
2020-05-17 13826, 2020
ruaok
db/artist.py uses array_sort.
2020-05-17 13839, 2020
ruaok
doesn't look like a huge problem
2020-05-17 13855, 2020
iliekcomputers
oh yeah, artist.py is the 8 failing tests
2020-05-17 13816, 2020
ruaok
but that may all be unused code from katikeyas project, I would guess.
2020-05-17 13832, 2020
ruaok
quite frankly we could back that code out if you prefer.
2020-05-17 13840, 2020
ruaok
the mapping is the way forward for the time being.
2020-05-17 13801, 2020
ruaok
if the other approach gets picked up again, we can cobble together code from it.
2020-05-17 13823, 2020
iliekcomputers
yeah, make sense.
2020-05-17 13832, 2020
iliekcomputers
i'll try to fix the array_agg and see what happens
