database locked SQLITE

289 views
Skip to first unread message

dbb

unread,
Jun 12, 2010, 10:42:00 PM6/12/10
to web2py-users
Help resolving this issue, the database keeps locking, the trace is :

Traceback (most recent call last):
File "C:\web2pyy\gluon\restricted.py", line 173, in restricted
exec ccode in environment
File "C:/web2pyy/applications/ET/models/db.py", line 58, in <module>
db.vho.import_from_csv_file(open('C:/data/
xxx.csv','r'),migrate=migrate)
File "C:\web2pyy\gluon\sql.py", line 1968, in import_from_csv_file
new_id = self.insert(**dict(items))
File "C:\web2pyy\gluon\sql.py", line 1879, in insert
self._db._execute(query)
File "C:\web2pyy\gluon\sql.py", line 895, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: database is locke

mdipierro

unread,
Jun 14, 2010, 7:56:09 AM6/14/10
to web2py-users
please tell us more about the conditions that cause it.
If you use the shell (or background process) at the same time as the
web app make sure you unlock the db with periodic db.commit()

Massimo
Reply all
Reply to author
Forward
0 new messages