Hi everyone,
I tried to unlock with db.executesql('PRAGMA journal_mode=WAL')
<--------found that in the archives
but it is vicious and "prefers" to stay locked
help !!!!
>import sqlite3
>print sqlite3.sqlite_version
>3.8.2
Ticket ID
127.0.0.1.2015-11-24.17-39-38.f55ca936-a038-42d3-a4c3-ad1667566228
<class 'sqlite3.OperationalError'> database is locked Version web2py™ Version
2.12.3-stable+timestamp.2015.08.19.00.18.03 Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
Traceback (most recent call last):
File "/opt/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
File "/opt/web2py/applications/proxim/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/proxim/controllers/appadmin.py>, line
700, in <module>
File "/opt/web2py/gluon/globals.py", line 412, in <lambda>
self._caller = lambda f: f()
File "/opt/web2py/applications/proxim/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/proxim/controllers/appadmin.py>, line
343, in update
if form.accepts(request.vars, session):
File "/opt/web2py/gluon/sqlhtml.py", line 1561, in accepts
self.table._db(qry).delete()
File "/opt/web2py/gluon/packages/dal/pydal/objects.py", line 2022, in delete
ret = db._adapter.delete(tablename,self.query)
File "/opt/web2py/gluon/packages/dal/pydal/adapters/sqlite.py", line 104, in
delete
counter = super(SQLiteAdapter, self).delete(tablename, query)
File "/opt/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1042, in
delete
self.execute(sql)
File "/opt/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1378, in
execute
return self.log_execute(*a, **b)
File "/opt/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1372, in
log_execute
ret = self.cursor.execute(command, *a[1:], **b)
OperationalError: database is locked
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
