On 10/5/15, Andrew Miles <andy at blandsrow.com> wrote: > 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? >
Activate the error and warning log. https://www.sqlite.org/errlog.html -- D. Richard Hipp drh at sqlite.org
