sqlite-net-pcl databale table locked issue with latest version 1.8.116

Ankur Gupta 21

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.

Thanks
Ankur (edited)

Leon Lu (Shanghai Wicresoft Co,.Ltd.) 67,631 Reputation points Microsoft Vendor

2022-11-07T08:35:21.667+00:00

This issue is related to the latest sqlit-net-pcl nuget package, you can open an issue in sqlit-net-pcl Github page directly.
Ankur Gupta 21 Reputation points

2022-11-07T10:22:52.86+00:00

So for now please suggest should we rollback to lower version of nuget or wait until issue resolved or any other alternative please.

Thanks
Ankur
Ankur Gupta 21 Reputation points

2022-11-08T07:00:30.683+00:00

below is the stack trace we are getting,

{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__431[T].<DropTableAsync>b__43_0 (SQLite.SQLiteConnectionWithLock conn) [0x00000] in <01c96d411fe34bd5940c99a56515582b>:0 at SQLite.SQLiteAsyncConnection+<>c__DisplayClass33_01[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
Ankur Gupta 21 Reputation points

2022-11-09T10:50:20.857+00:00

Hi LeonLu, we are facing this same issue until we downgraded to next 3 version that is - 1.2.531. Is this is also an known issue for in between version, can you please confirm.

Thanks
Ankur
Leon Lu (Shanghai Wicresoft Co,.Ltd.) 67,631 Reputation points Microsoft Vendor

2022-11-10T08:33:11.573+00:00

I cloned this official SQLite demo, sqlite-net-pcl version is 1.7.335, then I add some records in DB, after that, I update sqlite-net-pcl version to 1.8.116, Xamarin.Forms version is 5.0.0.2515, android target-framework is android 12. It is working in my side when I delete,add or update records.
Ankur Gupta 21 Reputation points

2022-11-10T14:00:11.087+00:00

Thanks. We are facing issue only while dropping table, can you also please check this.
Ankur Gupta 21 Reputation points

2022-11-11T09:58:52.413+00:00

Thanks LeonLu. Just to update that we are facing the issues with the latest nuget package while only dropping the tables not with delete, update.
DropTableAsync<TableName>();