SQLite Database is locked

[dmichel1]

Currently there is a race condition that causes the sqlite database to be locked. Reloading apache2 seems to resolve this issue until it can be further investigated.

[Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] mod_wsgi (pid=20063): Target WSGI script '/opt/graphite/conf/graphite.wsgi' cannot be loaded as Python module. [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] mod_wsgi (pid=20063): Exception occurred processing WSGI script '/opt/graphite/conf/graphite.wsgi'. [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] Traceback (most recent call last): [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/opt/graphite/conf/graphite.wsgi", line 16, in [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] import graphite.metrics.search [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/opt/graphite/webapp/graphite/metrics/search.py", line 6, in [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] from graphite.storage import is_pattern, match_entries [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/opt/graphite/webapp/graphite/storage.py", line 7, in [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] from graphite.remote_storage import RemoteStore [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/opt/graphite/webapp/graphite/remote_storage.py", line 8, in [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] from graphite.util import unpickle [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/opt/graphite/webapp/graphite/util.py", line 81, in [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] defaultProfile.save() [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 546, in save [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] force_update=force_update, update_fields=update_fields) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 650, in save_base [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 215, in _insert [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] return insert_query(self.model, objs, fields, *_kwargs) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 1675, in insert_query [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] return query.get_compiler(using=using).execute_sql(return_id) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 943, in execute_sql [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] cursor.execute(sql, params) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/backends/sqlite3/base.py", line 366, in execute [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] six.reraise(utils.DatabaseError, utils.DatabaseError(_tuple(e.args)), sys.exc_info()[2]) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] File "/usr/local/lib/python2.7/dist-packages/django/db/backends/sqlite3/base.py", line 362, in execute [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] return Database.Cursor.execute(self, query, params) [Tue Apr 01 00:34:38 2014] [error] [client 192.168.20.202] DatabaseError: database is locked