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
