DB Locked Error

[warwickprice]

The problem

I'm running the docker under unRaid using the latest version of the ghcr.io/taxel/plextraktsync:latest repo.

I issue the python3 -m plextraktsync command and at random points I get the error:

sqlite3.OperationalError: database is locked

I've stopped all scans on Plex, I've made sure that Plex isn't playing anything but still I get this error.... sometimes after 10 seconds... sometimes after 4 minutes.

Error trace

Processing Movies  36% ━━━━━━━━━━━━━━━━━━━╸━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2,374/6,683  [ 0:02:26 < 0:05:34 , 13 it/s ]
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/runpy.py", line 196, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "/usr/local/lib/python3.10/runpy.py", line 86, in _run_code
    exec(code, run_globals)
  File "/app/plextraktsync/__main__.py", line 16, in <module>
    cli()
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1128, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1053, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1637, in invoke
    super().invoke(ctx)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1395, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 754, in invoke
    return __callback(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/app/plextraktsync/cli.py", line 23, in cli
    sync()
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1128, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1053, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1395, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.10/site-packages/click/core.py", line 754, in invoke
    return __callback(*args, **kwargs)
  File "/app/plextraktsync/commands/sync.py", line 110, in sync
    runner.sync(walker=w, dry_run=config.dry_run)
  File "/app/plextraktsync/sync.py", line 71, in sync
    for movie in walker.find_movies():
  File "/app/plextraktsync/walker.py", line 225, in find_movies
    movie = self.mf.resolve_any(plex)
  File "/app/plextraktsync/media.py", line 133, in resolve_any
    m = self.resolve_guid(guid, tm)
  File "/app/plextraktsync/media.py", line 155, in resolve_guid
    tm = self.trakt.find_by_guid(guid)
  File "/app/plextraktsync/trakt_api.py", line 222, in find_by_guid
    return self.search_by_id(guid.id, id_type=guid.provider, media_type=guid.type)
  File "/app/plextraktsync/decorators/rate_limit.py", line 23, in wrapper
    return fn(*args, **kwargs)
  File "/app/plextraktsync/trakt_api.py", line 238, in search_by_id
    search = trakt.sync.search_by_id(media_id, id_type=id_type, media_type=media_type)
  File "/usr/local/lib/python3.10/site-packages/trakt/core.py", line 552, in inner
    json_data = self._handle_request('get', url)
  File "/usr/local/lib/python3.10/site-packages/trakt/core.py", line 522, in _handle_request
    response = session.request(method, url, headers=HEADERS,
  File "/usr/local/lib/python3.10/site-packages/requests_cache/session.py", line 116, in request
    return super().request(
  File "/usr/local/lib/python3.10/site-packages/requests/sessions.py", line 542, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.10/site-packages/requests_cache/session.py", line 142, in send
    cached_response = self.cache.get_response(cache_key)
  File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/base.py", line 74, in get_response
    if key not in self.responses:
  File "/usr/local/lib/python3.10/_collections_abc.py", line 822, in __contains__
    self[key]
  File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 271, in __getitem__
    return self.serializer.loads(super().__getitem__(key))
  File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 213, in __getitem__
    row = con.execute(f'SELECT value FROM {self.table_name} WHERE key=?', (key,)).fetchone()
sqlite3.OperationalError: database is locked

Expected behavior

Should continue processing libraries.

Steps to reproduce the behavior

Happens at various points of running the sync.

Inspect of problematic items

No response

Workarounds

No response

Install method

docker-compose

Version

ghcr.io/taxel/plextraktsync:latest

Python Version

unRaid 6.9.2

Operating System and Version

unRaid 6.9.2

[glensc]

  File "/usr/local/lib/python3.10/site-packages/requests_cache/backends/sqlite.py", line 213, in __getitem__
    row = con.execute(f'SELECT value FROM {self.table_name} WHERE key=?', (key,)).fetchone()
sqlite3.OperationalError: database is locked

This error could only mean that you have multiple instances of PlexTraktSync running. Check your process table.

Having anything playing on Plex itself is totally unrelated.