brpt/importscript.py traceback when anyone has the webpage open

[bradshaw]

So this has been happening off and on for the longest time and I think I have found the true cause of this. So the importscript.py will traceback complaining the DB is locked

Traceback (most recent call last):

File "/usr/lib/python2.3/site-packages/brpt/importscript.py", line 235, in ?

connection._commit()

File "/usr/lib/python2.3/site-packages/django/db/backends/sqlite3/base.py", line 70, in _commit

self.connection.commit()

pysqlite2.dbapi2.OperationalError?: database is locked but what I just proved is that the database is locked due to someone having the website open. So my guess is that the fix is to fix it such that the web opens the DB readonly if that is even possible.

[desai]

This is an sqlite limitation. Switch to mysql and the problem should disappear.