SQLite multi process access
- by Nicolas
Hello,
We are using SQLite in a multi processes and multi threaded application.
The SQLite database files are encrypted using the embedded SQLite encryption.
The FAQ states that SQLite should be able to manage multi process accesses using locks mechanism.
We are experiencing a strange problem:
When many threads are accessing the same database file, sometime constrains violations occur, more specifically - a field with a unique constrain is getting duplicate values after calling "insert or replace" statement.
It happens quite often now, that we are using the encryption. Before we started using SQLite encryption we did not notice such a behavior.
Are there any specific known issues with this?
