Spontaneous SQLite db rollback

Cheeger 1 Reputation point
2021-03-16T21:35:31.667+00:00

My Xamarin App stores data in several SQLite databases.
Data is added to them during the day, I can reload applications many times, sometimes changes persist even after device reboot.
But at some point all new changes disappear and LastWriteTime of all databases becomes 19.01.1970 19:41:44.
Because of what it might be?

I testing on android 9, journal_mode of all databases is set to delete, they are stored in the files folder of my app, app is now only checking LastWriteTime dbs.

Xamarin
Xamarin
A Microsoft open-source app platform for building Android and iOS apps with .NET and C#.
5,325 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,351 questions
{count} votes