#metabrainz

/

      • bitmap
        ruaok, zas: queen is now running with hot_standby_feedback = 'on', should be okay to point more queries there
      • ruaok
        great.
      • zas
        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
      • bitmap
        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."
      • so theoretically it should be no worse for us...
      • zas
        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."
      • bitmap
        right, it can't remove them either if the same ro queries were executing on the primary
      • zas
        yup, understood
      • bitmap
        but we'll see if it causes issues
      • ruaok
        meh, we can't move search to queen. it creates temporary tables. :(
      • yvanzo
        bitmap: any idea what is connecting to bowie with musicbrainz_ro user?
      • bitmap
        yvanzo: apparently, CB and wikidatabot use it
      • Freso
        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?
      • ruaok
        calm enough.
      • wikidatabot isn't running.
      • outsidecontext joined the channel
      • iliekcomputers: can you please have CB use postgres-slave for this DB access?
      • iliekcomputers
        ruaok: okay
      • Should be easy enough.
      • bitmap
        ideally fallback to postgres-master if postgres-slave isn't available
      • Freso
        Wikidatabot hasn't run for ages (since January, where you took it down as you suspected it for some other db interference).
      • ferbncode_ joined the channel
      • drsaund joined the channel
      • bitmap
        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.
      • CatQuest
        blup
      • Freso
        <BANG>
      • chhavi_
        o/
      • Freso
        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!
      • reosarevok
        Hi!
      • iliekcomputers
        Hi!
      • 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: go
      • Freso
        Solved == wontfix?
      • 🙋
      • reosarevok
        Not all!
      • Freso
        95%? :p
      • reosarevok slaps Freso with a trout
      • Leo_Verto
        \o/
      • outsidecontext has quit
      • samj1912 doesn't have much to report except dealing with exams and helping out with the react library things from last time
      • CatQuest
        :O
      • rsh7
        o/
      • CatQuest
        :D
      • 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.
      • fin.
      • LordSputnik: Go.
      • LordSputnik says:
      • """
      • CatQuest
        so many quotes.....
      • Freso
        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!
      • Leo_Verto
        Well, I don't have a whole lot to report either
      • Freso
        Or not?
      • Report what you can.
      • github joined the channel
      • github
        [critiquebrainz] paramsingh opened pull request #206: CB-300: Use postgres-slave instead of master in production (master...use-postgres-slave) https://git.io/vpRMz
      • github has left the channel
      • Leo_Verto
        Finally got my DJ controller and now working on building a collection and otherwise busy with homework
      • Freso
        (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.)
      • Leo_Verto
        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.
      • ruaok
        sorry.
      • soon.
      • Leo_Verto
        bitmap: go!
      • bitmap
        hey
      • ruaok
        Leo_Verto: probably my biggest goal for next week. things should be more free then
      • 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
      • yvanzo
        (looks great btw)
      • ruaok
        iliekcomputers: approved.
      • bitmap
        spent time fixing copious test failures on other prs
      • Leo_Verto
        ruaok: yeah, no problem, I understand that you're pretty busy right now with GDPR and the spontaneous replication failure
      • ruaok
        not to mention accouting, taxes and banking. :(
      • bitmap
        and not much else other than code review :) fin, yvanzo?
      • 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_?
      • chhavi_
        Helo :)
      • CatQuest
        helo!
      • 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!
      • rsh7: go! :)
      • rsh7
        Hi!
      • CatQuest
        hi!
      • rsh7
        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.
      • iliekcomputers
        (and ferbncode was there too :)
      • rsh7
        Gonna have semester exams starting from tomorrow and a bit tight schedule for the coming week.
      • CatQuest
        :D
      • rsh7
        fin! :)
      • CatQuest
        \o/
      • rsh7
        bukwurm: go!
      • bukwurm
        Hi!
      • Freso
        (People still up: zas, ruaok, iliekcomputers, kartikeyaSh_ircc, CatQuest — anyone else who want to go, please let me know explicitly ASAP.)
      • bukwurm
        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.
      • CatQuest
        like in mb?
      • bukwurm
        I am in the process of brushing it up and committing in a day or so.
      • CatQuest
        :D
      • chhavi_
        Looks cool
      • bukwurm
        CatQuest: I have integrated search too, so as and when you type in the name you get most relevant results alongside.
      • CatQuest
        oohhhhh
      • bukwurm
        That's all from my side.
      • Fin.
      • Freso
        bukwurm: Looks really neat.
      • bukwurm
        kartikeyaSh_ircc: Next?
      • Freso: Thanks :)
      • kartikeyaSh_ircc
        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.
      • BrainzBot
        BU-11: Add MusicBrainz database module to brainzutils https://tickets.metabrainz.org/browse/BU-11
      • kartikeyaSh_ircc
        fin
      • bukwurm
        CatQuest: Wait I'll send a GIF or something.
      • kartikeyaSh_ircc
        zas next ??
      • CatQuest
        🙇
      • :(
      • zas
        hey
      • i upgraded all servers, fixed minor issues coming with those upgrades
      • i also upgraded grafana & discourse to latest versions
      • github joined the channel
      • github
        [critiquebrainz] paramsingh closed pull request #206: CB-300: Use postgres-slave instead of master in production (production...use-postgres-slave) https://git.io/vpRMz
      • github has left the channel
      • CatQuest
        !m zas
      • BrainzBot
        You're doing good work, zas!
      • 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...