Has anyone else noticed database corruptions or other "strange" things happen to their sql databases?
For example, we have NOT NULL constraints on most columns in our database. Yet, we have seen databases from users, where there were NULLs in those columns! How is that possible? Then, when the rows are updated, sqlite throws a constraint error.
Also, we had at least one case, where a complete table was suddenly missing.
Please see also here: viewtopic.php?f=11&t=6546
Unfortunately, we never had such problems with the databases on our phones or emulators. So, we cannot reproduce it. We only see it, when users report a problem.
We are using "ext:" prefix to put the database on the media partition. Maybe that is the problem? FAT32 filesystem corruption or something like that?
We had these problems at least since 1.4.0.
Thanks for any hints or insights.