#metabrainz

ruaok, zas: queen is now running with hot_standby_feedback = 'on', should be okay to point more queries there

great.

why is this needed ? "This parameter can be used to eliminate query cancels caused by cleanup records, but can cause database bloat on the primary for some workloads." <-- not sure what it means for us

it's needed to make queen usable by preventing pg from cancelling queries conflicting with replication

"If you do this, you should note that this will delay cleanup of dead rows on the primary, which may result in undesirable table bloat. However, the cleanup situation will be no worse than if the standby queries were running directly on the primary server, and you are still getting the benefit of off-loading execution onto the standby."

from https://www.postgresql.org/docs/9.5/static/hot-...

so theoretically it should be no worse for us...

https://dba.stackexchange.com/questions/130622/... the second comment says "Cons of hot_standby_feedback is obvious:Primary cannot remove dead tuples while conflict occurs."

right, it can't remove them either if the same ro queries were executing on the primary

yup, understood

but we'll see if it causes issues

meh, we can't move search to queen. it creates temporary tables. :(

bitmap: any idea what is connecting to bowie with musicbrainz_ro user?

yvanzo: apparently, CB and wikidatabot use it

ruaok: Are waters calm enough for us to have the meeting in 25 minutes, or should we delay/cancel tonight in favour of vigilance/maintenance?

calm enough.

wikidatabot isn't running.

iliekcomputers: can you please have CB use postgres-slave for this DB access?

ruaok: okay

Should be easy enough.

ideally fallback to postgres-master if postgres-slave isn't available

Wikidatabot hasn't run for ages (since January, where you took it down as you suspected it for some other db interference).

ruaok: that sucks, not sure of a way around that

I guess we'd have to make them persistent tables in the schema and fill them in an rw connection first.

blup

<BANG>

o/

Hello people, and happy Walpurgis Night. :)

People up for reviews tonight: dragonzeron, Freso, reosarevok, bitmap, zas, ruaok, yvanzo, samj1912, iliekcomputers, rsh7, bukwurm, Leo_Verto, chhavi_, kartikeyaSh_ircc, CatQuest, LordSputnik — anyone else who want to go, please not me know explicitly ASAP. (Ping: Leftmost, Leo_Verto, alastairp, ferbncode)

Let's get started with dragonzeron!

dragonzeron says:

"""

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

"""

reosarevok, go!

Hi!

Hi!

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: go

Solved == wontfix?

🙋

Not all!

95%? :p

\o/

:O

o/

:D

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.

fin.

LordSputnik: Go.

"""

so many quotes.....

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 bukwurm's GSoC project.

Oh, and I checked BB for signs of Google Analytics, and found nothing.

fin.

"""

Leo_Verto: Go!

Well, I don't have a whole lot to report either

Or not?

Report what you can.

[critiquebrainz] paramsingh opened pull request #206: CB-300: Use postgres-slave instead of master in production (master...use-postgres-slave) https://git.io/vpRMz

Finally got my DJ controller and now working on building a collection and otherwise busy with homework

(People still up: bitmap, zas, ruaok, yvanzo, iliekcomputers, rsh7, bukwurm, chhavi_, kartikeyaSh_ircc, CatQuest — anyone else who want to go, please not me know explicitly ASAP.)

I'd love to spent some more time digging into the LB recomendation stuff but that'll probably have to wait until ruaok has some more time on his hands :P

fin.

sorry.

soon.

bitmap: go!

hey

Leo_Verto: probably my biggest goal for next week. things should be more free then

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

(looks great btw)

iliekcomputers: approved.

spent time fixing copious test failures on other prs

ruaok: yeah, no problem, I understand that you're pretty busy right now with GDPR and the spontaneous replication failure

not to mention accouting, taxes and banking. :(

and not much else other than code review :) fin, yvanzo?

Hi everyone!

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.

That’s all I think, chhavi_?

Helo :)

helo!

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!

rsh7: go! :)

Hi!

hi!

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.

(and ferbncode was there too :)

Gonna have semester exams starting from tomorrow and a bit tight schedule for the coming week.

:D

fin! :)

\o/

bukwurm: go!

Hi!

(People still up: zas, ruaok, iliekcomputers, kartikeyaSh_ircc, CatQuest — anyone else who want to go, please let me know explicitly ASAP.)

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.

Here's a small demo, I have since then made disambiguation validation compulsory if the exact name matches for the entity type.

like in mb?

I am in the process of brushing it up and committing in a day or so.

:D

Looks cool

CatQuest: I have integrated search too, so as and when you type in the name you get most relevant results alongside.

oohhhhh

That's all from my side.

Fin.

bukwurm: Looks really neat.

kartikeyaSh_ircc: Next?

Freso: Thanks :)

Hi

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 http://docs.sqlalchemy.org/en/latest/orm/tutori... to under mbdata in a much better way. I'm waiting for reviews on BU-11.

BU-11: Add MusicBrainz database module to brainzutils https://tickets.metabrainz.org/browse/BU-11

fin

CatQuest: Wait I'll send a GIF or something.

zas next ??

🙇

:(

hey

i upgraded all servers, fixed minor issues coming with those upgrades

i also upgraded grafana & discourse to latest versions

[critiquebrainz] paramsingh closed pull request #206: CB-300: Use postgres-slave instead of master in production (production...use-postgres-slave) https://git.io/vpRMz

!m zas

You're doing good work, zas!

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...