Uploaded image for project: 'ListenBrainz'
  1. ListenBrainz
  2. LB-962

IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "user_id_service...

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • None
    • None
    • None

      https://sentry.metabrainz.org/organizations/metabrainz/issues/126416/?referrer=jira_plugin

      UniqueViolation: duplicate key value violates unique constraint "user_id_service_ndx_listens_importer"
      DETAIL:  Key (user_id, service)=(10546, spotify) already exists.
      
        File "sqlalchemy/engine/base.py", line 1277, in _execute_context
          cursor, statement, parameters, context
        File "sqlalchemy/engine/default.py", line 608, in do_execute
          cursor.execute(statement, parameters)
      
      IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "user_id_service_ndx_listens_importer"
      DETAIL:  Key (user_id, service)=(10546, 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': 10971, 'user_id': 10546, 'service': 'spotify'}]
      (Ba...
      (13 additional frame(s) were not displayed)
      ...
        File "sqlalchemy/engine/base.py", line 1317, in _execute_context
          e, statement, parameters, cursor, context
        File "sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
          sqlalchemy_exception, with_traceback=exc_info[2], from_=e
        File "sqlalchemy/util/compat.py", line 182, in raise_
          raise exception
        File "sqlalchemy/engine/base.py", line 1277, in _execute_context
          cursor, statement, parameters, context
        File "sqlalchemy/engine/default.py", line 608, in do_execute
          cursor.execute(statement, parameters)
      

            kartik1712 amCap1712
            dev-sentry Dev through Sentry
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package