#metabrainz

/

      • mayhem
        that would also, incidentally, be a good way to die.
      • 2023-09-25 26811, 2023

      • reosarevok
        I mean, Estonia is not a famous chocolate land :p
      • 2023-09-25 26822, 2023

      • reosarevok
        I thought I'd try to get some more in FRA
      • 2023-09-25 26859, 2023

      • mayhem
        its more that I want to show the extremes that I am going through to procure chocolate. that gets more people to bring more chocolate.
      • 2023-09-25 26819, 2023

      • mayhem
        and FRA isn't going to have anything interesting -- I bet I could buy most of that crap here in BCN.
      • 2023-09-25 26846, 2023

      • mayhem
      • 2023-09-25 26807, 2023

      • reosarevok
        Ok, I can see if I can find a couple more semi-interesting things on the way
      • 2023-09-25 26848, 2023

      • reosarevok
        yvanzo: then it doubles as a show of how the belly will look like afterwards :p
      • 2023-09-25 26849, 2023

      • monkey thinks a chocolate meteorite would melt upon atmospheric entry, which is sad, but on the other hand… https://musicbrainz.org/recording/9c3edf10-7021-4fde-9c3b-2b51dbc60fcf
      • 2023-09-25 26808, 2023

      • mayhem
        that depends on how big the meteorite is!
      • 2023-09-25 26854, 2023

      • Sophist-UK joined the channel
      • 2023-09-25 26826, 2023

      • Sophist-UK has quit
      • 2023-09-25 26848, 2023

      • Sophist-UK joined the channel
      • 2023-09-25 26857, 2023

      • monkey
        #ChocolatePlanet
      • 2023-09-25 26824, 2023

      • reosarevok
        If anyone (atj?) wants to try and see some raptor migration on the 1st of Oct in BCN: https://glseobarcelona-com.translate.goog/observa…
      • 2023-09-25 26806, 2023

      • reosarevok
        (they said it's *probably* possible to get a ride with someone for car-less people, but needs to be specified)
      • 2023-09-25 26844, 2023

      • reosarevok
        (it's an event by the local Birdlife / Ornithological Society chapter)
      • 2023-09-25 26838, 2023

      • monkey
        Awwww.
      • 2023-09-25 26847, 2023

      • monkey wanted to see a dinosaur migration
      • 2023-09-25 26856, 2023

      • yvanzo
        from far
      • 2023-09-25 26858, 2023

      • reosarevok
        Technically, that is what this is
      • 2023-09-25 26812, 2023

      • monkey
        I… I guess.
      • 2023-09-25 26820, 2023

      • mayhem
      • 2023-09-25 26833, 2023

      • yvanzo
        reosarevok: MBS release today?
      • 2023-09-25 26851, 2023

      • monkey
        Hahaha, I fully expected a rick roll, but this is cute
      • 2023-09-25 26854, 2023

      • mayhem
        monkey: can you please post the picture of the first white board session?
      • 2023-09-25 26813, 2023

      • reosarevok
        yvanzo: I think I released last week
      • 2023-09-25 26845, 2023

      • reosarevok
      • 2023-09-25 26846, 2023

      • yvanzo
        Ok, I thought it was two weeks ago
      • 2023-09-25 26806, 2023

      • reosarevok
        It was supposed to be but I forgot to put it out 😕
      • 2023-09-25 26804, 2023

      • monkey
      • 2023-09-25 26812, 2023

      • monkey
      • 2023-09-25 26817, 2023

      • monkey
        mayhem: ^
      • 2023-09-25 26849, 2023

      • mayhem
        thx
      • 2023-09-25 26806, 2023

      • yvanzo
        reosarevok: thanks for having put it out eventually :)
      • 2023-09-25 26806, 2023

      • yvanzo
        MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | BookBrainz: #bookbrainz | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Agenda: Reviews, New social channels (reo channels aerozol), Summit agenda (yvanzo)
      • 2023-09-25 26811, 2023

      • TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | BookBrainz: #bookbrainz | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Agenda: Reviews, New social channels (reo channels aerozol), Summit agenda (yvanzo)
      • 2023-09-25 26847, 2023

      • TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | BookBrainz: #bookbrainz | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Agenda: Reviews, Summit agenda (yvanzo)
      • 2023-09-25 26832, 2023

      • reosarevok
        yvanzo: we should freeze today / tomorrow if we want to do a summit release, but might also make sense to release post summit
      • 2023-09-25 26835, 2023

      • reosarevok
        Any preference?
      • 2023-09-25 26843, 2023

      • yvanzo
        tomorrow is fine
      • 2023-09-25 26808, 2023

      • kellnerd is back from yet another chocolate trip
      • 2023-09-25 26823, 2023

      • reosarevok
        Hope it was sweet
      • 2023-09-25 26813, 2023

      • kellnerd
        This is how Ritter Sport looks like, atj: https://usercontent.irccloud-cdn.com/file/M3EM2Km…
      • 2023-09-25 26845, 2023

      • kellnerd
        monkey will like the one in the upper left corner ;)
      • 2023-09-25 26810, 2023

      • monkey
        🍌
      • 2023-09-25 26823, 2023

      • ansh
        monkey: For filtering using release tags, I'm rn fetching those from the MEB database while fetching latest releases. But for fresh releases recommended from the users, I'm not getting those. I've updated the spark schema https://github.com/anshg1214/listenbrainz-server/…
      • 2023-09-25 26823, 2023

      • ansh
        Do i have to make any more changes in spark to fetch releaseTags?
      • 2023-09-25 26800, 2023

      • monkey
        I'll be honest, I know nothing about how all this works. Paging lucifer and mayhem (this is about the Fresh Releases page and the ability to filter by tags)
      • 2023-09-25 26850, 2023

      • monkey
        But ansh I think we had discussed that these advanced features would be coming as a second step, after finishing up the overall layout. Did I miss anything?
      • 2023-09-25 26833, 2023

      • ansh
        I've made relevant changes for tags for all users, so wanted to get that working on personalised releases
      • 2023-09-25 26841, 2023

      • ansh
        releases for all users*
      • 2023-09-25 26806, 2023

      • lucifer
        ansh: i don't see any command for generating user fresh releases being executed. can you retry?
      • 2023-09-25 26847, 2023

      • arsh
        Hi reosarevok: I don’t have anything much to report this week as well. If you can please skip my turn for the meeting.
      • 2023-09-25 26821, 2023

      • lucifer
        ansh: i see, the request consumer is apparently not returning data to spark reader. i'll take a look
      • 2023-09-25 26801, 2023

      • reosarevok
        arsh: sure
      • 2023-09-25 26831, 2023

      • ansh
        lucifer: Are we using this endpoint anywhere except spark and react?
      • 2023-09-25 26831, 2023

      • ansh
      • 2023-09-25 26809, 2023

      • lucifer
        nope
      • 2023-09-25 26805, 2023

      • Pratha-Fish
        reosarevok: Surprisingly the dumps we exported the other day are throwing some errors on import 💀
      • 2023-09-25 26842, 2023

      • reosarevok
        Which?
      • 2023-09-25 26844, 2023

      • Maxr1998 has quit
      • 2023-09-25 26801, 2023

      • Pratha-Fish
        Just a sec
      • 2023-09-25 26855, 2023

      • Pratha-Fish
      • 2023-09-25 26855, 2023

      • Pratha-Fish
        this one reosarevok
      • 2023-09-25 26825, 2023

      • Pratha-Fish
        The area related tables you suggested me to export for my local setup instead of cloning the entirety of the musicbrainz database
      • 2023-09-25 26806, 2023

      • Pratha-Fish
        I went ahead and exported the above tables to a SQL script, and currently I am in the process of importing them
      • 2023-09-25 26820, 2023

      • Maxr1998 joined the channel
      • 2023-09-25 26807, 2023

      • Pratha-Fish
        IK you suggested me to recheck when with an import as well, but I was in a hurry to leave the other day so I couldn't. 🫠
      • 2023-09-25 26855, 2023

      • reosarevok
        Yes, which errors I meant
      • 2023-09-25 26831, 2023

      • Pratha-Fish
        Here's the log from this command that I ran: `psql -h localhost -U musicbrainz -d musicbrainz_test -f pg_area_dump.sql`
      • 2023-09-25 26846, 2023

      • Pratha-Fish
      • 2023-09-25 26810, 2023

      • reosarevok
        psql:pg_area_dump.sql:461: ERROR: relation "link_attribute_type_id_seq" already exists
      • 2023-09-25 26819, 2023

      • reosarevok
        etc mean you're trying to add a table, but you already have it
      • 2023-09-25 26854, 2023

      • Pratha-Fish
        seems like it :D
      • 2023-09-25 26802, 2023

      • reosarevok
        Or well, trying to add a sequence I guess
      • 2023-09-25 26821, 2023

      • reosarevok
        psql:pg_area_dump.sql:119664: ERROR: insert or update on table "area" violates foreign key constraint "area_fk_type"
      • 2023-09-25 26841, 2023

      • reosarevok
        That is expected, you need to add these in a specific order - area type needs to go in before area - or disable fks entirely while you import
      • 2023-09-25 26859, 2023

      • Pratha-Fish
        OoOo
      • 2023-09-25 26826, 2023

      • Pratha-Fish
        Do you think it would be possible to rearrage commands with a 1.4GB SQL file tho? 💀
      • 2023-09-25 26842, 2023

      • reosarevok
        Otherwise if it tries to import area before area_type it will fail
      • 2023-09-25 26829, 2023

      • Pratha-Fish
        Hmm
      • 2023-09-25 26840, 2023

      • Pratha-Fish
        So how do you suggest we should solve it?
      • 2023-09-25 26802, 2023

      • reosarevok
      • 2023-09-25 26809, 2023

      • reosarevok
      • 2023-09-25 26817, 2023

      • reosarevok
        But maybe you could try that before import
      • 2023-09-25 26825, 2023

      • reosarevok
        bitmap probably has better ideas
      • 2023-09-25 26835, 2023

      • reosarevok
        Our mirror servers for example just don't use FKs at all
      • 2023-09-25 26837, 2023

      • Pratha-Fish
        That's helpful!
      • 2023-09-25 26852, 2023

      • reosarevok
        "psql:pg_area_dump.sql:12879936: ERROR: multiple primary keys for table "link_attribute" are not allowed"
      • 2023-09-25 26803, 2023

      • reosarevok
        That sounds like you're trying to add new PKs to tables
      • 2023-09-25 26807, 2023

      • Pratha-Fish
        do the mirror servers work completely as expected even without the fks?
      • 2023-09-25 26807, 2023

      • reosarevok
        That already exist
      • 2023-09-25 26822, 2023

      • reosarevok
        I assume you're not trying this with a blank DB? You probably should
      • 2023-09-25 26836, 2023

      • Pratha-Fish
        _Exactly_
      • 2023-09-25 26843, 2023

      • Pratha-Fish
        I am running the import on musicbrainz_test
      • 2023-09-25 26854, 2023

      • reosarevok
        They only get data straight from us, so in theory they should :) Mirrors I mean
      • 2023-09-25 26804, 2023

      • reosarevok
        Ok, meeting now, but ask after if it's still not working :)
      • 2023-09-25 26810, 2023

      • Pratha-Fish
        epic
      • 2023-09-25 26818, 2023

      • Pratha-Fish
        On to the meet 🏃‍♂️
      • 2023-09-25 26822, 2023

      • reosarevok
        <BANG>
      • 2023-09-25 26807, 2023

      • reosarevok
        Welcome to the pre-summit Monday meeting, where we all talk about how we have to have a flight and it's THIIIIIS long
      • 2023-09-25 26813, 2023

      • reosarevok
        (but aerozol means it)
      • 2023-09-25 26843, 2023

      • reosarevok
        arsh said this week they didn't do much so they're skipping today
      • 2023-09-25 26844, 2023

      • mayhem
        lucifer wins this round, I think. but not for our summit.
      • 2023-09-25 26800, 2023

      • reosarevok
        I also have one mailed-in review, by aerozol:
      • 2023-09-25 26800, 2023

      • mayhem
        (15,5 hrs DBX->SFO)
      • 2023-09-25 26800, 2023

      • reosarevok
        '''
      • 2023-09-25 26815, 2023

      • reosarevok
        Made some playlists, did socials, prepped stuff for the summit
      • 2023-09-25 26821, 2023

      • reosarevok
        I’ll make some overlays for the livestream tomorrow - let me know if you have any requests/ideas. At this stage it will be a space for ‘On now: abcd’, ‘Up next: abcd’, and the IRC chat. Perhaps also a ‘back in xx:xx’ timer for breaks.
      • 2023-09-25 26824, 2023

      • reosarevok
        Also, and you’re going to say “that’s not possible”, but I think I bought too much NZ chocolate and candy
      • 2023-09-25 26826, 2023

      • reosarevok
        '''
      • 2023-09-25 26800, 2023

      • monkey
        That's not possible
      • 2023-09-25 26804, 2023

      • reosarevok
        '''
      • 2023-09-25 26806, 2023

      • reosarevok
        The first person who wrote “that’s not possible” can go next
      • 2023-09-25 26807, 2023

      • reosarevok
        '''
      • 2023-09-25 26809, 2023

      • reosarevok
        go monkey
      • 2023-09-25 26813, 2023

      • monkey
        Hello :)
      • 2023-09-25 26819, 2023

      • Pratha-Fish haha
      • 2023-09-25 26840, 2023

      • monkey
        Last week I deployed a new version of BookBrainz, promptly found a regression that I'm working on 👏
      • 2023-09-25 26802, 2023

      • monkey
        Also deployed a new beta version with the admin panel and some good quality of life improvements
      • 2023-09-25 26803, 2023

      • reosarevok
        Deployed to beta, right?
      • 2023-09-25 26808, 2023

      • reosarevok
        Right?
      • 2023-09-25 26811, 2023

      • reosarevok
        :D
      • 2023-09-25 26813, 2023

      • monkey
        Also did some general upkeep
      • 2023-09-25 26836, 2023

      • monkey
        Had a good chat with ansh
      • 2023-09-25 26857, 2023

      • monkey
        Worked on some LB PRs
      • 2023-09-25 26812, 2023

      • monkey
        And a bit of GSOC discussions with kellnerd
      • 2023-09-25 26830, 2023

      • monkey
        That's about it, yvanzo can go
      • 2023-09-25 26833, 2023

      • reosarevok
        Other people for today: reosarevok, bitmap, zas, mayhem, lucifer, akshaaatt, atj, ansh, ApeKattQuest, kellnerd, Pratha-Fish, ShivamAwasthi, jasje
      • 2023-09-25 26853, 2023

      • yvanzo
        (and me)
      • 2023-09-25 26801, 2023

      • reosarevok
        Well, you got called :D
      • 2023-09-25 26801, 2023

      • yvanzo
        hi!
      • 2023-09-25 26819, 2023

      • yvanzo
        Last half week I catched up with some things I have been missing.
      • 2023-09-25 26829, 2023

      • yvanzo
        (oh right: "other…")
      • 2023-09-25 26840, 2023

      • yvanzo
        Resumed working on captcha replacement and spam stuff.
      • 2023-09-25 26856, 2023

      • yvanzo
        Started to gather info for prepping the summit.
      • 2023-09-25 26809, 2023

      • yvanzo
        Fin. Go Pratha-Fish!
      • 2023-09-25 26817, 2023

      • Pratha-Fish
        Hi all!
      • 2023-09-25 26821, 2023

      • Pratha-Fish
        This week, I tried forcing the complete MusicBrainz database on my laptop that has like 5GB left on it's drive.
      • 2023-09-25 26826, 2023

      • Pratha-Fish
        After realizing the size of the MB database, I decided to stick with importing necessary tables instead :/
      • 2023-09-25 26843, 2023

      • Pratha-Fish
        I also worked on writing some scripts to import various types of areas from wikidata :D
      • 2023-09-25 26854, 2023

      • Pratha-Fish
        And then I fell sick and ended up back home 💀
      • 2023-09-25 26802, 2023

      • Pratha-Fish
        fin 🐟
      • 2023-09-25 26815, 2023

      • Pratha-Fish
        ApeKattQuest: would you like to go next?
      • 2023-09-25 26825, 2023

      • ApeKattQuest
        Arararara~! hi!
      • 2023-09-25 26838, 2023

      • ApeKattQuest
        Closed INST-1097
      • 2023-09-25 26838, 2023

      • BrainzBot
      • 2023-09-25 26853, 2023

      • ApeKattQuest
        however I'd still love if anyone japanese could translate the text on both https://saisaibatake.ame-zaiku.com/gakki/gakki_ji… and https://saisaibatake.ame-zaiku.com/musical/instru… properly for me, it's relevant to this and also shawm which still needs updating.
      • 2023-09-25 26853, 2023

      • ApeKattQuest
        that's it for me last week. this week I will be busy/away