On 29 Jan 2012, at 4:14pm, Shahar Weinstein wrote: > no, its an ordinary website. > the situation is simple. I'm trying to save into the database some data > taken from a web form with one simple, > update query. the database is being opened and then immidietly being closed.
So you do execute sqlite3_close() on it, and you do check the value being returned to make sure it doesn't indicate an error ? > as I mentioned before. the problem appears. and than stays for > seconds,minutes or an hour, and than disappears again. On the computer that the database file is stored on, run an application which shows you what processes have which files open. On a Mac it's 'lsof'. On Windows 'openfiles' will show you only files opened by network users. You need something which shows files opened by local processes too. Maybe this will do it: http://www.nirsoft.net/utils/process_activity_view.html > is there a way to influence the sqlite engine to produce a log file in > order to understand the situation better? I bet that the process which has the file open is not your database program, it's a backup app, or a virus-checker, or something like that. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
