database disk image is malformed when SELECT instruction

(1) By Bob (765226177) on 2022-03-24 07:51:44 [source]

I have two processes, one that writes to SQLite and one that queries in read-only mode. When the amount of data to write becomes larger, to query occurs "database disk image is malformed" or "File opened that is not a database file". This query error occurs in a JDBC ResultSet. However, no errors occur when I query from the command line. The "PRAGMA integrity_check" is OK. I don't know why.

(2) By Gunter Hick (gunter_hick) on 2022-03-24 11:46:12 in reply to 1 [link] [source]

You are omitting so much context that nobody can offer a better explanation than a simple "you are obviously doing something wrong".

Which release of SQLite?
Which operating system?
Which programming language/wrapper?
What is the actual calling sequence?
What actual SQL?
What do you mean by "read-only mode"?

(3) By Warren Young (wyoung) on 2022-03-24 18:22:51 in reply to 2 [link] [source]

"JDBC ResultSet" gives you the answer to one of your questions. That then implies something running on one of the Java runtimes. Unfortunately, that spans Kotlin on Dalvik to Scala on some big enterpri$$$e application server and beyond.

I think what would help a lot more than the answer to those questions would be a repeatable test case.

And I further expect that the effort put into producing such a thing will fail, leading to enlightenment that obviates the purpose behind the thread. :)