#metabrainz

/

      • shivam-kapila has quit
      • 2020-02-23 05428, 2020

      • D4RK-PH0ENiX has quit
      • 2020-02-23 05400, 2020

      • D4RK-PH0ENiX joined the channel
      • 2020-02-23 05448, 2020

      • tmontney has quit
      • 2020-02-23 05403, 2020

      • kyan joined the channel
      • 2020-02-23 05445, 2020

      • Gore has quit
      • 2020-02-23 05405, 2020

      • Gore joined the channel
      • 2020-02-23 05432, 2020

      • prabal has quit
      • 2020-02-23 05457, 2020

      • shivam-kapila joined the channel
      • 2020-02-23 05447, 2020

      • goldenshimmer joined the channel
      • 2020-02-23 05427, 2020

      • SomalRudra joined the channel
      • 2020-02-23 05458, 2020

      • dpmittal joined the channel
      • 2020-02-23 05410, 2020

      • SomalRudra has quit
      • 2020-02-23 05417, 2020

      • supersandro2000 has quit
      • 2020-02-23 05442, 2020

      • supersandro2000 joined the channel
      • 2020-02-23 05445, 2020

      • shivam-kapila has quit
      • 2020-02-23 05406, 2020

      • Guest34242 joined the channel
      • 2020-02-23 05411, 2020

      • D4RK-PH0ENiX has quit
      • 2020-02-23 05409, 2020

      • D4RK-PH0ENiX joined the channel
      • 2020-02-23 05429, 2020

      • D4RK-PH0ENiX has quit
      • 2020-02-23 05436, 2020

      • D4RK-PH0ENiX joined the channel
      • 2020-02-23 05440, 2020

      • dpmittal has quit
      • 2020-02-23 05458, 2020

      • shivam-kapila joined the channel
      • 2020-02-23 05427, 2020

      • c1e0 joined the channel
      • 2020-02-23 05428, 2020

      • ruaok
        iliekcomputers: data imported into timescale in 107minutes, with dups removed and unique index created!
      • 2020-02-23 05406, 2020

      • ruaok
        I think I could very easily build in the sub-second last.fm duplicate track scrubber into this process as well.
      • 2020-02-23 05403, 2020

      • ruaok
        this level of data cleaning and then carrying forth with INSERT ... ON CONFLICT DO NOTHING would even allow us to not do all the searches we do on the data -- just insert.
      • 2020-02-23 05415, 2020

      • ruaok
        these arguments are becoming compelling.
      • 2020-02-23 05445, 2020

      • iliekcomputers
        That is pretty fast!
      • 2020-02-23 05414, 2020

      • iliekcomputers
        Can you run the equivalent of this query: https://github.com/metabrainz/listenbrainz-server…
      • 2020-02-23 05423, 2020

      • iliekcomputers
        Out of curiosity
      • 2020-02-23 05433, 2020

      • ruaok
        the only thing I haven't sorted out yet is understanding which tracks are considered unique, so we can push them down the unique pipeline.
      • 2020-02-23 05437, 2020

      • ruaok
        that isn't clear.
      • 2020-02-23 05421, 2020

      • ruaok
        that is guaranteed to be very slow.
      • 2020-02-23 05404, 2020

      • ruaok
        anything that requires a complete scan of the db will be slow and should be avoided in a production server.
      • 2020-02-23 05439, 2020

      • iliekcomputers
        Yeah, I guess that makes sense
      • 2020-02-23 05408, 2020

      • ruaok
        but the timestamp limited queries that hit a few chunks of time, are quite fast.
      • 2020-02-23 05404, 2020

      • ruaok
        want a login to the VM?
      • 2020-02-23 05421, 2020

      • iliekcomputers
        If that query had a ts limit until last week
      • 2020-02-23 05427, 2020

      • iliekcomputers
        How long would it take
      • 2020-02-23 05456, 2020

      • ruaok
        find out: 34.68.39.62
      • 2020-02-23 05400, 2020

      • ruaok
        param@ should work now.
      • 2020-02-23 05406, 2020

      • iliekcomputers
        I'm just wondering if it has a use case for doing smaller stats things, so we don't have to create specific jobs for sparks for small stuff
      • 2020-02-23 05410, 2020

      • ruaok
        postgres is exposed on 5432
      • 2020-02-23 05417, 2020

      • iliekcomputers
        Awesome thanks!
      • 2020-02-23 05421, 2020

      • ruaok
        run queries as you would any other normal psql instance.
      • 2020-02-23 05436, 2020

      • ruaok
        "I'm just wondering if it has a use case for doing smaller stats things, so we don't have to create specific jobs for sparks for small stuff"
      • 2020-02-23 05442, 2020

      • ruaok
        possibly.
      • 2020-02-23 05447, 2020

      • iliekcomputers
        Can we use pg_dump now?
      • 2020-02-23 05457, 2020

      • ruaok
        yes.
      • 2020-02-23 05406, 2020

      • ruaok
        anything PG you want to use, use it.
      • 2020-02-23 05421, 2020

      • iliekcomputers
        Well, that is really convenient
      • 2020-02-23 05434, 2020

      • ruaok
        if we write a full TimescaleListenStore, it would mostly invole deleting influx code and porting things to psql.
      • 2020-02-23 05459, 2020

      • ruaok
        I'll probably have that done even before our hack-day. there just isn't that much work to do.
      • 2020-02-23 05402, 2020

      • Gazooo has quit
      • 2020-02-23 05443, 2020

      • Gazooo joined the channel
      • 2020-02-23 05410, 2020

      • dotmavriq joined the channel
      • 2020-02-23 05402, 2020

      • sbvkrishna joined the channel
      • 2020-02-23 05445, 2020

      • Sophist-UK joined the channel
      • 2020-02-23 05406, 2020

      • sweta05 joined the channel
      • 2020-02-23 05446, 2020

      • shivam-kapila has quit
      • 2020-02-23 05415, 2020

      • dotmavriq has quit
      • 2020-02-23 05402, 2020

      • reosarevok
        bitmap: do you think https://tickets.metabrainz.org/browse/MBS-10661 is related to the recent changes to rels display or an older issue?
      • 2020-02-23 05404, 2020

      • BrainzBot
        MBS-10661: Recording-work rel not showing pending edits on release page
      • 2020-02-23 05412, 2020

      • sbvkrishna has quit
      • 2020-02-23 05427, 2020

      • sweta05 has quit
      • 2020-02-23 05459, 2020

      • anant joined the channel
      • 2020-02-23 05426, 2020

      • c1e0 has quit
      • 2020-02-23 05431, 2020

      • Guest34242 is now known as killme
      • 2020-02-23 05409, 2020

      • Cyna
        Hey reosarevok could you tell me what are the edit you made, that broke the edit display ?
      • 2020-02-23 05436, 2020

      • reosarevok
        I just loaded the recent edits
      • 2020-02-23 05441, 2020

      • reosarevok
        On the edit search page
      • 2020-02-23 05432, 2020

      • reosarevok
        Cyna: I suspect you can reproduce it by editing a work without type to have a type or the other way around though
      • 2020-02-23 05437, 2020

      • supersandro2000 has quit
      • 2020-02-23 05451, 2020

      • supersandro2000 joined the channel
      • 2020-02-23 05411, 2020

      • reosarevok
      • 2020-02-23 05412, 2020

      • BrainzBot
        MBS-10660: Interwiki links are incorrectly configured on MB wiki
      • 2020-02-23 05420, 2020

      • reosarevok
        (lb and ab are not supposed to be language links :D )
      • 2020-02-23 05451, 2020

      • moufl joined the channel
      • 2020-02-23 05434, 2020

      • supersandro2000 has quit
      • 2020-02-23 05449, 2020

      • supersandro2000 joined the channel
      • 2020-02-23 05404, 2020

      • Lotheric
        amCap1712: think it would be possible to install your plugin on VLC for android tv ?
      • 2020-02-23 05423, 2020

      • Lotheric has an android tv box to test it out :)
      • 2020-02-23 05434, 2020

      • amCap1712
        Lotheric: to quote vlc devs, that question has a compex answer. it might or might not work.
      • 2020-02-23 05414, 2020

      • Lotheric
        would I need to follow the linux guide for it ?
      • 2020-02-23 05425, 2020

      • Lotheric
        I'll try it on my box to see if it works
      • 2020-02-23 05453, 2020

      • amCap1712
        However, since the plugin is almost similar to audioscrobbler except tls part if audioscrobbler works, listenbrainz should work as well
      • 2020-02-23 05408, 2020

      • Lotheric
      • 2020-02-23 05457, 2020

      • amCap1712
        i am not familiar with android tv interface but yes you should follow linux guide
      • 2020-02-23 05429, 2020

      • Lotheric
        it has a VLC app in the store, I'll try to fiddle with it :)
      • 2020-02-23 05431, 2020

      • amCap1712
        you can ping me with any queries you have while installing or using it if it gets installed
      • 2020-02-23 05425, 2020

      • BrainzGit
        [bookbrainz-site] endurance21 opened pull request #378 (master…uiImprovement): fixed text overflow on add edition page https://github.com/bookbrainz/bookbrainz-site/pul…
      • 2020-02-23 05435, 2020

      • amCap1712
        my only doubt is whether you can use an external plugin with android app
      • 2020-02-23 05414, 2020

      • chaban
        So I've finally found out why MBS-10477 happens.
      • 2020-02-23 05415, 2020

      • BrainzBot
        MBS-10477: Guess feat. artists picking up some mix artists https://tickets.metabrainz.org/browse/MBS-10477
      • 2020-02-23 05401, 2020

      • Cyna
        reosarevok: I think the error is in here `lp_attributes(type.new?.name ?? '', 'work_type')`
      • 2020-02-23 05427, 2020

      • Cyna
        empty string is not a valid translation key
      • 2020-02-23 05410, 2020

      • reosarevok
        Yeah, exactly, that's why you need to do what you did for EditSeries, where you had the exact same problem :)
      • 2020-02-23 05434, 2020

      • Cyna
        Yep solved it and in a funny way XD
      • 2020-02-23 05416, 2020

      • Cyna
        ohh it was the same way as in EditSeries :(
      • 2020-02-23 05450, 2020

      • reosarevok
        Well, that's good, we should be consistent across files :p
      • 2020-02-23 05402, 2020

      • Cyna
        reosarevok: done with both the PRs
      • 2020-02-23 05410, 2020

      • Cyna
        Let me know once you're done with them :)
      • 2020-02-23 05435, 2020

      • anant has quit
      • 2020-02-23 05412, 2020

      • sweta05 joined the channel
      • 2020-02-23 05418, 2020

      • anant joined the channel
      • 2020-02-23 05404, 2020

      • BrainzGit
        [musicbrainz-server] reosarevok opened pull request #1398 (master…MBS-10659): MBS-10659: Always show entity credits in rel edits https://github.com/metabrainz/musicbrainz-server/…
      • 2020-02-23 05405, 2020

      • BrainzBot
        MBS-10659: Edit relationship edit not showing credits if they don't change https://tickets.metabrainz.org/browse/MBS-10659
      • 2020-02-23 05440, 2020

      • reosarevok
        yvanzo, bitmap ^ small bugfix that would be great to merge for next release unless it's more complicated than what I thought :)
      • 2020-02-23 05434, 2020

      • sweta05 has quit
      • 2020-02-23 05451, 2020

      • ZaphodBeeblebrox
        BrainzBot: !m test
      • 2020-02-23 05451, 2020

      • BrainzBot
        You're doing good work, test!
      • 2020-02-23 05423, 2020

      • Cyna
        BrainzBot: !m me
      • 2020-02-23 05423, 2020

      • BrainzBot
        You're doing good work, me!
      • 2020-02-23 05429, 2020

      • Cyna
        BrainzBot: !m /me
      • 2020-02-23 05429, 2020

      • BrainzBot
        You're doing good work, /me!
      • 2020-02-23 05437, 2020

      • Freso
        Please keep bot testing to #brainzbot
      • 2020-02-23 05431, 2020

      • Cyna
        Why cant me be converted to the username :(. Freso do you have a repository of IRC bot ?
      • 2020-02-23 05438, 2020

      • ZaphodBeeblebrox
        sorry I wastesting ot see if i was actually *in* here (that is online9
      • 2020-02-23 05409, 2020

      • Freso
        ZaphodBeeblebrox: A single one-off thing is one thing, but when people then pick up on it and it starts to be a whole thing…
      • 2020-02-23 05422, 2020

      • ZaphodBeeblebrox
        yeh. I mean I didn't want that, sorry
      • 2020-02-23 05433, 2020

      • Freso
        ZaphodBeeblebrox: No worries. ❤️
      • 2020-02-23 05437, 2020

      • ZaphodBeeblebrox
        :D
      • 2020-02-23 05453, 2020

      • Freso
      • 2020-02-23 05436, 2020

      • Cyna
        Yay Freso are we using this ? https://github.com/metabrainz/brainzbot-bot
      • 2020-02-23 05443, 2020

      • Freso
        Yes.
      • 2020-02-23 05416, 2020

      • Freso
        Note that there is also a "source" link at the bottom of https://chatlogs.metabrainz.org/
      • 2020-02-23 05425, 2020

      • Freso
      • 2020-02-23 05425, 2020

      • Freso
        I don’t think it’s a good idea to add a lot of more advanced logic to that. If you want to !m yourself, just do "!m Cyna".
      • 2020-02-23 05424, 2020

      • Cyna
        Well I'll be playing with https://github.com/thoj/go-ircevent and create a bot for my own channel. Strange why both python and Go is used 🤔
      • 2020-02-23 05430, 2020

      • vishnuedavarath joined the channel
      • 2020-02-23 05410, 2020

      • Cyna
        reosarevok: can you restart this ?https://circleci.com/gh/metabrainz/musicbrainz-server/9401?utm_campaign=workflow-failed&utm_medium=email&utm_source=notification
      • 2020-02-23 05402, 2020

      • vishnuedavarath has quit
      • 2020-02-23 05455, 2020

      • c1e0 joined the channel
      • 2020-02-23 05408, 2020

      • Lotheric has quit
      • 2020-02-23 05422, 2020

      • Lotheric joined the channel
      • 2020-02-23 05440, 2020

      • reosarevok
        Cyna: rebase on latest master
      • 2020-02-23 05449, 2020

      • Cyna
        ok
      • 2020-02-23 05452, 2020

      • Freso
        I’m trying to make a list of mentors we’ve sent to the GCI student trip in the past. Does anyone remember who went on the 2017, 2018, and 2019 trips? Was LordSputnik 2017?
      • 2020-02-23 05419, 2020

      • Freso
        Managed to help myself via my e-mail archives. :)
      • 2020-02-23 05402, 2020

      • rdswift has quit
      • 2020-02-23 05433, 2020

      • iliekcomputers
        given that the import was stuck on the single file, since yesterday, i'm debugging on leader with incremental dumps, you might see errors on sentry lb beta.
      • 2020-02-23 05414, 2020

      • rdswift joined the channel
      • 2020-02-23 05434, 2020

      • iliekcomputers
        files still not importing
      • 2020-02-23 05414, 2020

      • iliekcomputers
        huh
      • 2020-02-23 05420, 2020

      • iliekcomputers
        so i stopped the request consumer
      • 2020-02-23 05428, 2020

      • iliekcomputers
        and the import started working
      • 2020-02-23 05435, 2020

      • iliekcomputers
        whatttt
      • 2020-02-23 05451, 2020

      • iliekcomputers
      • 2020-02-23 05404, 2020

      • iliekcomputers
        looks like there needs to be some hacking around sparkcontexts