Reconnecting Spotify account: psycopg2 Unique ID constraint violation for user_id_service_ndx_listens_importer

ExportXMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • None
    • Component/s: data dumps, import tools
    • None

      Got an e-mail saying ListenBrainz lost access to my Spotify account (which I did not do):

      We encountered an error while importing your listens from Spotify.
The error was as follows: "It seems like you've revoked permission for us to read your spotify account"

Please take a look at your Spotify import page (https://listenbrainz.org/profile/music-services/details/)
for more information.

      Followed the link, and selected the top option (Activate Both Features)

      Then the Spotify login window popped up and I entered my credentials

      That went fine, but when we returned to the ListenBrainz page this error message popped up:

       

      (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "user_id_service_ndx_listens_importer" DETAIL: Key (user_id, service)=(11309, spotify) already exists. [SQL: INSERT INTO listens_importer (external_service_oauth_id, user_id, service) VALUES (%(external_service_oauth_id)s, %(user_id)s, %(service)s) ] [parameters: {'external_service_oauth_id': 12949, 'user_id': 11309, 'service': 'spotify'}] (Background on this error at: http://sqlalche.me/e/13/gkpj)

      Looks like you tried INSERTing a record that should have been UPDATEd?

            Assignee:
            amCap1712
            Reporter:
            Chris Eveley
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package