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