On 10 Nov 2018, at 12:52pm, Paresh Sukhiya <[email protected]> wrote:
> 9. Whenever the app goes in background we Shut Down the SQLite connection and > on Activation we Initialize the SQLite again in Serialized mode. If the problem really is with SQLite, and not some other thing which is opening files, then my guess is that your detection of backgrounding is faulty, or that your app is being choked off before it can close the database. What hardware are you programming for, and what library are you using to make SQLite calls ? Do you test the code returned by sqlite_close() to make sure it is returning SQLITE_OK and not an error ? As a temporary test, after detecting being moved to background, and closing the database, deinitialise SQLite by calling sqlite3_shutdown() or whatever equivalent your library allows. It should be impossible for SQLite to hold a file open after this call, even if it wasn't able to close all databases without errors. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
