On Thu, Jan 14, 2016 at 10:58 AM, sanhua.zh <sanhua.zh at foxmail.com> wrote:

> Through the error code timeline, it shows that much of SQLITE_FULL,
> SQLITE_IOERR, SQLITE_CANTOPEN happened before SQLITE_CORRUPT. Database
> might be in an obscure state while disk is full, then it corrupt in some
> unknown reason.
>
>
> As you said, disk full might corrupt the database. Can you teach me a
> little more in detail ? I haven?t found the relative code in SQLite source
> code.
>

FWIW, the reason for the corruption is not unknown: your app continued to
use sqlite after (apparently) ignoring 3 different error codes (all of them
serious). That misuse is what corrupted it.

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf

Reply via email to