Quote:
Originally Posted by kovidgoyal
Sigh.
That cannot happen if a query fails because of a property of sqlite known as ACID, which means that no matter what failure occurs during a query, the database on disk cannot be corrupted, unless a filesystem operation fails.
|
I do not think that the query create corrupt database, but since that one query was executed and the second one not, it is possible that the database get in a state that it will never been repaired by the device.
Anyway, next week I will have a try to debug it since I have the problem with all my devices and quite often. IT is certainly the best chance to find what is going wrong.
If I'm able to find something, you will see a get-merge request with a patch.