#metabrainz

[listenbrainz-server] 14samglt opened pull request #3127 (03master…docs-copyright-year): Docs: Keep copyright year up to date https://github.com/metabrainz/listenbrainz-serv...

Thanks monkey for a detailed review on my last PR... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)

Can someone help me with the method to access the "Created for You" section on local, I can access the same on the deployed but on local it gives me the "oh no" clipart

monkey: I have implemented all the required changes.

Please do let me know if any further improvements are required 🙂

Also, now all the tests pass 🥳

lucifer: gaga has a lot of postgres activity right now. 300% typesense too. meh.

that doesnt look good, lucifer

Looking

graphana doesn't tell much.

@zas: remind me please, where can I find the current traffic to LB from the gateways in grafana?

full dumps are underway

maybe that's why?

can you link me to the graph

mayhem: the memory usage looks consistent with full dumps if you expand the range to 6 months.

ah, ok.

something that we should look into and fix in longer term but nothing unusual for now

there are a lot of postgres procs that look... .interesting.

just backed up because of the dump?

possible.

interesting factoid for summit expense: 2024 - $17,644.74

2023 - $17,783.35

going to india was $138.61 cheaper than barcelona. and that includes going to the Taj, so India was cheaper.

<aerozol[m]> "jasje: Hemang Mishra: Following..." <- Hemang Mishra, aerozol : That's right, the play button would be solid blue/purple on the LB website, like on the album pages for example:

<suvid[m]> "Thanks monkey for a detailed..." <- suvid: That example volume screenshot looks perfect. For the color scheme just follow the styles of the player queue. Will look at the PR, thanks for your continued work!

<holycow23[m]> "Can someone help me with the..." <- Basically it's going to require having copies of big datasets we use, and running troi (the tool we made to generate playlists [https://github.com/metabrainz/troi-recommendati...]) There is a user guide here to help: https://troi.readthedocs.io/en/latest/user-guid... and https://troi.readthedocs.io/en/latest/

I will let mayhem correct me or add any useful information

<monkey[m]> "Hemang Mishra, aerozol : That'..." <- Okay

I'll make the required changes

lucifer, mayhem: Since yesterday we got plenty of alerts from kiss & gaga, about disk space & load, is that normal?

I am guessing it's because of full dumps.

aerozol: jasje: I have updated the figma with required changes

Let me know if any other changes are required or I would start with the coding.

lucifer: I am looking again at what ails gaga and looking at the current queries, there are a lot of these queries: https://github.com/metabrainz/listenbrainz-serv... those are just about the only queries running. and there are a lot postgres procs that are CPU bound right now. this doesn't look like it caused by the dumps.

zas: ping

[@mayhem:chatbrainz.org](https://matrix.to/#/@mayhem:chatbrainz.org) sometimes due to transactional guarantees unrelated queries can be held up, dumps have long running transactions iirc.

If the popularity queries are idle i don't they are causing it

understood.

If there are locked or waiting or active it's probably something else

about 30 active queries at a time.

all the popularity queries are active.

the thing is, we normally dont get this while processing dumps

seems as if someone is hitting the popularity API a lot or we have a lot entity pages being loaded right now.

which is why I want to know if there is an increase in traffic to LB.

pong

do we have a graphana view that shows inbound traffic to LB? I want to see if there was a recent spike in user traffic.

thanks. ok, not increased traffic.

that suggests that someone is hitting an API endpoint repeatedly and we're not handling it well.

lucifer: looking at the query that executes over and over, there are two seq scans in there. Good chance that is causing issues: https://gist.github.com/mayhem/66d9263d4190bc1d...

-> Seq Scan on mlhd_release_group (cost=0.00..14426.38 rows=881138 width=24)

lucifer: I added two indexes and that query becomes much cheaper, but it hasn't had an effect on the load:

number of pg procs on gaga is going down.

ah recording needs the same treatment.

and now the load is going down.

👏

yep, backlog of postgres queries is now gone.

yay, postgres is not almost entirely quiet. all typesense.

[listenbrainz-server] 14MonkeyDo opened pull request #3128 (03master…back-button-playlist-page): Add back button and secondary navbar to playlist pages https://github.com/metabrainz/listenbrainz-serv...

lucifer: where should I add the code to add those indexes for the popularity tables?

[listenbrainz-server] 14MonkeyDo merged pull request #3127 (03master…docs-copyright-year): Docs: Keep copyright year up to date https://github.com/metabrainz/listenbrainz-serv...

[listenbrainz-server] 14anshg1214 merged pull request #3128 (03master…back-button-playlist-page): Add back button and secondary navbar to playlist pages https://github.com/metabrainz/listenbrainz-serv...

monkey: Can I use test.LB?

Yes, shoot

Thanks

Also if your have a minute, do you have thoughts on https://github.com/metabrainz/listenbrainz-serv... ?

<monkey[m]> "Also if your have a minute, do..." <- I've added my comment on the discussion

Thanks

Great work Hemang Mishra: good to go from a design perspective! You can coordinate with jasje: for implementation now 🤩

monkey: Approved! Let's merge this PR and do a release?

I have some merge conflicts to resolve first, but keen on merging it, let me finish that up in a few minutes

cool

Looks good btw guys!!

monkey: Regarding this (https://github.com/metabrainz/listenbrainz-serv...), do you have your apple music connected? cuz technically the button should be hidden, in case the user does not have their apple music connected

Hmm, interesting. Yes, I do have my account connected despite the fact that my one-month-subscription-for-testing has elapsed.

OK, I think this is an edge case and maybe not so worth investigating. It should probably be more of a backend automatic disabling of a service if we get certain types of responses/errors, but let's leave that for another day.

Interesting

I guess we merge that PR, then?

yep

[listenbrainz-server] 14MonkeyDo merged pull request #2968 (03master…apple-export): Added exporting playlists to Apple functionality https://github.com/metabrainz/listenbrainz-serv...

BOOM

[listenbrainz-server] 14MonkeyDo merged pull request #3118 (03master…opengraph-meta-tags): Add OpenGraph meta tags in artist, album and user pages https://github.com/metabrainz/listenbrainz-serv...

I'll prepare a release

Unless you would like to do the honors?

Sure! I'll do it

[listenbrainz-server] release 03v-2025-01-16.0 has been published by 14anshg1214: https://github.com/metabrainz/listenbrainz-serv...

Mind if I add a bit of text blub in the release notes ansh ?

Sure! Go ahead