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 is locked #72

Open
diogouchoas opened this issue Aug 25, 2016 · 1 comment
Open

Database is locked #72

diogouchoas opened this issue Aug 25, 2016 · 1 comment

Comments

@diogouchoas
Copy link

diogouchoas commented Aug 25, 2016

My livestatus module suddenly began to crash from time to time. The error messages that precede this problema are the following. Already tried unlocking the sqlite database, but the problem seems to keep happening anyway.

[1472150360] ERROR: [broker-master] [livestatus] Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/Shinken-2.4.3-py2.7.egg/shinken/basemodule.py", line 164, in start_module
    self._main()
  File "/usr/local/lib/python2.7/dist-packages/Shinken-2.4.3-py2.7.egg/shinken/basemodule.py", line 296, in _main
    self.main()
  File "/var/lib/shinken/modules/livestatus/module.py", line 242, in main
    self.do_main()
  File "/var/lib/shinken/modules/livestatus/module.py", line 281, in do_main
    self.main_thread_run()
  File "/var/lib/shinken/modules/livestatus/module.py", line 406, in main_thread_run
    self.db.commit_and_rotate_log_db()
  File "/var/lib/shinken/modules/logstore-sqlite/module.py", line 230, in commit_and_rotate_log_db
    self.commit()
  File "/var/lib/shinken/modules/logstore-sqlite/module.py", line 472, in commit
    self.dbconn.commit()
OperationalError: database is locked
@dgilm
Copy link

dgilm commented Jul 24, 2018

Try with this PR:

shinken-monitoring/mod-logstore-sqlite#15

setting the journal_mode of sqlite to wal

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