Re: [sqlite] database schema has changed

[Tito Ciuro]

Hi Ben,

Check this post and see if it helps: http://www.mail-archive.com/ 
sqlite-users@sqlite.org/msg04887.html

Regards,

-- Tito

On 01/06/2005, at 12:16, Ben Clewett wrote:

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.




______________________________________

Tito Ciuro
http://www.webbo.com