I am developing a UWP app in C#.
I need a SQLite database to store some information, and I place this file in the LocalState folder, which I am sure to have access to.
Everything usually works fine, except in few cases in which some users experience an error while accessing the database when the app starts (please also notice that the users are able to normally run the app - sometimes - while other times the app cannot start because of this file access problem).
The error is thrown by the SQLite connector and says
database is locked
The users also confirm that they haven't touched the database file (actually they didn't even know it exists...)
Now, I cannot understand:
- What is the root cause of the problem, since the file should be accessible by the UWP app, it is in the private space of the user, so no other user of the machine should have access to it, and the UWP app is basically a singleton (you cannot run two instances of the App at the same time)
- Why it is happening to a small portion of the users, just sporadically
Thank you very much!