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.

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

Database lock error when updating experiment status #33

Open
radusuciu opened this issue Aug 30, 2018 · 0 comments
Open

Database lock error when updating experiment status #33

radusuciu opened this issue Aug 30, 2018 · 0 comments

Comments

@radusuciu
Copy link
Owner

Task ctesi.core.tasks.convert_task[f17e0507-8f93-4405-a099-ddac4fe54a69] raised unexpected: OperationalError('(sqlite3.OperationalError) database is locked',)
Traceback (most recent call last):
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 724, in _commit_impl
    self.engine.dialect.do_commit(self.connection)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 462, in do_commit
    dbapi_connection.commit()
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/celery/app/trace.py", line 382, in trace_task
    R = retval = fun(*args, **kwargs)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/celery/app/trace.py", line 641, in __protected_call__
    return self.run(*args, **kwargs)
  File "/home/ctesi/ctesi/ctesi/core/tasks.py", line 83, in convert_task
    status_callback=lambda s: update_status(experiment_id, 'converting', meta=s),
  File "/home/ctesi/ctesi/ctesi/core/convert.py", line 22, in convert
    status_callback(status)
  File "/home/ctesi/ctesi/ctesi/core/tasks.py", line 83, in <lambda>
    status_callback=lambda s: update_status(experiment_id, 'converting', meta=s),
  File "/home/ctesi/ctesi/ctesi/api/__init__.py", line 71, in update_experiment_status
    db.session.commit()
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/orm/scoping.py", line 153, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 943, in commit
    self.transaction.commit()
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 471, in commit
    t[1].commit()
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1643, in commit
    self._do_commit()
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1674, in _do_commit
    self.connection._commit_impl()
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 726, in _commit_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
    raise value.with_traceback(tb)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 724, in _commit_impl
    self.engine.dialect.do_commit(self.connection)
  File "/home/ctesi/ctesi/venv/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 462, in do_commit
    dbapi_connection.commit()
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked (Background on this error at: http://sqlalche.me/e/e3q8)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant