Menu
I am suddenly getting the following errors from SQLite after adding a new transaction:
The database file is locked database is locked
Has anyone seen this? I added an update transaction (following some successful selects/inserts). I can't find anything different about this one...
521
If you want to remove a "database is locked" error then follow these steps: Copy your database file to some other location. Replace the database with the copied database. This will dereference all processes which were accessing your database file.
Reasons Responsible for Error Database is Locked. This error code occurs when the user tries to perform two inappropriate operations on a database at the same detail and on the same database connection.
There's no use checking before (if that is possible), it still can get locked between the check and your next call. Better would be to make your call, and handle possible exceptions, eg. retry a number of times and report an error after too much retries.
I figured it out. From looking at this [really old] thread on the phxsoftware site, it seems like there can be locking problems if you don't immediately dispose of readers and commands after executing them.
I fixed my problem by making sure to not keep commands or readers around and surrounding them with using statements.
(Web archived version of the link)
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
