Hello,
I have multiple processes accessing the same database file (sqlite 3.8.7.4
on linux). The DB contains only one table and every process execute
prepared statements (sqlite3_prepare_v2) like the following one:
INSERT INTO table (process,type,status,occurence,data)
VALUES('test',2,2,1472800896400,'{"key1":"value","key2":"value"}')
or
SELECT (COUNT(table.id)-1000) AS row_limit FROM table
Everything works perfectly but, on some rare occasion, nothing is inserted
in the database but no error is returned, i.e.:
sqlite3_step(prepared_statement)
returns either SQLITE_OK, SQLITE_ROW, SQLITE_DONE. However if I look into
the DB, nothing is inserted. Once it starts failing, nothing is inserted
anymore. The only way to make the database work again is to delete the file
and start with a new one.
This behavior is really hard to reproduce. Do you have any clue on what
could cause this kind of behavior or where to look to start debugging this?
Best regards,
Simon
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
