Some extra information:
I also note I run a VACUUM every 50 minutes. Could this result in the
"database schema has changed" message I sometimes see? Possibly one
thread accessing database during VACUUM?
Kind regards,
Ben Clewett.
Ben Clewett wrote:
Dear SQLite,
I am experiencing a problem. Every so often, say one in 100,000
'SELECT' queries, I get this error:
"database schema has changed"
This is false, the schema has not changed.
Can any person offer a reason why this might be, and possibly a solution
to this problem?
I am using SQLite 3.1.6 and storing my database on /dev/shm.
Kind regards,
Ben Clewett.
