Does InitDb.pl have a setting that allows you to change the postgres schema it initializes? If not, is this something I could contribute?
2025-07-01 18243, 2025
lucifer[m]
monkey: BookBrainz was down, didn't find anything in `bookbrainz-web-prod` logs but restarted the container and things seem to work fine. would be great to add timestamps to the BB webserver logs.
2025-07-01 18227, 2025
pite has quit
2025-07-01 18228, 2025
mamanullah7[m]
lucifer:... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/qrwclORDznpsuWPkailgtyId>)
2025-07-01 18251, 2025
mamanullah7[m]
s/i think//
2025-07-01 18257, 2025
Kladky joined the channel
2025-07-01 18242, 2025
lucifer[m]
m.amanullah7: oauth tokens are meant to expire soon, update your code to refresh the token if expired and see if that helps. otherwise its a different issue and i'll take a look.
2025-07-01 18225, 2025
lucifer[m]
oh i see, you are getting the error during the refresh token flow. push your changes, i'll check locally.
2025-07-01 18201, 2025
mamanullah7[m]
lucifer: Sure!
2025-07-01 18210, 2025
suvid[m]
lucifer: i think i'm pretty much done with everything now
2025-07-01 18210, 2025
suvid[m]
just have to implement submit listens function now
2025-07-01 18237, 2025
suvid[m]
is there any already existing function i should use for that?
2025-07-01 18229, 2025
mamanullah7[m]
<lucifer[m]> "oh i see, you are getting the..." <- lucifer: i've deleted the refresh_token func while refactoring! i'll add and will try once then will let u know!
2025-07-01 18241, 2025
yvanzo[m] joined the channel
2025-07-01 18242, 2025
yvanzo[m]
Hi zas, we can shut down Solr 7 cluster as of now.
yvanzo: it's back, likely temporary due to triggers removal
2025-07-01 18216, 2025
zas[m]
julian45: those are VMs, if you want to conduct tests we can easily create new ones for this purpose
2025-07-01 18231, 2025
julian45[m]
zas[m]: fair
2025-07-01 18210, 2025
yvanzo[m]
zas: OK, now resuming triggers removal (90% left).
2025-07-01 18249, 2025
yvanzo[m]
I canceled it again. Got many ERROR: canceling statement due to statement timeout
2025-07-01 18210, 2025
reosarevok[m]
I guess we need to temporarily increase the timeout time?
2025-07-01 18218, 2025
yvanzo[m]
Running again.
2025-07-01 18212, 2025
yvanzo[m]
Same issue again.
2025-07-01 18225, 2025
yvanzo[m]
It just removed 3 triggers, there are ~300 left.
2025-07-01 18237, 2025
yvanzo[m]
I stopped it again.
2025-07-01 18232, 2025
yvanzo[m]
I didn't expect it to cause that such a slowdown to the website and API.
2025-07-01 18219, 2025
yvanzo[m]
Trying it again with a commit.
2025-07-01 18216, 2025
yvanzo[m]
OK, same effect, aborted.
2025-07-01 18241, 2025
yvanzo[m]
Need to announce the downtime as I don’t see any workaround.
2025-07-01 18244, 2025
yvanzo[m]
zas: I just stopped the indexer for now.
2025-07-01 18259, 2025
zas[m]
Can we still delete VMs?
2025-07-01 18237, 2025
yvanzo[m]
Yes
2025-07-01 18239, 2025
yvanzo[m]
Index messages will just queue up in RabbitMQ for nothing.
2025-07-01 18201, 2025
petitminion has quit
2025-07-01 18202, 2025
yvanzo[m] is off now
2025-07-01 18246, 2025
zas[m]
I stopped them
2025-07-01 18215, 2025
lucifer[m]
<suvid[m]> "is there any already existing..." <- take a look at api_tools.py or the existing listens importer, they have a function to submit a list of listens using rabbitmq
it looks like there's been a good bit of work on title case caps and I found an edge case that probably should be addressed since it likely comes up a lot in songs: `Les Brers in A Minor, Pt 2` looks like "Minor" should stay caps from what I've seen but the auto correct is changing it to "minor"
2025-07-01 18201, 2025
iconoclasthero
it doesn't make sense anyway since Minor's not a preposition.
Hey ansh: i was going through the `brainzplayerSettings.tsx` to add funkwhale in code i saw we are hardcoding priority in default!! thats not the issue but i user already selected their priority list if new externalservice is added by default it will not be added in user priority list until he select again! let me if i misunderstood anything>?
<mamanullah7[m]> "Hey ansh: i was going through..." <- i was thinking of dynamically pushing the newly added in existing user priority list? is it worth it! to add remove from user priority if any services removed or added?
2025-07-01 18226, 2025
mamanullah7[m]
monkey, ansh or anyone who can suggest about this!!
2025-07-01 18242, 2025
yvanzo[m]
bitmap: Do we have any kind of priorities for statements/users in our PG instance? Could it be used to preserve MB response time while deleting the old triggers and functions used for live indexing the now-deleted Solr 7 cluster?
2025-07-01 18232, 2025
bitmap[m]
yvanzo: I don't think PG has this functionality. strange that it causes timeouts though, I wonder if that requires an exclusive lock on the table (the PG documentation doesn't mention it)
2025-07-01 18200, 2025
bitmap[m]
you could try disabling the triggers for now instead
Im thinking of using failed-notif as hash name and notification ID as key and the notification data as value.
2025-07-01 18257, 2025
fettuccinae[m]
That way, when we need to retrieve all failed messages from the queue, we can do it with hgetall.
2025-07-01 18209, 2025
fettuccinae[m]
s/the//
2025-07-01 18244, 2025
yvanzo[m]
bitmap: Thanks, I disabled the triggers at least.
2025-07-01 18206, 2025
yvanzo[m]
Now deleted!
2025-07-01 18213, 2025
yvanzo[m]
bitmap: I have to update the sys admin docs but it's going to conflict with your current PR.
2025-07-01 18215, 2025
bitmap[m]
yvanzo: oh no, let me apply your suggestions and merge that
2025-07-01 18232, 2025
bitmap[m]
yvanzo: merged now
2025-07-01 18254, 2025
petitminion has quit
2025-07-01 18249, 2025
DjSlash has quit
2025-07-01 18206, 2025
DjSlash joined the channel
2025-07-01 18253, 2025
yvanzo[m]
I will complete that on tomorrow.
2025-07-01 18254, 2025
Jigen
bitmap[m]: THANKS your tine bit ofcode is going to save me *so* much work <3
2025-07-01 18214, 2025
bitmap[m]
hehe no problem
2025-07-01 18231, 2025
Kladky has quit
2025-07-01 18212, 2025
aerozol[m] has quit
2025-07-01 18255, 2025
bitmap[m]
<nik[m]> "Does InitDb.pl have a setting..." <- well, there are multiple schemas that get initialized: musicbrainz is the main one, but there's also cover_art_archive, event_art_archive, statistics, documentation, etc. customizing any of these isn't supported because they're hardcoded throughout the code and SQL scripts (so even if you don't run the server, the replication scripts and schema upgrade scripts would also fail)
2025-07-01 18214, 2025
bitmap[m]
what is the use case you have in mind?
2025-07-01 18224, 2025
iconoclasthero has left the channel
2025-07-01 18232, 2025
nik[m]
Oh, I forgot about all the secondary things. For my app, I only use the big musicbrainz one. My goal is to be able to easily swap out a running dataset with a fresh one. I was planning to load a fresh one into something like musicbrainz_new and then transactionally swap it.
2025-07-01 18255, 2025
nik[m]
* Oh, I forgot about all the secondary things. For my app, I only use the big musicbrainz one. My goal is to be able to easily swap out a running dataset with a fresh one. ie, loading into musicbrainz_new and then transactionally swapping it with musicbrainz.
2025-07-01 18246, 2025
nik[m]
It was initially setup with `mbslave`, but that project is not maintained and that's starting to be a dealbreaker for me.
2025-07-01 18234, 2025
bitmap[m]
nik: I see, we could consider accepting a patch but it'll be difficult to replace all of the hardcoded references
2025-07-01 18228, 2025
nik[m]
I agree, it would be quite difficult, especially considering how many there are
2025-07-01 18241, 2025
bitmap[m]
if you can manage a way to change the search_path for you app at runtime you could also do it in two stages (copy musicbrainz to musicbrainz_old first)
2025-07-01 18228, 2025
SigHunter has quit
2025-07-01 18243, 2025
nik[m]
That's not a bad shout, though I typically use the full schema in queries 😅 ie... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/qKSZawBDEKMphuVFvzFnQqJE>)
2025-07-01 18228, 2025
SigHunter joined the channel
2025-07-01 18222, 2025
bitmap[m]
yeah...you'd have to either make that configurable, or remove the schema name from your queries and configure search_path on the PG role/database level (which you can then change on the fly, you'd just have to make sure all existing sessions are referencing musicbrainz_old before dropping musicbrainz)
2025-07-01 18204, 2025
rostiku[m] joined the channel
2025-07-01 18205, 2025
rostiku[m]
careful with merging with the musicbrainz database, I had more luck creating a complete separate one
2025-07-01 18208, 2025
rostiku[m]
this way you can just sync with musicbrainz-server whenever you want