#metabrainz

/

      • ruaok
        I'll try it.
      • 2021-11-16 32057, 2021

      • lucifer
        👍
      • 2021-11-16 32017, 2021

      • ruaok
        still throw the same cardinality error
      • 2021-11-16 32027, 2021

      • ruaok
      • 2021-11-16 32050, 2021

      • ruaok
        or do you think the distinct should be over the whole row?
      • 2021-11-16 32034, 2021

      • ruaok
        yeah, I did that right and it doesn't work.
      • 2021-11-16 32045, 2021

      • ruaok
        I think i am asking just a wee bit too much:wq
      • 2021-11-16 32039, 2021

      • lucifer
        ruaok: uhh strange. this query works for me locally.
      • 2021-11-16 32042, 2021

      • lucifer
      • 2021-11-16 32020, 2021

      • ruaok
        quite frankly, I've sunk way too much time into this stupid query. any more changes and this will continue to be a timesink.
      • 2021-11-16 32042, 2021

      • ruaok
        doing two separate inserts in one transaction is actually less code and understandable by humans.
      • 2021-11-16 32054, 2021

      • lucifer
        makes sense
      • 2021-11-16 32032, 2021

      • alastairp
      • 2021-11-16 32039, 2021

      • alastairp
        oh hey, that's what's happening outside my window
      • 2021-11-16 32054, 2021

      • reosarevok
        bitmap: when you're around, I'm not quite sure what I need to change to make https://github.com/reosarevok/musicbrainz-server/… work
      • 2021-11-16 32054, 2021

      • BrainzBot
        MBS-11910: Allow editing relationship credits in the new URL editor pop-in
      • 2021-11-16 32038, 2021

      • reosarevok
        (right now it's some weird thing where it actually detects the credit as present sometimes, but not other times, and I'm not sure why)
      • 2021-11-16 32039, 2021

      • monkey
        lol alastairp that explains why nobody was trying to clean up the place :D
      • 2021-11-16 32052, 2021

      • alastairp
        hah, yeah
      • 2021-11-16 32009, 2021

      • alastairp
        they were filming in the building in the distance a bit a few months ago, not sure if it was related
      • 2021-11-16 32025, 2021

      • alastairp
        but then about 3 weeks ago they started building fake sidewalk + road
      • 2021-11-16 32038, 2021

      • alastairp
        last week they've been finishing the facades of the buildings
      • 2021-11-16 32048, 2021

      • alastairp
        the green-screen blocks a lot of what I can see from the window :(
      • 2021-11-16 32035, 2021

      • alastairp
        3-4 months of filming though. at least they won't be building any new houses there until that's finished...
      • 2021-11-16 32055, 2021

      • PetrCBRCZ has quit
      • 2021-11-16 32025, 2021

      • nelgin
        yvanzo, I did update to the latest version so I guess the bug isn't fixed.
      • 2021-11-16 32051, 2021

      • nelgin
        and yes, I blew everything away and redownloaded from git.
      • 2021-11-16 32049, 2021

      • Lotheric_ joined the channel
      • 2021-11-16 32002, 2021

      • Lotheric has quit
      • 2021-11-16 32025, 2021

      • yvanzo
      • 2021-11-16 32045, 2021

      • yvanzo
        I will try to reproduce the issue locally.
      • 2021-11-16 32008, 2021

      • trolley has quit
      • 2021-11-16 32023, 2021

      • kgz has quit
      • 2021-11-16 32045, 2021

      • kgz joined the channel
      • 2021-11-16 32019, 2021

      • trolley joined the channel
      • 2021-11-16 32020, 2021

      • adhawkins_ joined the channel
      • 2021-11-16 32021, 2021

      • adhawkins has quit
      • 2021-11-16 32042, 2021

      • adhawkins_ is now known as adhawkins
      • 2021-11-16 32034, 2021

      • nelgin
        yvanzo that's what I already have it set to in .env
      • 2021-11-16 32035, 2021

      • nelgin
      • 2021-11-16 32000, 2021

      • nelgin
        Ah
      • 2021-11-16 32000, 2021

      • BrainzGit
        [listenbrainz-server] 14akshaaatt merged pull request #1730 (03master…monkey-listencard-flexbox-improvements): ListenCard responsive improvements https://github.com/metabrainz/listenbrainz-server…
      • 2021-11-16 32007, 2021

      • nelgin
        I missed the ftp:// Let me try that.
      • 2021-11-16 32010, 2021

      • monkey
        Thanks akshaaatt !
      • 2021-11-16 32044, 2021

      • akshaaatt
        !m monkey
      • 2021-11-16 32044, 2021

      • BrainzBot
        You're doing good work, monkey!
      • 2021-11-16 32011, 2021

      • monkey
        lucifer: cover art PRs are merged, ready to deploy whenever you want/can :)
      • 2021-11-16 32015, 2021

      • monkey
        And thank you
      • 2021-11-16 32041, 2021

      • nelgin
        Since it says FTP_UTL you'd think it was implied that it would use ftp:// :)
      • 2021-11-16 32042, 2021

      • akshaaatt
        monkey I just noticed that the huesound listencards do not showcase the menu options for opening in mb, etc
      • 2021-11-16 32051, 2021

      • akshaaatt
        Is that intentional or a potential bug?
      • 2021-11-16 32029, 2021

      • monkey
        That's added automatically if the data required is in the listen, so we're probably missing it in the huesound listens, let me check
      • 2021-11-16 32044, 2021

      • akshaaatt
        Yus
      • 2021-11-16 32026, 2021

      • monkey
        Hm, I guess not, recording_mbid is in there as expected
      • 2021-11-16 32010, 2021

      • reosarevok
        yvanzo, bitmap: let's try to add stuff to https://github.com/metabrainz/musicbrainz-server/… by tomorrow evening btw? We can meet at 18 or 19 and look into it a bit maybe
      • 2021-11-16 32010, 2021

      • CatQuest
        trolley: are you this kind of trolley https://www.unishop.co.uk/det/1563/Large-Supermar… or troll-ey ?
      • 2021-11-16 32012, 2021

      • reosarevok
        If needed
      • 2021-11-16 32021, 2021

      • CatQuest
        :D
      • 2021-11-16 32046, 2021

      • reosarevok
        yvanzo, bitmap: also, we might want to stick to a three week cycle for *next* release too, and go back to 2 weeks after
      • 2021-11-16 32014, 2021

      • monkey
        Yes that's abug akshaaatt, please open a ticket :)
      • 2021-11-16 32044, 2021

      • akshaaatt
        Sure! I'll fix it.
      • 2021-11-16 32059, 2021

      • bitmap
        reosarevok: sounds good to me
      • 2021-11-16 32049, 2021

      • monkey
        akshaaatt: This condition is incorrect: https://github.com/metabrainz/listenbrainz-server…
      • 2021-11-16 32042, 2021

      • monkey
        It doesn't take into account `recordingMBID`, `spotifyURL`, `youtubeURL` or `soundcloudURL`.
      • 2021-11-16 32004, 2021

      • monkey
        Time to refactor this into more readable code and avoid the mistake I made :)
      • 2021-11-16 32000, 2021

      • akshaaatt
        Thanks for the head start!
      • 2021-11-16 32044, 2021

      • lucifer
        monkey: 👍 doing a release
      • 2021-11-16 32050, 2021

      • BrainzGit
        [listenbrainz-server] release 03v-2021-11-16.0 has been published by 14github-actions[bot]: https://github.com/metabrainz/listenbrainz-server…
      • 2021-11-16 32036, 2021

      • bitmap
        reosarevok: this line in handleConfirm is suspect - confirmedProps[state.creditableEntityCredit] = state.credit.value;
      • 2021-11-16 32051, 2021

      • bitmap
        state.creditableEntityCredit is undefined there
      • 2021-11-16 32033, 2021

      • reosarevok
        Oh, yeah, I guess I need to pass that to the state on createInitialState
      • 2021-11-16 32036, 2021

      • monkey
        Now that we're adding cover art everywhere, it would be interesting to look at the Save-Data HTTP header, and set a global prop accordingly. Then in React we can decide to show artwork or not.
      • 2021-11-16 32036, 2021

      • monkey
      • 2021-11-16 32044, 2021

      • reosarevok
        Unless you see a simpler way to do all this
      • 2021-11-16 32047, 2021

      • monkey makes a ticket
      • 2021-11-16 32044, 2021

      • alastairp
        never heard of Save-Data before
      • 2021-11-16 32026, 2021

      • monkey
        There's a proposed CSS solution for this as well (which is how I know of it) but in our case a property in React is more adapted. Plus it's not currently supported anywhere…
      • 2021-11-16 32034, 2021

      • bitmap
        reosarevok: I guess props.relationship.creditableEntityCredit works too
      • 2021-11-16 32058, 2021

      • reosarevok
        bitmap: ok, the whole thing does the trick, but now I need to figure out how to actually save the credit :D
      • 2021-11-16 32016, 2021

      • lucifer
        spotify reader emitting lots of 404s. trying to reach spotify.com manually also gives 404. probably a spotify downtime.
      • 2021-11-16 32018, 2021

      • monkey
        Confirming 404 on spotify.com
      • 2021-11-16 32032, 2021

      • akshaaatt
        Interesting
      • 2021-11-16 32057, 2021

      • reosarevok
        Weird, I'm listening to Spotify rn, maybe it just pre-downloaded the podcast :D
      • 2021-11-16 32036, 2021

      • akshaaatt
        I received an email from LB saying that there has been an issue with the import
      • 2021-11-16 32003, 2021

      • akshaaatt
        Does this mean all our users who have authenticated Spotify on LB have received this email?
      • 2021-11-16 32020, 2021

      • lucifer
        i think so. yes.
      • 2021-11-16 32059, 2021

      • lucifer
        that also means that import will eventually be disabled for all users. once spotify is back up, will need to run a script to restart imports for all users
      • 2021-11-16 32011, 2021

      • monkey didn't receive that email
      • 2021-11-16 32057, 2021

      • reosarevok
        I did
      • 2021-11-16 32008, 2021

      • reosarevok
        Which reminds me, does the Spotify importer also import podcasts?
      • 2021-11-16 32055, 2021

      • lucifer
        the mail will be sent after a few retries fail, i do see a lot of recent failures here https://listenbrainz.org/admin/listens_importer_m…
      • 2021-11-16 32018, 2021

      • lucifer
        reosarevok: no it doesn't
      • 2021-11-16 32022, 2021

      • alastairp
        lucifer: I wonder if we need some better error detection here. perhaps 404 shouldnt trigger thi failure
      • 2021-11-16 32044, 2021

      • akshaaatt
        lucifer is it desirable to continue the entire process once we find a 404 or the script should put a hault? Considering sending emails to a large userbase in a short interval of time could be undesirable I think?
      • 2021-11-16 32011, 2021

      • monkey
        Ah, now I got the email
      • 2021-11-16 32001, 2021

      • lucifer
        alastairp: i think that makes sense. but what to do for those errors, ignore and keep retrying?
      • 2021-11-16 32027, 2021

      • alastairp
        at the very least we could do a back-off
      • 2021-11-16 32051, 2021

      • alastairp
        we had a discussion about this a few months ago, to improve the importer and make it more responsive, especially for now-playings
      • 2021-11-16 32011, 2021

      • alastairp
        and so the same system could help us add a backoff in some cases
      • 2021-11-16 32036, 2021

      • alastairp
        we could back off a few times, and only after it fails many times we quit and send the mail
      • 2021-11-16 32036, 2021

      • lucifer
        akshaaatt: the script halts the import and thus the user is notified. the intent is that the error usually means user intervention is needed. sending a lot of mails is undesirable indeed but not sure about the best way forward here
      • 2021-11-16 32052, 2021

      • akshaaatt
        Right
      • 2021-11-16 32017, 2021

      • akshaaatt
        I'm interested in what alastairp says I think that could be good
      • 2021-11-16 32020, 2021

      • alastairp
        but I think we also now know of a few different failure modes now, and so perhaps should differentiate them
      • 2021-11-16 32021, 2021

      • lucifer
        backing off makes sense.
      • 2021-11-16 32043, 2021

      • alastairp
        the auth failure - we know that this can happen when people revoke permissions
      • 2021-11-16 32006, 2021

      • alastairp
        but others seem to be a bit more transient - 500? 404? ...
      • 2021-11-16 32032, 2021

      • lucifer
        yeah indeed. afair, auth revocation is the only one needing user intervention. all others are transient errors and resolve themselves after some retries.
      • 2021-11-16 32004, 2021

      • rdswift_ joined the channel
      • 2021-11-16 32018, 2021

      • alastairp
        perfect
      • 2021-11-16 32011, 2021

      • rdswift has quit
      • 2021-11-16 32019, 2021

      • rdswift_ is now known as rdswift
      • 2021-11-16 32058, 2021

      • lucifer
        to implement this stuff, i am thinking of a column like is_error_transient flag or error_type enum
      • 2021-11-16 32036, 2021

      • lucifer
        for permanent errors (auth revocation), send email and stop. for transient errors, don't retry for another hour or so? for a few times and then upgrade that to a permanent error and send mail
      • 2021-11-16 32015, 2021

      • alastairp
        yeah, that could work
      • 2021-11-16 32017, 2021

      • lucifer
      • 2021-11-16 32039, 2021

      • lucifer
        weird thing, the rmq errors stopped 14 mins ago. roughly around when spotify reader stopped
      • 2021-11-16 32026, 2021

      • alastairp
        or maybe an 'importer events' table
      • 2021-11-16 32039, 2021

      • alastairp
        oh, interesting
      • 2021-11-16 32058, 2021

      • alastairp
        you think that maybe the spotify tool is causing weird connections?
      • 2021-11-16 32029, 2021

      • lucifer
        i think its not spotify but the load. bulk of incoming listens is spotify reader.
      • 2021-11-16 32038, 2021

      • alastairp
        right, got it
      • 2021-11-16 32022, 2021

      • v6lur joined the channel
      • 2021-11-16 32055, 2021

      • rdswift
        The really strange thing is that I also received the email, but I'm not on Spotify.
      • 2021-11-16 32029, 2021

      • lucifer
        oh, what's your LB username rdswift ?
      • 2021-11-16 32030, 2021

      • alastairp
        lucifer: will we know which accounts failed due to this outage, compared to previous failures? :/
      • 2021-11-16 32041, 2021

      • alastairp
        maybe based on the time that we marked it as failed?
      • 2021-11-16 32042, 2021

      • rdswift
        rdswift
      • 2021-11-16 32052, 2021

      • lucifer
        alastairp, we can see the last updated and make a reasonable guess
      • 2021-11-16 32046, 2021

      • lucifer
        rdswift: but i do see in db that you have spotify connected.
      • 2021-11-16 32012, 2021

      • lucifer
        latest listened at is very old though. 2020-01-06 17:28:51+00:00
      • 2021-11-16 32037, 2021

      • alastairp
        I tweeted about the outage
      • 2021-11-16 32041, 2021

      • lucifer
        thanks!
      • 2021-11-16 32042, 2021

      • rdswift
        Interesting. I don't think I've listened to anything on Spotify for weeks.
      • 2021-11-16 32034, 2021

      • alastairp
      • 2021-11-16 32017, 2021

      • lucifer
        afaiu importer works for free accounts too, its the playing now feature that needs premium.
      • 2021-11-16 32035, 2021

      • rdswift
        I guess it's been years rather than weeks. :-)
      • 2021-11-16 32009, 2021

      • rdswift
        I guess there's nothing that triggers an update to your database that I'm not connected, although I don't suppose that's an issue.
      • 2021-11-16 32055, 2021

      • alastairp
        rdswift: you could turn it off yourself, but I guess we don't disable it ourselves if we don't see any activity
      • 2021-11-16 32030, 2021

      • rdswift
        Not a big deal either way. I was just a bit surprised when I received the email. Might be an idea to check the last listen date and not send the email if it's over x days?
      • 2021-11-16 32041, 2021

      • alastairp
        yeah, or we could automatically disconnect it after x months, sending an email indicating it
      • 2021-11-16 32058, 2021

      • navap1 has quit
      • 2021-11-16 32023, 2021

      • navap1 joined the channel
      • 2021-11-16 32049, 2021

      • rdswift
        Is it a problem leaving it connected?
      • 2021-11-16 32033, 2021

      • alastairp
        a problem for us? not at all
      • 2021-11-16 32059, 2021

      • rdswift
        In that case, I don't think I would bother having you automatically show it as disconnected after x months.
      • 2021-11-16 32018, 2021

      • rdswift
        One less piece of code to run periodically. ;-)
      • 2021-11-16 32025, 2021

      • alastairp
        in this case I'd just do it as part of the infinite loop that we have recording listens anyway... if last_listened_time < 6 months ago: email and disable account, then it won't get caught the next time around
      • 2021-11-16 32038, 2021

      • alastairp
        but you're right, if it's not causing us problems then probably no reason not to
      • 2021-11-16 32040, 2021

      • v6lur has quit