On Tue, Jan 17, 2012 at 11:51 AM, Bill McCormick <wpmccorm...@gmail.com>wrote:

> What happens if my application fails to call sqlite3_close() before it
> exits? Does it leave the db in some unknown state or open to corruption?
>
> If I have a daemon type program, will I need to catch signals that try to
> close/kill the program and call sqlite3_close() before exiting?
>

Failure to call sqlite3_close() results in memory and file-descriptor leaks
if your process keeps running.  But as those resources are cleaned up
automatically when the process exits, failure to call sqlite3_close() prior
to exit is harmless.

If you are using WAL mode, failure to call sqlite3_close() might leave -wal
and -shm lingering on your disk.  But the next process to open the database
file will clean them up automatically, so no harm done.



>
> Thanks!!
> ______________________________**_________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to