SQLite Forum

Select query returning: no such table error
Login
We've seen this sort of thing before.  It often turns out that something is stomping on the memory SQLite uses to keep track of data or file handles, causing it to look in a corrupted list of tables, or in a non-existent file.  I'm not saying that this is the cause in your case, just that it's something to look for.

Do you have anything else accessing the same file ?  It could be the SQLite API being called from another thread, process or app.  But it could also be an automatic backup routine which locks the file while it backs it up.  And in a non-Linux context I would also be suspicious of a virus-checker.