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 the following configuration 1. I have set SQLite Open Flags to ReadWrite ,Create ,SharedCache ,FullMutex ,ProtectionComplete. 2. PRAGMA journal_mode = WAL 3. PRAGMA page_size = 4096 4. PRAGMA default_cache_size = 1024 5. PRAGMA cache_size = 1024 6. PRAGMA synchronous = 1 7. PRAGMA locking_mode = EXCLUSIVE 8. PRAGMA sqlite3_temp_directory = tempPath (I have set a path) 9. Whenever the app goes in background we Shut Down the SQLite connection and on Activation we Initialize the SQLite again in Serialized mode. 10. We use a single connection in the whole application which gets closed when app goes in background. Now the issue is after using the app for some time we get the issue as Connect Failure (too many open files) When I found the list of files open I found that out of 256 file descriptors around 210-220 file descriptors were used by a file named SQliteDB.db3-shm And one was SQLiteDB.db3-wal So my question is : 1. How this can be solved or if any alternative or If have done any mistake while setting the configuration mode? 2. How to clear those temporary db3-shm files? Thanks for your help! Sincerely, Paresh Sukhiya. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
