Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Db error from the 0.3.15 #8028

Closed
thib3113 opened this issue Apr 26, 2020 · 3 comments
Closed

Db error from the 0.3.15 #8028

thib3113 opened this issue Apr 26, 2020 · 3 comments
Labels
triage Untriaged issue

Comments

@thib3113
Copy link

Describe the bug
Lot of Times I get errors talking about a missing table :

MAIN :: [94fae84] Query: '
        SELECT indexer, series_id, title, season, custom
        FROM scene_exceptions
    '. Arguments: '[]'
2020-04-26 23:47:44 ERROR    MAIN :: [94fae84] DB error: OperationalError('no such table: scene_exceptions')
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 113, in _execute
   sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions
2020-04-26 23:47:44 ERROR    MAIN :: [94fae84] DB error: no such table: scene_exceptions
Traceback (most recent call last):
  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 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

To Reproduce
Upgrade from 0.3.14 to 0.3.15 ?

Expected behavior
No crash ?

Medusa (please complete the following information):

  • OS: docker image
    Branch: master
    Commit: 94fae84
    Version: 0.3.15
    Database: 44.15
    Python Version: | 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
    SSL Version: | OpenSSL 1.1.1d 10 Sep 2019
    OS: | Linux-4.15.0-96-generic-x86_64-with
    Locale: | en_US.UTF-8

Debug logs (at least 50 lines):

2020-04-26 23:47:44 ERROR    MAIN :: [94fae84] DB error: OperationalError('no such table: scene_exceptions')
Traceback (most recent call last):
  File "/app/medusa/medusa/db.py", line 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions
2020-04-26 23:47:44 ERROR    MAIN :: [94fae84] DB error: no such table: scene_exceptions
Traceback (most recent call last):
  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 113, in _execute
    sql_results = cursor.execute(query)
sqlite3.OperationalError: no such table: scene_exceptions

Additional context
Any way to update the database manually ?

@triage-new-issues triage-new-issues bot added the triage Untriaged issue label Apr 26, 2020
@p0psicles
Copy link
Contributor

Search the closed issues. Solution provided many times

@thib3113
Copy link
Author

doesn't found it the first time I search .

So I use this comment , to update manually the minor db version in the db (python not available for me)

@p0psicles
Copy link
Contributor

Yes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
triage Untriaged issue
Projects
None yet
Development

No branches or pull requests

2 participants