Notes from #MetaBrainz Meeting 2022-04-04

[Freso]

MetaBrainz Meeting 2022-04-04

Meeting start: https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983180/

International Monday for Mine Awareness and Assistance in Mine Action

Song from Vietnam: A Present Day Video From Post War Vietnam

Agenda

• Reviews

Last meeting: 2022-03-28
Next meeting: 2022-04-11

Reviews

@atj

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983184/

@atj

I was occupied with work and some IRL matters last week so was unfortunately unable to dedicate much time to MB.
However I did resolve a minor issue with shorewall due to a reference to an invalid log file and hopefully fixed an recurrent issue with apt tasks failing when bootstrapping servers. I also reviewed a PR created by @zas that added a role to manage timezone and NTP configuration.
The playbooks are now mature enough that @zas was able to fully deploy a server from scratch in 30 minutes today, which is a great achievement.

@rob

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983192/

@rob

last week was all about the metadata view, or more specifically the MB datadata cache coming together.
massive SQL queries ftw.
@lucifer and I also cleaned up some mapping stuff, fixing some things that were not mapped and also renaming things to be more consistent.
we now also have a python class for making it super simple to run an SQL query to create a new table and then to rotate that table into production inside a transaction.
those bulk tables can be chained as well, so more than one table can be swapped in in the same transaction.
this is the meat and potatoes of the mapping work, so this will make me more efficient in the future.
then I paid people and did quarterly accounting today.

@Freso

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983206/

@Freso

Mostly the usual, but I also poked at an issue with logging in to the forums from the iOS… and got that solved. So anyone using the Discourse iOS app should now be able to use it with our instance, too.

@alastairp

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983216/

@alastairp

last week I finished work on the metadata viewer backend to update out of date rows, and planned with @rob how to actually find out of date rows. I also started work on data dumps for the canonical tables
I finally got the BU upgrade in CB finished and released and some people tested that. It’s looking good so we’ll merge and roll that out. with @lucifer’s help I also merged and released some really old CB PRs (from before when @lucifer was a contractor!)
I also read and reviewed some SoC proposals, and reviewed some PRs
finally, I worked on getting AB dumps working, so that we can distribute an archive of submissions when we shut the site down. 2 of the 3 dump types are working, so almost finished there

@akshaaatt

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983223/

@akshaaatt

Last week I worked massively on the MusicBrainz revamp work
You can experience it at https://test.musicbrainz.org, thanks to @bitmap and @reosarevok!
Also, I have been working at full pace on the android app side by side.

@bitmap

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983229/

@bitmap

last week I did a fair amount of code review and did more schema change work
mostly related to https://github.com/metabrainz/musicbrainz-server/pull/2476 but also writing scripts for the dbmirror2 changes and performing other tests
I also opened a PR to improve our CAA error logging and deployed that to hopefully help debug an issue @Zas was seeing
earlier in the week I helped perform another primary database switchover from pink to floyd so that pink could be upgraded, then restored standby service on pink later that day. and I apologize for not better communicating which services would be affected by that, I’ve noted it for the future!

@yvanzo

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983237/

@yvanzo

Last week I hotfixed bugs in the wrapper that runs MB background tasks.
Helped with pink update, and investigated some alerts (CAA, SIR…).
Updated the documentation PR about Docker volumes.
Resumed updating the PR about releasing MBS.
Also reviewed a few PRs and provided support.

@zas

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983245/

@zas

Mainly worked on moving servers to ansible, last week we did pink, patton and ludwig
It implied fixing/improving our playbooks, but today’s ludwig was up and running within 30 minutes from scratch (including formatting/installing from rescue)
I also continued on new gateways, fixed few issues, and started to benchmark (using vegeta), there’s some bottlenecks related to SSL I need to identify
basically I achieved 30k+ req/s on http on a single server, but this goes down to 2.5k in https with keepalive, and only 530 without ka
(that’s per second)
plus usual supervision, upgrades, edits, PR reviews.

@lucifer

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983254/

@lucifer

i reviewed some LB PRs last week and SoC proposals. also did some on work on metadata viewer backend and related electron app. also some dumps debugging.

@reosarevok

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983260/

@reosarevok

I released the server, worked on a few small issues, and took a couple chill days to rest and bird and cycle
Also spent some time reviewing @akshaaatt’s code
Anyway, this week plan is to hopefully start working on moods
If I’m in the mood, that is
And some more helping @akshaaatt probably
We should work on merging some of the open schema change PRs too

@CatQuest

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983279/

@CatQuest

last week was spent mostly nagging people to help write a stupid blogpost
then @reosarevok basically rewrote the whole thing :​(
but it ended up a success so that was a good thing! :​D
this week I’ve nagged @mr_monkey and shub but they are doing really good work
so I’ll be working on testing bookbrainz and seeing if I can be at all useful :​)

@mr_monkey

https://chatlogs.metabrainz.org/libera/metabrainz/msg/4983289/

@mr_monkey

Last week I worked on UI mockups for the LB metadata viewer, with a bit of help from @aerozol (thanks!)
I tweaked BB’s automated GitHub deployment configuration a bit, and deployed a new version in production.
We’ve already identified a couple of regressions (unrelated to the deployment config), so not the best deployment ever…we’re discussing better deployment cycle practices on the BookBrainz channel.
I also reviewed PRs, mostly for BB, and spent some time helping and directing new contributors, participating in forum discussions and reviewing GSoC project proposals.
Finally I worked on a persistent and elusive bug with signup on BookBrainz, still in progress…
I’m also trying to move apartments, so that’s taking some time out of the week too.
One thing I haven’t done is look up open-source projects to financially support. I have a couple of candidates but need to do more digging.