Hi I have a strange issue with a piece of C code using sqlite3. The code runs for days and then stops on an SQL insert into db with the error code SQLITE_CANTOPEN.
Further info: 1) The program is a status monitoring app - it writes values into the SQL db once every 60 seconds. Average duration is about 2 days before dying so roughly 3000 successful writes before failure. 2) The SQL db is kept open for the entire time i.e. I don't open/close on every transaction. 3) There is another process accessing the same db but read only 4) I tried waiting 5 secs on the first CANTOPEN and trying again in case the other process had locked the db but same message. Even closing the db and reopening won't free the error. The only method is to stop the program and restart, then it works again every time. 5) I ran lsof on the db, only one process (this one) had the file open 6) The extended error code reported is 14 i.e. no further information 7) Disk has 5GB free Any advice on how to debug further? Andy
