Databases
StackOverflow2013
Postsdbo
POSQLite Database Locked exception
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLite Database Locked exception
    primarykey
    data
    text
    <p>I am getting <strong>Database is locked</strong> exception from <strong>SQLite</strong> for some queries only. </p> <p>Below is my code: When I execute any select statement it works fine.<br> When I am executing any write statement on <code>Jobs</code> Table it also works fine. </p> <p>This works fine: </p> <pre><code>ExecuteNonQuery("DELETE FROM Jobs WHERE id=1"); </code></pre> <p>But the same way if I am executing queries for <code>Employees</code> table it is throwing an exception that <strong>database is locked</strong>.<br> This throws Exception:</p> <pre><code>ExecuteNonQuery("DELETE FROM Employees WHERE id=1"); </code></pre> <p>Below are my functions:</p> <pre><code>public bool OpenConnection() { if (Con == null) { Con = new SQLiteConnection(ConnectionString); } if (Con.State == ConnectionState.Closed) { Con.Open(); //Cmd = new SQLiteCommand("PRAGMA FOREIGN_KEYS=ON", Con); //Cmd.ExecuteNonQuery(); //Cmd.Dispose(); //Cmd=null; return true; } if (IsConnectionBusy()) { Msg.Log(new Exception("Connection busy")); } return false; } public Boolean CloseConnection() { if (Con != null &amp;&amp; Con.State == ConnectionState.Open) { if (Cmd != null) Cmd.Dispose(); Cmd = null; Con.Close(); return true; } return false; } public Boolean ExecuteNonQuery(string sql) { if (sql == null) return false; try { if (!OpenConnection()) return false; else { //Tx = Con.BeginTransaction(IsolationLevel.ReadCommitted); Cmd = new SQLiteCommand(sql, Con); Cmd.ExecuteNonQuery(); //Tx.Commit(); return true; } } catch (Exception exception) { //Tx.Rollback(); Msg.Log(exception); return false; } finally { CloseConnection(); } } </code></pre> <p>This is the Exception: At line 103 : <code>Cmd.ExecuteNonQuery();</code></p> <blockquote> <p>Exception Found: Type: System.Data.SQLite.SQLiteException Message: database is locked database is locked Source: System.Data.SQLite</p> <p>Stacktrace: at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at TimeSheet6.DbOp.ExecuteNonQuery(String sql) in d:\Projects\C# Applications\Completed Projects\TimeSheet6\TimeSheet6\DbOp.cs:line 103</p> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UScoding
    1. UScoding
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQLite Database Locked exception
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSQLite Database Locked exception
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSQLite Database Locked exception
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMake sure you close the connection are executing your request.
      singulars
      1. POSQLite Database Locked exception
      1. USVishal Suthar
    2. COYes I have closed all the connections and disposed the command objects also.
      singulars
      1. POSQLite Database Locked exception
      1. UScoding
    3. COI have done a lot of debugging behind this. This doesn't seem to be a problem of open connection.
      singulars
      1. POSQLite Database Locked exception
      1. UScoding
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload