Notes from #MetaBrainz Meeting 2023-10-30

[aerozol]

MetaBrainz Meeting 2023-10-30

Meeting start: IRC Logs for #metabrainz | MetaBrainz Chatlogs
Meeting wiki page: MetaBrainz Meeting - MusicBrainz Wiki

Agenda

• Reviews
• Security Alerts

Last meeting: 2023-10-23
Next meeting: 2023-11-06

@reosarevok: Welcome to Weird Timing Monday, hope everyone is around despite said Weird Timing!

Reviews

@snaekboi

[mailed in] [Pratha-Fish] Cheers to another productive week.
Almost done with the bot. All the data is in, finding and posting differences is all that’s left.
Fetched ~117k+ rows from Wikidata, so I think we’ll have a ton of new ones incoming on the musicbrainz database : D
Ideally, the whole project should’ve been wrapped up by 7th, but I’m risking a couple of days extra to get the project to a proper working state before starting a blog for the final submission
The deadlines are stressful, but also fun. Gonna take the most relaxing break known to mankind once this project finishes

@aerozol

[mailed in] Been busy, but not with MeB stuff - Lucy and Bean are sick and I’ve just moved into a new co-working space.
I managed to squeeze in doing some more summit blog notes, and posting that everywhere
While I was at it I got distracted by doing [SPAM-9: Tools and criteria for auto-flagging spam]
A bit more LB options menu design stuff with monkey
And the usual social media monitoring and a bit of spam fightin’

@CatQuest

[mailed in] [ApeKattQuest] Araaahhh :chough: well I got sick today ://, however before that nonsense I managed some work this week:
closed [INST-1095: piffero], [INST-1055: Fiscorn]
Updated rauschpfeife (thanx reo for images)
finally looked though all the old subscription-mails so updated a few analogue synth aliases (brandnames)

@rob

[mayhem] last week was back to normal for me – finally.
lots of background stuff, but also some fun things like meeting petitminon in BCN with monkey and going for tacos.
we talked listenbrainz local sort of stuff – it was helpful to have him around, because he made me realize I was making things a bit too complicated.
so that is good.
also worked with monkey on the artist entity pages for LB, which is finally coming into focus, before I have to tear it all apart again.
lol.
this week my mother will come visit me.
so, I may not be around much on wednesday afternoon, thur and fri. Or i might be – just depends on my mother.

@mr_monkey

[monkey] Last week I reviewed kellnerd’s newest PRs, and some other BookBrainz PRs
I continued working on the LB entity pages, as well as having some design discussions
Finished a PR refactoring playlist options menu in LB
And investigated Spotify’s unreliable listening history
And spent a bit of time closing SEC tickets

@kellnerd

Last week I continued with improving the OpenLibary parser and making the logger output more useful.
I’ve also started working on making repeated imports (if an entity has the same external ID) overwrite existing imports if they are still pending (which they will always be until we are satisfied enough with the data quality to release the feature to accept them as regular entities).
This involves reordering the SQL transactions in our ORM functions and having conditional branches to overwrite entities (and maybe sometimes leaving stale/unreferenced database rows behind?)
I hope I will get that finished this week, alongside with writing a blog post about my GSoC journey : )

@yvanzo

Mostly the same week again with more summit notes, tickets triage and weblate stuff, plus…
Helped bitmap with testing his patch that fixed a blocking bug in MB replication;
Completed redeploying a full MB mirror with search on wolf development host.

@bitmap

last monday we performed a primary database switchover to jimmy/hendrix, so that pink/floyd can be retired
the switchover itself went smoothly, although there was an issue where one of our tag indexes became corrupted - [blog post]

I wrote a script to merge the duplicate tags, and then fixed the seven (?) replication packets that contained them. also re-indexed all indexes using collations in production

after that I submitted a patch to update mbslave to use dbmirror2 packets, and updated syswiki to reflect all of the postgres cluster changes from the switchover

at the end of the week I worked on the Event Art Archive - I merged and deployed https://github.com/metabrainz/artwork-redirect/… and made a lot of progress on writing tests for the artwork-indexer

@reosarevok

Last week I worked on a few smaller issues, including [MBS-13334: Email in use for is_email_used_elsewhere but lost_username does not see it]
Which was itself trivial but I spent a lot more time making the relevant tests for Data::Editor suck less
I also was debugging a weird issue where WikidataBot enters duplicates sometimes
Of course, while I was looking into it no duplicates were entered
But I did fix a fair amount of incorrect and broken Wikipedia links to clear the logs, at least
Other than that, a fair amount of reports

@akshaaatt

I am working on a lot of things all of a sudden again…
But I am enjoying it like crazy… so that’s the good part
Continuing on the scrobbling refactor in the app
Also, added a bunch of helpful stuff to debug
Reviewed a massive PR as well

@zas

Last week, I worked on the side effects of the move to new database servers, mainly fixing dashboards and few alerts
I also fixed a telegraf issue not reporting some stats because of renamed containers
I started to investigate alternatives to Gandi (DNS) after [news article]

I also patched mbstats & picard-website after security issues were reported in some dependencies

I also added checks from github actions versions in some of our projects

Plus usual supervision, MB edits, Picard / Picard Plugins PRs reviews, and miscellaneous things.

@lucifer

last week, i worked on release group popularity stats and fixing a couple of bugs in statistics pipeline.
ended up creating a mess while working on that earlier today, thanks again to zas, mayhem and others for helping clean it up.

@atj

hi, nothing substantial to report last week unfortunately

@anshgoyal31

[ansh] Last week I worked on making the final additions to the fresh release page.
Added filters for personalised fresh releases, Fixed a couple of tests, and worked towards cleaning up the PR
Other than that I started working on [LB-1264: Releases by “Various Artists” should not be included on “Fresh releases” page] as this is related to the fresh releases page.
And spent some time working on BookBrainz’s tickets

@arsh331

[arsh] I will be unlikely to finish the pr anytime soon. So monkey if you want to go ahead and work on it I will be more than happy.

@jasjeet

So last week I expanded on some core models inside the app
abstracted some models and simplified previous implementations
Started researching on web views and their efficient use.

Security Alerts

@yvanzo

There are currently 44 SEC tickets still pending, of which 30 for over a month.
Some of these may have been dismissed in GitHub already.
monkey suggested to have an online meeting when needed to review those.
Would we have one this week?
Reminder, here is the list [ticket filter]

It is agreed to have a security review meeting at 12PM-4PM cest tomorrow (10-31). Those who can’t make it should review tickets in their own time or before the review meeting.