"Being used by another process" after successful Update

[motrinib]

Hello,

  I am using SimpleSQL to pull player data (multiple players and enemies) from the database each time a random encounter occurs.  This works great on single and full table pulls.

 However, every time I "update" one of the records after a battle the DB remains locked.  The next time Unity attempts to pull data, about 16 seconds later, it displays the following error:


Cancelling DisplayDialog because it was run from a thread that is not the main thread: Opening file failed Opening file D:/<path>/PlayerDB.bytes: The process cannot access the file because it is being used by another process.


At that point, the DB file icon has changed to a blank doc icon and was removed from the SQL Manager object.

I have verified that the one update command that was run did successfully write the changed data to the table.

[echo17]

This is usually caused by having the database open in another program, like a database editor. If possible, try closing the database in the editor before running your project in Unity.

If that doesn't solve the issue, I think I will need to see an example project that demonstrates the issue. It could be something to do with the versions of the Unity editor, SimpleSQL, or operating system. If you can supply that information and follow this FAQ, that would be helpful for my diagnosis: link