Re: [sqlite] Connect Failure: too many open files

2018-11-10 Thread Jens Alfke
You must not be closing the SQLite connection when the app goes into the background. Then the file descriptors stay open, and new ones are opened (on the same file) when you reopen when the app activates. —Jens ___ sqlite-users mailing list sqlite-user

Re: [sqlite] Connect Failure: too many open files

2018-11-10 Thread Simon Slavin
On 10 Nov 2018, at 1:57pm, Simon Slavin wrote: > Do you test the code returned by sqlite_close() to make sure it is returning > SQLITE_OK and not an error ? Sorry, I forgot a possibility. If your application has a statement which is not terminated, it cannot close the database. For example,

Re: [sqlite] Connect Failure: too many open files

2018-11-10 Thread Simon Slavin
On 10 Nov 2018, at 12:52pm, Paresh Sukhiya 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 g

[sqlite] Connect Failure: too many open files

2018-11-10 Thread Paresh Sukhiya
Dear SQLite people, Please help me with the issue occurring while using SQLite in sqlite3. Connect Failure: (Too many open files) I’ll let you know the whole scenario and if you could then please help. We use sqlite3 in a mobile apps. I have created a SQLite connection with Serialized mode with