Spontaneous SQLite db rollback

Cheeger 6

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.

StephenH 86 Reputation points

2021-03-16T23:53:34.563+00:00

Wow, SQLite is pretty solid.

I have never heard of anything like that, If you can share some it might help ?
Ken Tucker 5,861 Reputation points

2022-06-19T15:41:42.6+00:00

Would need to see some code

Share via

Spontaneous SQLite db rollback

Your answer