lucifer: it could really use more docstrings, but a lot of these classes are derived so they are not really needed.
but for base classes like UserEntity, please add docstrings and then for the derived classes add a note about looking at the base class for docs. how does that sound?
lucifer: I *finally* got past the "stale DB handle" problem in mb_metadata_cache.
the whole process would finish and the with .... : statement that opened the DB connection would, I guess, fail to cleanup the collection and then threw an error. when nothing really went wrong. lame.
so now I can setting a success flag and if that is set, then ignore the error. its finally moved on to building the artist data -- first time in months from what I can see.
zas[m]
mayhem: julian45 the report might be for metabrainz/docker-rsyncd container running on aretha
yvanzo[m]
bitmap, lucifer, reosarevok: ping 🏓
mayhem[m]
ohhhhhh. I didn't consider that.
julian45[m]
zas[m]: good point, i will poke at that when i get a second
lucifer[m]
mayhem: ahaan i see, makes sense.
yvanzo: hi!
reosarevok[m]
Hi!
mayhem[m]
zas: metabrainz.org is down for some reason. I restarted the container, just in case. no errors, but the page doesn't load.
mayhem: lucifer please ping me when the server is up and stable, I'm planning to make a release. Want things working so another release doesn't get rejected.
mayhem[m]
MB is up and working totally fine. But other projects connecting to the DB are not fine. Did the PG accounts for the other projects get borked?
jasje[m]: we'd like that too!
monkey[m]
BookBrainz seems to be loading fine. One difference is that it only connects to the BB database (so DB server OK, MB DB having issues?)
mayhem[m]
MB loads fine too!
it seems the non-MB accounts in PG are not happy.
monkey[m]
Wouldn't that affect BB too?
mayhem[m]
does BB use MB?
monkey[m]
Not the MB DB, but it uses the same PG instance, with its own account
mayhem[m]
understood.
those appear to be working fine, but from what I can gather, the non mb account are not working right.
reosarevok[m]
What does CB use?
Because that seems fine
mayhem[m]
unsure.
monkey[m]
MB and BB databases
Not sure WRT PG accounts, but I assume its own account
mayhem[m] posts to bsky
bitmap[m]
<mayhem[m]> "bitmap: are you around?" <- I'm here
mayhem[m]
good morning!
could you please help with diagnosing a problem
yvanzo[m]
Hi bitmap: Sorry, I have to go soon.
mayhem[m]
LB and MeB are currently down.
it seems that connections to the MB DB are being rejected.
CB and BB are fine. MB is totally fine.
bitmap[m]
sorry I'm late yvanzo
yvanzo[m]
reosarevok: Please report issues to all of us (bitmap, lucifer and I) when you find these, without waiting for the next meeting, or we will hardly make any progress.
bitmap[m]
are they connecting to jimmy or hendrix?
mayhem[m]
bitmap[m]: unsure, let me dig
lucifer[m]
should be connecting to current master
mayhem[m]
10.2.2.25:65436
hendrix
yvanzo[m]
bitmap: No worries, thanks for the new PR.
Let’s postpone the meeting to another time, when there are no ongoing maintenance issues.
reosarevok[m]
Ok, I can look into testing the PR in the meantime - should we try again tomorrow?
lucifer: this query has been flagged as slow -- its possible that that backed things up and when I ran the cron job it overloaded PG bouncer.
lucifer[m]
mayhem: yes i am creating an index to try speed it up
mayhem[m]
fabulous/
lucifer[m]
-------------------------------------------------------------------------------------------------------------------------------------------------... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)
seems to have worked.
mayhem[m]
very good.
zas[m]
I restarted metabrainz web container, and it works
bitmap[m]
I increase the pool sizes I bit
lucifer[m]
i restarted lb web as well
bitmap[m]
s/increase/increased/, s/I/a/
mayhem[m]
logs much quieter now
bitmap[m]
40+15 reserver for both metabrainz_db and listenbrainz (up from 20/10)