Sqlite databases getting locked by Unity.

Question

Hi guys,

Whenever I try to input values into my sqlite database from unity, it always throws an exception: SqliteException: The database file is locked I still can read from it, but whenever I try to write into the db, Unity will hang for 10 secs and then that error pops up in the console. Here is my code:

 public SqliteDataReader InsertInto(string tableName, string[] values)
     {
         string query = "INSERT INTO " + tableName + " VALUES(" + values[0];
         for (int i = 1; i < values.Length; ++i)
         {
             query += ", " + values[i];
         }
         query += ")";
         Debug.Log("Inserted!");
         return ExecuteQuery(query);
     }

I also understand that t$$anonymous$$s might occur due to the closing of connections being wrong(w$$anonymous$$ch I $$anonymous$$ghly doubt so, but to be sure heres the closing code:

 public void CloseSqlConnection()
     {
         reader.Close();
         reader = null;
         dbCommand.Dispose();
         dbCommand = null;
         dbConnection.Close();
         dbConnection = null;
         GC.Collect();
         Debug.Log("Disconnected from db.");
     }

T$$anonymous$$s problem occurs even when I restart my PC, and launch Unity for the first time, so I doubt its the connection problem. Also, the database is in the proper folder, and it works fine(as I can read from it). It was working fine a few days back, and now it just decided to break.

Answer 1

Best Answer

Answer by Jamora · Jul 25, 2013 at 09:04 AM

I made a little test script to see how many times OnFocus is called when the window is opened the first time. Turns out it is called twice. So the reason why your database is locked for writing is because you have an open, possibly leaked connection to it. After the first time On(Lost)Focus behaves as expected.

I t$$anonymous$$nk somet$$anonymous$$ng along these lines would work better:

 [MenuItem("Item/Item")]
 public static void Init(){
     GetWindow<TestScript>();
     //Initialize connection.
 }
 
 void OnFocus(){
     //If (connection == null)
     //Initialize connection.
 }
 
 void OnLostFocus(){
     //Close connection.
 }

0 Show 1 · Share

jXD · Jul 27, 2013 at 01:22 AM 0

Share

Thanks, that worked perfectly. I also found that running as admin solves it temporarily, but changing my script to that worked better. Thanks!

Answer 2

Answer by jXD · Jul 24, 2013 at 11:40 PM

I'm using the sqlite manager script from the unify wiki. I found the c# version on the unity forums some time back. As for the closesqlconnection(), I'm using t$$anonymous$$s from an editorwindow, so I call it every onlostfocus() and reconnect every onfocus().

0 · Share

Sqlite databases getting locked by Unity.

2 Replies

Your answer

Welcome to Unity Answers

Follow this Question

Related Questions