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

Gracefully handle database locks #93

Open
adityahase opened this issue Mar 23, 2024 · 0 comments
Open

Gracefully handle database locks #93

adityahase opened this issue Mar 23, 2024 · 0 comments
Assignees

Comments

@adityahase
Copy link
Member

09:02:01 [Job e1dbd1e6-1e48-4d19-a8e5-26bb50102e2b]: exception raised while executing (backup_job)
Traceback (most recent call last):
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 3057, in execute_sql
    cursor.execute(sql, params or ())
sqlite3.OperationalError: database is locked

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/frappe/agent/env/lib/python3.8/site-packages/rq/worker.py", line 1359, in perform_job
    rv = job.perform()
  File "/home/frappe/agent/env/lib/python3.8/site-packages/rq/job.py", line 1178, in perform
    self._result = self._execute()
  File "/home/frappe/agent/env/lib/python3.8/site-packages/rq/job.py", line 1215, in _execute
    result = self.func(*self.args, **self.kwargs)
  File "/home/frappe/agent/repo/agent/job.py", line 133, in wrapper
    raise e
  File "/home/frappe/agent/repo/agent/job.py", line 125, in wrapper
    result = wrapped(*args, **kwargs)
  File "/home/frappe/agent/repo/agent/site.py", line 654, in backup_job
    backup_files = self.backup(with_files)
  File "/home/frappe/agent/repo/agent/job.py", line 109, in wrapper
    instance.step_record.success(result)
  File "/home/frappe/agent/repo/agent/job.py", line 44, in success
    self.end()
  File "/home/frappe/agent/repo/agent/job.py", line 37, in save
    instance.model.save()
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 6431, in save
    rows = self.update(**field_dict).where(self._pk_expr()).execute()
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 1845, in inner
    return method(self, database, *args, **kwargs)
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 1916, in execute
    return self._execute(database)
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 2400, in _execute
    cursor = database.execute(self)
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 3070, in execute
    return self.execute_sql(sql, params, commit=commit)
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 3064, in execute_sql
    self.commit()
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 2831, in __exit__
    reraise(new_type, new_type(exc_value, *exc_args), traceback)
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 183, in reraise
    raise value.with_traceback(tb)
  File "/home/frappe/agent/env/lib/python3.8/site-packages/peewee.py", line 3057, in execute_sql
    cursor.execute(sql, params or ())
peewee.OperationalError: database is locked
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

2 participants