Notes from #MetaBrainz Meeting 2018-04-30

[Freso]

MetaBrainz Meeting 2018-04-30

Meeting start: IRC Logs for #metabrainz | MetaBrainz Chatlogs

Agenda

• Reviews
• Pg spof & scalability

Reviews

@dragonzeron

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@dragonzeron

I have recently brought up the idea of having a mass ISRCS button on the community of metabrainz and I was asking on how you guys feel if we can take jesus2099 script and put it in the system however o think this idea could take a year or 2 unless it’s easy to do I am wanting to have the community’s thoughts on this
Making a mass isrcs button for releases - #2 by jesus2099

@reosarevok

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@reosarevok

So, I did the usual support, and dealt with quite a few style tickets
Currently I’ve solved more tickets in 2018 than have been added D:
Of course, there’s still a couple hundred open ones anyway, but eh, getting better hopefully

@Freso

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@Freso

Still a lot of moving and moving in stuff going on. I did manage to be a bit more around this last week, even managed to catch up on one of the (many) meeting notes I’m behind. I also dealt with some editor conflicts (reported and otherwise). And as aye, I spent time on IRC and forums.

@LordSputnik

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@LordSputnik

This week I worked on fixing a few bugs with the new relationship editor. There was a problem with the way react-select was filtering entities returned from the search request, caused by a change I made a few weeks ago.
I also fixed some issues with editing/adding relationships in the same form. I’m now hoping to sync up with bukwurm to get the server-side code finished, and then we should be able to release the new editor. Everything is nicely Flow-annotated in the new code, and that’s helped eliminate a few bugs already.
I also updated the contributing guide in the bookbrainz-site repo, to cover a few code style points and talk more about commit message format.
And also had some useful conversations with CatQuest and bukwurm about what would be good to add/fix in BookBrainz in the near future, and about some technical aspects of @shivamt’s GSoC project.
Oh, and I checked BB for signs of Google Analytics, and found nothing.

@Leo_Verto

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@Leo_Verto

Finally got my DJ controller and now working on building a collection and otherwise busy with homework
I’d love to spent some more time digging into the LB recomendation stuff but that’ll probably have to wait until @Rob has some more time on his hands

@bitmap

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@bitmap

mostly spent time converting components used on entity pages to react… annotations, cb reviews, the show/hide controls for those, some followup changes to the wp extract components yvanzo did
submitted a pr for that, need to fix tests
spent time fixing copious test failures on other prs
and not much else other than code review

@yvanzo

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@yvanzo

Last week has seen a new release of MusicBrainz server, followed by a series of fixes. A new beta is available too. Expect a prod release next week.
Additionally tried to keep up with recently opened MBS reports, and a few STYLE ones.
About 0THER-77, I will most probably step back with Markdown support in JIRA as the only existing plug-in doesn’t seem to be satisfactory. Markin’s main drawback is its lack of user-friendlyness compared to the stock text editor in JIRA, especially for newcomers to use.

@chhavi

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@chhavi

This week was busy with final exams. Finally free, can devote my full time to MusicBrainz. Yay! Worked on Release Group mockups, will update the ticket. Fin!

@little_rsh

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@little_rsh

Last weekend I have met @iliekcomputers regarding the discussion about AB project and the starting work I would be doing in the coding period.
And I am planning to complete the already open PRs(if more work is required) before coding period begins, once I get a review from him.
Gonna have semester exams starting from tomorrow and a bit tight schedule for the coming week.

@shivamt

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@shivamt

This week, I worked on solving the curious case of not refreshing views for Postgres search. Turns out a race condition I was silly enough to miss.
I also worked on relationship editor’s server side code a bit.
Today I started working on CatQuest few recommendations, but ended up improving the way editors are notified of existing entities.
https://usercontent.irccloud-cdn.com/file/3aOEhOD4/mon-30-april.mov
Here’s a small demo, I have since then made disambiguation validation compulsory if the exact name matches for the entity type.
I am in the process of brushing it up and committing in a day or so.

@kartikeyaSh

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@kartikeyaSh

It’s been a busy week with final practicals and a few assignments. Now I’ve final exams in this week and the next one. So, I’m not able to get involved in community bonding in a way students are expected to. I did read the tutorial on SQL ORM to under mbdata in a much better way. I’m waiting for reviews on BU-11.

@zas

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@zas

i upgraded all servers, fixed minor issues coming with those upgrades
i also upgraded grafana & discourse to latest versions
i started to dig pg stuff related to issues we have atm
short story long: response times are very bad, and bowie’s load is the cause of it, but we don’t know yet what’s the cause of the load…
if someone deployed something that may use the db on sunday, please tell ;,)
apart that, i tried to setup an alert for packet replication issues, but i need to start over, nagios was reluctant to help me
plus usual PRs reviews, edits, etc…

@Rob

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@Rob

normal week for me.
accountants, a meeting with the lawyers to cleanup a mess that c created.
bank account still not unfrozen, starting to doubt it will ever be.
helped with replication packet issues, realized that our docs are woefully out of date. we need to work on that.
did some tiny metabrainz navbar cleanup and deployed a link to our shop which promptly generated one sale.
thanks @MajorLurker!
I’m going to be AFK wednesday afternoon - sunday.
if you don’t get me your invoice by tomorrow afternoon, you’ll need to wait until monday.

@CatQuest

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@CatQuest

just been working a little bit on instruments and releases.
had a very interesting discussion with @LordSputnik and @shivamt
in which @shivamt made a document summarising what we talked about
(and has been working on it too ass is the review he made :D)
she?
but mostly preparing seeds and stuff for spring took most of my time this week, should be back on form next week.
it’s valborgsnatten this night so I’ll be celebrating >:D

@iliekcomputers

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@iliekcomputers

this week was much more productive than the last few, I’ll do updates project wise
LB: worked on moving data to the new BQ schema, ruaok pointed out an interesting problem, we discussed solutions to that, gonna code up something today.
CB: worked on comments on reviews, and a bunch of open PRs. proud that the only PRs left now are schema changes. thanks @ferbncode!
AB: met with @little_rsh and @ferbncode over lunch to discuss how to approach her project in the best way, this is a first for me as a mentor. (was kinda productive)
rn, working on changes to CB to reduce load on postgres.

Pg spof & scalability

IRC Logs for #metabrainz | MetaBrainz Chatlogs

@zas

basically we need to improve pg stuff
currently we have bowie (master postgresql) and queen (slave, underused)
while it provides some redundancy, we have any load balancing yet
so that’s a single point of failure (spof): if bowie goes down, we have no automatic switchover
discussing possible solutions is too long here and now, but i’d like people with ideas to tell, we’ll try to address those problems asap
our lack of experience in this field is the core issue, if anyone knows someone that could help on this stuff, please make the link

@iliekcomputers noted that he was moving CritiqueBrainz to queen, and @bitmap pointed to https://www.reddit.com/r/PostgreSQL/comments/6ky5sj/things_i_wish_i_knew_before_using_pgpoolii/ for «some interesting comments about pgpool» and further noted that «pgpool or looking closer at citus are the best options I see at present». @zas stressed «that’s why i think we need to find people willing to help that have experience with whichever tool we go for» and suggested asking in PostgreSQL channels. @Rob further suggested making a blog post to ask for recommendations, stating «that has worked really well in the past.»

No decision was made per se, other than pursuing PostgreSQL channels and possibly making a blog post and otherwise reaching out to get more help from others.