Skip to content

Database is locked #336

@mchccc

Description

@mchccc

I'm seeing a lot of those kind of errors, lately (i.e. last 7 days): my flexget is running daemonized inside a NAS run by fun_plug, and tasks are having a hard time completing for this reason.
Any help I can provide?

This is the first error log from today, after some 15 hours of quiet running:

2014-09-10 03:25 ERROR    task          hourly_ezrss    BUG: Unhandled error in plugin configure_series: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (OperationalError) database is locked u'UPDATE thetvdb_favorites SET updated=? WHERE thetvdb_favorites.id = ?' ('2014-09-10 03:25:32.487063', 1)
Traceback (most recent call last):
  File "/ffp/lib/python2.7/site-packages/flexget/task.py", line 440, in __run_plugin
    return method(*args, **kwargs)
  File "/ffp/lib/python2.7/site-packages/flexget/event.py", line 22, in __call__
    return self.func(*args, **kwargs)
  File "/mnt/HD/HD_a2/ffp/lib/python2.7/site-packages/flexget/plugins/plugin_configure_series.py", line 66, in on_task_start
    result = method(task, input_config)
  File "/ffp/lib/python2.7/site-packages/flexget/event.py", line 22, in __call__
    return self.func(*args, **kwargs)
  File "/ffp/lib/python2.7/site-packages/flexget/utils/cached_input.py", line 136, in wrapped_func
    response = func(*args, **kwargs)
  File "/ffp/lib/python2.7/site-packages/flexget/plugin.py", line 129, in wrapped_func
    return func(*args, **kwargs)
  File "/ffp/lib/python2.7/site-packages/flexget/utils/database.py", line 25, in wrapper
    result = func(*args, **kwargs)
  File "/mnt/HD/HD_a2/ffp/lib/python2.7/site-packages/flexget/plugins/input/thetvdb_favorites.py", line 113, in on_task_input
    session.merge(user_favorites)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1604, in merge
    self._autoflush()
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1208, in _autoflush
    util.raise_from_cause(e)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1198, in _autoflush
    self.flush()
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1919, in flush
    self._flush(objects)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2037, in _flush
    transaction.rollback(_capture_exception=True)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2001, in _flush
    flush_context.execute()
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
    rec.execute(self)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
    uow
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 60, in save_obj
    mapper, table, update)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 518, in _emit_update_statements
    execute(statement, params)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
    return meth(self, multiparams, params)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/ffp/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (OperationalError) database is locked u'UPDATE thetvdb_favorites SET updated=? WHERE thetvdb_favorites.id = ?' ('2014-09-10 03:25:32.487063', 1)
2014-09-10 03:25 WARNING  task          hourly_ezrss    Aborting task (plugin: configure_series)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions