-
Notifications
You must be signed in to change notification settings - Fork 481
Database is locked #336
Copy link
Copy link
Closed
Description
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)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels