I have an Android 11 based RFID handheld reader. For inventories I copy a SQLite file to the device in working directory of the internal storage folder using MTP from a Windows computer.

My application is .Net written in Xamarin.Forms, compiled with Android 11 SDK.

When the RFID reader finds items listed in the SQLite inventory it updates the data with the DateTime the item is located.

This application has worked for all previous Android version devices with no issue.

In this device the SQLite file is getting seemingly "locked" randomly during operation. When the file gets "locked" it cannot be read or updated. Closing the application does not remove the "lock" and I get a unable to open database error.

I tested file permissions while the file was "locked" and was able to call Sytem.IO.File.OpenRead() with no errors.

The only resolution to the "lock" is to reboot the device completely.

Changing from sqlite-net-pcl nuget library to Microsoft.Data.Sqlite had no affect on the behavior.

In trying to resolve the issue I enabled "WAL" mode, which seemed to resolve the issue, but has only lessened the frequency of the "lock" occurring.

Thanks in advance for any suggestions.