sqlite-net-pcl nuget package issue as database table locked

[ankurgupta22]

Hi, we have an xamarin.forms app using sqlit-net-pcl nuget package latest version 1.8.116 and it throws an error often "database table is locked while dropping". It does not throw any error if downgrade to package version 1.5.231. As of now we are managing deleting records with the latest nuget package but we want to drop and create table instead. Any help would be really appreciated. Erro message below,

SQLite.SQLiteException: database table is locked
  at SQLite.SQLiteCommand.ExecuteNonQuery () [0x000cd] in <01c96d411fe34bd5940c99a56515582b>:0
  at SQLite.SQLiteConnection.Execute (System.String query, System.Object[] args) [0x00039] in <01c96d411fe34bd5940c99a56515582b>:0
  at SQLite.SQLiteConnection.DropTable (SQLite.TableMapping map) [0x00018] in <01c96d411fe34bd5940c99a56515582b>:0
  at SQLite.SQLiteConnection.DropTable[T] () [0x00012] in <01c96d411fe34bd5940c99a56515582b>:0
  at SQLite.SQLiteAsyncConnection+<>c__43`1[T].<DropTableAsync>b__43_0 (SQLite.SQLiteConnectionWithLock conn) [0x00000] in <01c96d411fe34bd5940c99a56515582b>:0
  at SQLite.SQLiteAsyncConnection+<>c__DisplayClass33_0`1[T].<WriteAsync>b__0 () [0x00013] in <01c96d411fe34bd5940c99a56515582b>:0
  at System.Threading.Tasks.Task`1[TResult].InnerInvoke () [0x0000f] in /Library/Frameworks/Xamarin.iOS.framework/Versions/Current/src/Xamarin.iOS/external/corert/src/System.Private.CoreLib/src/System/Threading/Tasks/Future.cs:534
  at System.Threading.Tasks.Task.Execute () [0x00000] in /Library/Frameworks/Xamarin.iOS.framework/Versions/Current/src/Xamarin.iOS/external/corert/src/System.Private.CoreLib/src/System/Threading/Tasks/Task.cs:2319

Thanks
Ankur

[jamesmontemagno]

@praeclarum is there anything i can do on this one? I had someone ping me on this, trying to get a repro. @ankurgupta22 do you have code?

[praeclarum]

@ankurgupta22 I am having trouble reproing. Can you give a few details on the OS and hardware you're running on?

Also, would you try the 1.9.141-beta? It doesn't have any direct fixes for this problem but does have a newer raw reference.

[onurhazar]

@praeclarum @jamesmontemagno Hi, the problem still occurs. We started using the SQLite.cs class itself from the repo after testing the latest version of nuget package (including the beta).

We also tried with adding reference to SQLitePCLRaw packages and add USE_SQLITEPCL_RAW in project. This problem started after we migrated our Xamarin native project to .NET7.

The Microsoft link below recommends using flags;
https://learn.microsoft.com/en-us/dotnet/maui/data-cloud/database-sqlite?view=net-maui-7.0#install-the-sqlite-nuget-package
We also tried to use flags while creating async/sync SQLiteConnection but no luck :( Any help would be great.