greetings.
I have the same problem.
but sometimes I throw a cache miss.
and I do not use cache cleared ... I have not configured ..
It had implemented db.executesql ('PRAGMA journal_mode = WAL')
error:
default.py OperationalError: database is locked + details
10_base_config.py OperationalError: database is locked + details
planilla.py ValueError: invalid literal for int() with base
10: 'cache' + details
El miércoles, 14 de noviembre de 2012 00:41:45 UTC-4:30, Vasile Ermicioi
escribió:
>
> first be sure you have sqlite >=3.7:
> 1) open python
> 2)>import sqlite3
> 3)>print sqlite3.sqlite_version
>
> if you don't have sqlite >=3.7 you can't use wal
>
> put the code in models/db.py after database connection
>
> db = DAL('sqlite://storage.sqlite')
> db.executesql('PRAGMA journal_mode=WAL')
>
> but you can remove it after one run
>
> read more here http://www.sqlite.org/draft/wal.html
>
>
>
--
