search

pymedusa / Medusa

Automatic Video Library Manager for TV Shows. It watches for new episodes of your favorite shows, and when they are posted it does its magic.
https://pymedusa.com
GNU General Public License v3.0
1.78k stars 277 forks source link

[APP SUBMITTED]: sqlite3.OperationalError: unable to open database file #11562

Open sendas opened 10 months ago

sendas commented 10 months ago

INFO

Python Version: 3.8.16 (default, May 13 2023, 17:18:59) [GCC 8.5.0] Operating System: Linux-3.10.108-armv7l-with-glibc2.4 Locale: UTF-8 Branch: master Database: 44.19 Commit: pymedusa/Medusa@b8bec48d5036a4d9084d762e2d2ffca9c711f2f3 Link to Log: https://gist.github.com/sendas/5255adf369816613c3b78215274caf92

ERROR

2023-11-13 04:14:53 ERROR    SHOWUPDATER :: [b8bec48] Problem running show_updater, Indexer IMDb seems to be having issues while trying to get updates for show The Calling. Cause: OperationalError('unable to open database file')
Traceback (most recent call last):
  File "/volume1/@appstore/medusa/src/medusa/schedulers/show_updater.py", line 132, in run
    updated_seasons = indexer_api.get_last_updated_seasons(
  File "/volume1/@appstore/medusa/src/medusa/indexers/imdb/api.py", line 772, in get_last_updated_seasons
    results = self.imdb_api.get_title_episodes(ImdbIdentifier(series_id).imdb_id)
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 215, in get_title_episodes
    return self._get_resource('/title/{0}/episodes'.format(imdb_id))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 303, in _get_resource
    return self._get(url=url)['resource']
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 311, in _get
    headers.update(self.get_auth_headers(full_url))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 114, in get_auth_headers
    creds, soon_expires = self._creds_soon_expiring()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 99, in _creds_soon_expiring
    creds = self._get_creds()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 86, in _get_creds
    with diskcache.Cache(directory=self._cachedir) as cache:
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 459, in __init__
    sql = self._sql_retry
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 655, in _sql_retry
    sql = self._sql
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 651, in _sql
    return self._con.execute
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 626, in _con
    con = self._local.con = sqlite3.connect(
sqlite3.OperationalError: unable to open database file

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

sendas commented 10 months ago

INFO

Python Version: 3.8.16 (default, May 13 2023, 17:18:59) [GCC 8.5.0] Operating System: Linux-3.10.108-armv7l-with-glibc2.4 Locale: UTF-8 Branch: master Database: 44.19 Commit: pymedusa/Medusa@b8bec48d5036a4d9084d762e2d2ffca9c711f2f3 Link to Log: https://gist.github.com/sendas/dd33dbb8bb2502830bcdbb4250ac80a0

ERROR

2023-12-07 04:14:59 ERROR    SHOWUPDATER :: [b8bec48] Problem running show_updater, Indexer IMDb seems to be having issues while trying to get updates for show The Walking Dead: Dead City. Cause: OperationalError('unable to open database file')
Traceback (most recent call last):
  File "/volume1/@appstore/medusa/src/medusa/schedulers/show_updater.py", line 132, in run
    updated_seasons = indexer_api.get_last_updated_seasons(
  File "/volume1/@appstore/medusa/src/medusa/indexers/imdb/api.py", line 772, in get_last_updated_seasons
    results = self.imdb_api.get_title_episodes(ImdbIdentifier(series_id).imdb_id)
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 215, in get_title_episodes
    return self._get_resource('/title/{0}/episodes'.format(imdb_id))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 303, in _get_resource
    return self._get(url=url)['resource']
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 311, in _get
    headers.update(self.get_auth_headers(full_url))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 114, in get_auth_headers
    creds, soon_expires = self._creds_soon_expiring()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 99, in _creds_soon_expiring
    creds = self._get_creds()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 86, in _get_creds
    with diskcache.Cache(directory=self._cachedir) as cache:
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 459, in __init__
    sql = self._sql_retry
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 655, in _sql_retry
    sql = self._sql
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 651, in _sql
    return self._con.execute
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 626, in _con
    con = self._local.con = sqlite3.connect(
sqlite3.OperationalError: unable to open database file

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

sendas commented 10 months ago

INFO

Python Version: 3.8.16 (default, May 13 2023, 17:18:59) [GCC 8.5.0] Operating System: Linux-3.10.108-armv7l-with-glibc2.4 Locale: UTF-8 Branch: master Database: 44.19 Commit: pymedusa/Medusa@b8bec48d5036a4d9084d762e2d2ffca9c711f2f3 Link to Log: https://gist.github.com/sendas/49c94e94f1070d7b0a00dbd7fa2fc92a

ERROR

2023-12-07 04:14:58 ERROR    SHOWUPDATER :: [b8bec48] Problem running show_updater, Indexer IMDb seems to be having issues while trying to get updates for show The Calling. Cause: OperationalError('unable to open database file')
Traceback (most recent call last):
  File "/volume1/@appstore/medusa/src/medusa/schedulers/show_updater.py", line 132, in run
    updated_seasons = indexer_api.get_last_updated_seasons(
  File "/volume1/@appstore/medusa/src/medusa/indexers/imdb/api.py", line 772, in get_last_updated_seasons
    results = self.imdb_api.get_title_episodes(ImdbIdentifier(series_id).imdb_id)
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 215, in get_title_episodes
    return self._get_resource('/title/{0}/episodes'.format(imdb_id))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 303, in _get_resource
    return self._get(url=url)['resource']
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 311, in _get
    headers.update(self.get_auth_headers(full_url))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 114, in get_auth_headers
    creds, soon_expires = self._creds_soon_expiring()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 99, in _creds_soon_expiring
    creds = self._get_creds()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 86, in _get_creds
    with diskcache.Cache(directory=self._cachedir) as cache:
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 459, in __init__
    sql = self._sql_retry
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 655, in _sql_retry
    sql = self._sql
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 651, in _sql
    return self._con.execute
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 626, in _con
    con = self._local.con = sqlite3.connect(
sqlite3.OperationalError: unable to open database file

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

sendas commented 10 months ago

INFO

Python Version: 3.8.16 (default, May 13 2023, 17:18:59) [GCC 8.5.0] Operating System: Linux-3.10.108-armv7l-with-glibc2.4 Locale: UTF-8 Branch: master Database: 44.19 Commit: pymedusa/Medusa@b8bec48d5036a4d9084d762e2d2ffca9c711f2f3 Link to Log: https://gist.github.com/sendas/cd61d5f2d25ec559d6d7583db6148865

ERROR

2023-12-07 04:14:57 ERROR    SHOWUPDATER :: [b8bec48] Problem running show_updater, Indexer IMDb seems to be having issues while trying to get updates for show RuPaul's Secret Celebrity Drag Race. Cause: OperationalError('unable to open database file')
Traceback (most recent call last):
  File "/volume1/@appstore/medusa/src/medusa/schedulers/show_updater.py", line 132, in run
    updated_seasons = indexer_api.get_last_updated_seasons(
  File "/volume1/@appstore/medusa/src/medusa/indexers/imdb/api.py", line 772, in get_last_updated_seasons
    results = self.imdb_api.get_title_episodes(ImdbIdentifier(series_id).imdb_id)
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 215, in get_title_episodes
    return self._get_resource('/title/{0}/episodes'.format(imdb_id))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 303, in _get_resource
    return self._get(url=url)['resource']
  File "/volume1/@appstore/medusa/src/ext/imdbpie/imdbpie.py", line 311, in _get
    headers.update(self.get_auth_headers(full_url))
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 114, in get_auth_headers
    creds, soon_expires = self._creds_soon_expiring()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 99, in _creds_soon_expiring
    creds = self._get_creds()
  File "/volume1/@appstore/medusa/src/ext/imdbpie/auth.py", line 86, in _get_creds
    with diskcache.Cache(directory=self._cachedir) as cache:
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 459, in __init__
    sql = self._sql_retry
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 655, in _sql_retry
    sql = self._sql
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 651, in _sql
    return self._con.execute
  File "/volume1/@appstore/medusa/src/ext/diskcache/core.py", line 626, in _con
    con = self._local.con = sqlite3.connect(
sqlite3.OperationalError: unable to open database file

STAFF NOTIFIED: @pymedusa/support @pymedusa/moderators

nydave69 commented 1 month ago

Is a backup running at that time and has the DB file locked?