5,380 questions
sqlite-net-pcl databale table locked issue with latest version 1.8.116
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 16%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ankur Gupta
21
Reputation points
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)
Developer technologies .NET Xamarin
SQL Server Other
14,494 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2022-11-07T08:35:21.667+00:00 This issue is related to the latest
sqlit-net-pcl nugetpackage, you can open an issue insqlit-net-pclGithub 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 -
Anonymous
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>();
Sign in to comment
Sign in to answer