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.

Sign up for GitHub

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

Jump to bottom

[APP SUBMITTED]: sqlite3.OperationalError: no such table: scene_exceptions #7977

Closed
hergonoway opened this issue Apr 15, 2020 · 9 comments
Closed

[APP SUBMITTED]: sqlite3.OperationalError: no such table: scene_exceptions #7977

hergonoway opened this issue Apr 15, 2020 · 9 comments
Labels
triage Untriaged issue

Comments

@hergonoway
Copy link

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
Operating System: Linux-4.4.59+-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.15
Commit: 918cfe7
Link to Log: https://gist.github.com/e685a2fb84efd29c39d358306ad79009

ERROR

2020-04-15 23:03:52 ERROR    FORCEDSEARCHQUEUE-BACKLOG-376729 :: [918cfe7] 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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators
@triage-new-issues triage-new-issues bot added the triage Untriaged issue label Apr 15, 2020
@reemplazable
Copy link

I have the same issue!
2020-04-17 01:36:20 ERROR SEARCHQUEUE-BACKLOG-293088 :: [8f6b666] DB error: OperationalError('no such table: scene_exceptions') Traceback (most recent call last): sqlite3.OperationalError: no such table: scene_exceptions 2020-04-17 01:36:20 ERROR SEARCHQUEUE-BACKLOG-293088 :: [8f6b666] DB error: no such table: scene_exceptions Traceback (most recent call last): sqlite3.OperationalError: no such table: scene_exceptions

@gennit
Copy link

gennit commented Apr 21, 2020

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
Operating System: Linux-4.15.0-96-generic-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.15
Commit: 94fae84
Link to Log: https://gist.github.com/ee331ef95966c069dcf14077d30794a0

ERROR

2020-04-21 10:10:24 ERROR    FORCEDSEARCHQUEUE-MANUAL-80725 :: [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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@p0psicles
Copy link
Contributor

You can fix it your self. Follow instructions.
#7983 (comment)

@ozhound
Copy link

ozhound commented May 10, 2020

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
Operating System: Linux-3.10.105-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.15
Commit: 94fae84
Link to Log: https://gist.github.com/333aee894d56d031dd8603b532ef1806

ERROR

2020-05-10 22:20:01 ERROR    FORCEDSEARCHQUEUE-BACKLOG-298566 :: [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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@ozhound
Copy link

ozhound commented May 10, 2020

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
Operating System: Linux-3.10.105-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.15
Commit: 94fae84
Link to Log: https://gist.github.com/f290297e9154558fdb533a7250ac53ae

ERROR

2020-05-10 22:20:01 ERROR    FORCEDSEARCHQUEUE-BACKLOG-298566 :: [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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@ozhound
Copy link

ozhound commented May 10, 2020

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
Operating System: Linux-3.10.105-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.15
Commit: 94fae84
Link to Log: No Log available

ERROR

2020-05-06 03:36:00 ERROR    SHOWUPDATER :: [94fae84] Exception generated: no such table: scene_exceptions
Traceback (most recent call last):
  File "/app/medusa/medusa/scheduler.py", line 78, in run
    self.action.run(self.force)
  File "/app/medusa/medusa/show_updater.py", line 39, in run
    refresh_exceptions_cache()
  File "/app/medusa/medusa/scene_exceptions.py", line 55, in refresh_exceptions_cache
    exceptions = main_db_con.select(query, where) or []
  File "/app/medusa/medusa/db.py", line 315, in select
    sql_results = self.action(query, args, fetchall=True)
  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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@ozhound
Copy link

ozhound commented May 10, 2020

INFO

Python Version: 3.8.2 (default, Feb 29 2020, 17:03:31) [GCC 9.2.0]
Operating System: Linux-3.10.105-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.15
Commit: 94fae84
Link to Log: No Log available

ERROR

2020-05-05 22:27:56 ERROR    TORNADO :: [94fae84] Uncaught exception in APIv2: OperationalError('no such table: scene_exceptions')
Request: PATCH /api/v2/series/tvdb296762 (172.17.0.1)
With body:
{"config":{"aliases":[{"title":"Westworld.","season":-1,"custom":true}],"defaultEpisodeStatus":"Wanted","dvdOrder":false,"seasonFolders":true,"anime":false,"scene":false,"sports":false,"paused":false,"location":"/mnt/tvshows/Westworld","airByDate":false,"subtitlesEnabled":false,"release":{"requiredWords":[],"ignoredWords":[],"requiredWordsExclude":false,"ignoredWordsExclude":false},"qualities":{"preferred":[],"allowed":[2,4]},"airdateOffset":0},"language":"en"}
Traceback (most recent call last):
  File "/app/medusa/ext/tornado/web.py", line 1592, in _execute
    result = yield result
  File "/app/medusa/ext/tornado/gen.py", line 1133, in run
    value = future.result()
  File "/app/medusa/ext/tornado/gen.py", line 1141, in run
    yielded = self.gen.throw(*exc_info)
  File "/app/medusa/medusa/server/api/v2/base.py", line 83, in async_call
    content = yield IOLoop.current().run_in_executor(executor, prepared)
  File "/app/medusa/ext/tornado/gen.py", line 1133, in run
    value = future.result()
  File "/usr/lib/python3.8/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/app/medusa/medusa/server/api/v2/series.py", line 152, in patch
    if patch_field and patch_field.patch(series, value):
  File "/app/medusa/medusa/server/api/v2/base.py", line 535, in patch
    setattr(target, self.attr, self.converter(value))
  File "/app/medusa/medusa/tv/base.py", line 57, in __setattr__
    super(TV, self).__setattr__(key, value)
  File "/app/medusa/medusa/tv/series.py", line 610, in aliases
    update_scene_exceptions(self, exceptions)
  File "/app/medusa/medusa/scene_exceptions.py", line 209, in update_scene_exceptions
    main_db_con.action(
  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.OperationalError: no such table: scene_exceptions

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@uncyspam
Copy link

uncyspam commented Nov 3, 2020

INFO

Python Version: 3.8.5 (default, Jul 20 2020, 23:11:29) [GCC 9.3.0]
Operating System: Linux-4.4.59+-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.16
Commit: 918cfe7
Link to Log: https://gist.github.com/5c6e929bbe2bb0de6652ef1b75424c19

ERROR

2020-11-03 20:08:08 ERROR    MAIN :: [918cfe7] 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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

@uncyspam
Copy link

uncyspam commented Nov 3, 2020

INFO

Python Version: 3.8.5 (default, Jul 20 2020, 23:11:29) [GCC 9.3.0]
Operating System: Linux-4.4.59+-x86_64-with
Locale: UTF-8
Branch: master
Database: 44.16
Commit: 918cfe7
Link to Log: https://gist.github.com/4361b94768fa7f1a3d4ee0238c307b7e

ERROR

2020-11-03 20:08:08 ERROR    MAIN :: [918cfe7] 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

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

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

No branches or pull requests
6 participants
@reemplazable @p0psicles @ozhound @hergonoway @uncyspam @gennit