Hi Richard, yes, I had a look at the link before but I am not doing any of the actions that are mentioned on the cited page. If the file system is broken I do not know but I doubt (but I cannot prove it). Therefore, I am looking for something iOS specific. It only happens when the iPhone/iPad is running out of batteries (perhaps during a write operation?).
BTW: I assume that the rollback journal is in the same folder as the database file, right? Best regards, Hartwig Am 07.08.2011 um 22:25 schrieb Richard Hipp: > On Sun, Aug 7, 2011 at 4:19 PM, skywind mailing lists < > [email protected]> wrote: > >> I am using SQLite 3.6.x and higher for two apps for the iPhone/iPad. I do >> not use the built-in SQLite library because I need Rtree and FTS support. >> Therefore, I compile it by myself with the following preprocessor >> directives: >> >> SQLITE_THREADSAFE=1 SQLITE_ENABLE_RTREE=1 SQLITE_ENABLE_FTS3=1 >> SQLITE_ENABLE_FTS3_PARENTHESIS=1 >> >> A few user have reported that when the iPhone/iPad runs out of batteries >> the SQLite3 database may become corrupted. I have received one database back >> and it is indeed defect and unrecoverable. Does anybody have an idea what is >> going wrong? I tried to reproduce the error by myself but I did not have any >> luck so far. >> For information: only the main thread is writing to the database. There is >> no other thread having access to the database and there is also no read >> operation from the main thread. The write operation is not within an >> explicit transaction. >> >> Any ideas are appreciated! >> > > http://www.sqlite.org/howtocorrupt.html > > >> >> Regards, >> >> Hartwig >> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
