Sqlite-net: Database Locked Error

Created on 20 Sep 2018 · 5Comments · Source: praeclarum/sqlite-net

I have upgraded from 1.4.118 to 1.5.231 and whenever I try to execute a scalar on an asynchronous connection, I receive an error that the database is locked. I had do downgrade to 1.4.118 and the issue is no longer present. What changed? I'm using this for a Xamarin forms project in conjunction with MVVMCross 6.2. Here is the simple method I call:

public async Task TableExists()
{
try
{
var command =
$"SELECT count(tbl_name) FROM sqlite_master WHERE type = 'table' AND name = '{typeof(T).Name}'";
var count = await DbAsynchronousConnection.ExecuteScalarAsync(command).ConfigureAwait(false);

            return count > 0;
        }
        catch (SQLiteException sqLiteException)
        {
            throw;
            //todo: handle the exception
        }
    }

Bug

Source

danielPollackGitHub

All 5 comments

What is this DbAsynchronousConnection you are using?
Try creating a new instance of a SQLiteAsyncConnection and using that for the ExecuteScalarAsync command. I think you use a single instance of SQLiteAsyncConnection for multiple queries and that is the source of your problems.
Moreover, check if you have storage permission acquired before running commands on the database.