Medusa icon indicating copy to clipboard operation
Medusa copied to clipboard

[APP SUBMITTED]: sqlite3.IntegrityError: UNIQUE constraint failed: imdb_info.imdb_info_id

Open jamesjoyce2208 opened this issue 1 year ago • 0 comments

INFO

Python Version: 3.11.6 (main, Oct 13 2023, 15:52:55) [GCC 13.1.1 20230722] Operating System: Linux-5.15.0-73-generic-x86_64-with Locale: UTF-8 Branch: master Database: 44.19 Commit: pymedusa/Medusa@ Link to Log: No Log available

ERROR

2024-01-22 04:53:11 ERROR    SHOWQUEUE-SEASON-UPDATE :: [] Traceback (most recent call last):
  File "/app/medusa/medusa/queues/show_queue.py", line 1096, in run
    self.show.save_to_db()
  File "/app/medusa/medusa/tv/series.py", line 2327, in save_to_db
    main_db_con.upsert('imdb_info', new_value_dict, control_value_dict)
  File "/app/medusa/medusa/db.py", line 360, in upsert
    self.action(query, list(itervalues(valueDict)) + list(itervalues(keyDict)))
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/medusa/medusa/db.py", line 115, in _execute
    sql_results = cursor.execute(query, args)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.IntegrityError: UNIQUE constraint failed: imdb_info.imdb_info_id
Traceback (most recent call last):
  File "/app/medusa/medusa/queues/show_queue.py", line 1096, in run
    self.show.save_to_db()
  File "/app/medusa/medusa/tv/series.py", line 2327, in save_to_db
    main_db_con.upsert('imdb_info', new_value_dict, control_value_dict)
  File "/app/medusa/medusa/db.py", line 360, in upsert
    self.action(query, list(itervalues(valueDict)) + list(itervalues(keyDict)))
  File "/app/medusa/medusa/db.py", line 285, in action
    sql_results = self._execute(query, args, fetchall=fetchall, fetchone=fetchone)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/medusa/medusa/db.py", line 115, in _execute
    sql_results = cursor.execute(query, args)
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.IntegrityError: UNIQUE constraint failed: imdb_info.imdb_info_id

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

jamesjoyce2208 avatar Jan 22 '24 11:01 jamesjoyce2208