#metabrainz

Looks like you all had fun! Great job keeping the users updated on the socials, and big thanks to yvanzo for posting to bluesky and mastodon as well! Very nice!

Hey aerozol, does ListenBrainz support showing the granular stats (by year, by month, by day) that Last.fm does? It looks like the bars in the bar graphs are not clickable.

Techman: You have these options, at the top of the stats page: https://usercontent.irccloud-cdn.com/file/pT3CG...

If you have ideas for more, tickets are welcome! I’m not sure if there’s technical restrictions re. a daily total, though.

Oh. Hmm. Well, it is currently lacking the granularity that Last.fm has.

Yeah I can make a ticket to better show what I am talking about

I really like last.fm’s Reports page! I think LB has a fair amount of catching up to do

I got distracted and did not make the ticket yet, but I was not quite talking about the reports tab. On the library page, there is a bar graph to the right that shows listens. When it is set to "All time" it goes by year. You can then click the bar to start getting more granular. https://www.last.fm/user/TheOnlyTechman/library

You basically have the same kind of graph if you visit https://listenbrainz.org/user/aerozol/stats/?ra... but the bars are not clickable to focus in.

Not that I use that capability a lot, but it is really cool to go back in time and see what I was listening to during a particular day and time. I was talking to a buddy the other day about how I could probably correlate certain listening habits with life events.

Techman: Definitely worth making a ticket! I have also had discussions re. how listening habits can correlate with things… a good LLM could make some pretty creepy (and probably pretty accurate) assumptions about what you’re up to, how you’re feeling, and your daily routine!

aerozol: https://tickets.metabrainz.org/browse/LB-1578 feel free to edit this to make it sound better if needed

LB-1578: Improve the Bar Graphs on the Stats Page to Show More Granular Data

I think you know what I am talking about though and you are the UI guy so uh 😅

Second round…

aerozol: ping

yvanzo: is the full dump ready? I'm going to do a couple chores but I am available for further stuff in a bit

It seems so.

yvanzo: have you tagged mb prod yet?

no, still testing

Ok

I published the blog post - in private only - just to preserve the URL.

Reosarevok: pong

aerozol[m]: hi! did you see my comment yesterday about your report? :)

I just started creating a mirror from the full data dumps on wolf. Now testing the upgrade notes with another instance.

Thanks!

Hmm depends, do you mean the weekly meeting report? Then yes 👌

No, I meant the CB review user one

Ohh sorry, yeah. I forgot to reply sorry. I didn't fully follow - were you saying we can't block them? In this case it doesn't really matter imo. The whole 'quietly hide reviews without it pinging the user' seems pretty effective making exploiters think the jobs done, and moving on

おはよう!

ohayou :D

Mōrena!

:D

I take it the scema thingy went well?

yep. slow but well.

slow but well is much better than fast but bad :nodnod:

zas: did you see the "Whitelist IP address" email from 12 days ago?

aerozol[m]: we can block them in MB, but that won't do anything for CB

It's confusing though that they can even leave reviews without a verified email address, maybe CB should block that

mayhem: did you see the Fair MusE email? That might be a better fit for you, especially since they want LB stuff too

Reosarevok: funny! Luckily it hasn't been a problem. I can make tickets to sort it, but is anyone going to work on CB tickets?

reosarevok: yes, it was handled, he contacted me via IRC too. https://github.com/metabrainz/metabrainz-ansibl...

Thanks zas

Especially since you're so busy atm getting the EAA archive into beta

aerozol[m]: well I dunno if lucifer or someone would work on it, but it might make sense to specify it :)

Event art archive archive 🫠

reosarevok: yep, on the radar for today

aerozol[m]: I could work on it if you send some cash. Maybe through the ATM machine

How much for the EAA? I'm running to the ATM now

yvanzo: do I understand correctly that https://github.com/metabrainz/musicbrainz-docke... is just getting rid of the old script and changing it for the new?

Don't we usually keep both versions? Not probably a big deal though

Anyone with a PG 9.5 database (so more than four years old) is rather invited to reinstall from scratch.

Yeah, I guess that makes sense

Was just thinking we keep all the old update scripts in MBS

But I doubt anyone ever actively uses them

I cannot imagine the time it would take just for loading 4 years of replication packets.

The old update scripts in MBS can be useful to replay replication packets if needed.

Ok :)

This script is not documenting anything about our database schema, it just upgrades the Postgres version.

Thanks, good question :)

lucifer, ansh: Can we stop these containers on wolf for upgrading the MB mirror? https://www.irccloud.com/pastebin/ogUjjF9E/

Yvanzo: yes

I did but it wasn’t enough, restarting Docker as well.

So you're testing updating the mirror now?

Anything you need help with? :)

Yes, patience! :D

This is the second mirror I’m upgrading as there were many issues to fix in the process for the first mirror.

So it should go smoothly this time.

Also, I successfully imported the full data dump into a fresh instance.

Sweet

Have we migrated test?

No idea.

I am going to assume not

Since it wasn't in the list AFAICT

But I guess the DB needs updating to v16 first anyway

[musicbrainz-docker] 14yvanzo opened pull request #278 (03schema-change-2024-q2…mbdb29): Upgrade Server to v-2024-05-13-schema-change https://github.com/metabrainz/musicbrainz-docke...

Huh, somehow the whole part of the blog post with the actual details on upgrading to pg16 got dropped

Trying to fix it

Hate wordpress

I still have the preview in a tab if needed.

It's fine, I think I got it

Mirror upgrade is going fine so far, just VACUUMing for a while…

Hello everyone ! I have hard time building the server image from musicbrainz-server and I'm confused, anyone here to help ?

hi MatthieuPlex. Yes, yvanzo and reosarevok should be able to help you. what is your question?

MatthieuPlex: Using musicbrainz-docker?

yes

I tried with multiple tags

but same issue on master

[musicbrainz-docker] 14yvanzo opened pull request #279 (03schema-change-2024-q2…prebuild-images): MBVM-42: Prebuild images for the services db and musicbrainz https://github.com/metabrainz/musicbrainz-docke...

it is failing with xgettext-js@https://github.com/metabrainz/xgettext-js.git#commit=0301681a479c1796ff6850c9bd2a169074386d92: The remote archive doesn't match the expected checksum

ohh pre-built image would definitely help ^^

MatthieuPlex: Which version of musicbrainz-server?

I think master is pulling v-2024-04-09

MatthieuPlex: Yes, there was an issue with Yarn that has been fixed in master, and in the yesterday’s release, but not in any PG12/MBDB28 release.

(yesterday’s release isn’t actually released yet though)

sneaky.

ok so I just have to wait for the new release with the new db schema ?

MatthieuPlex: You can replace `v-2024-04-09` with `pg12-last` in the Dockerfile.

The new PG16/MBDB29 release is upcoming, just a few more minutes/hours at most.