Why it might happen, that a SQLite database file gets locked?

[Darius Damalakas]

I have upgraded to NH 2.1.x, and now the tests running on SQLite
database now fail with this exception:

----> System.Reflection.TargetInvocationException : Exception has been
thrown by the target of an invocation.
----> NHibernate.TransactionException : Begin failed with SQL
exception
----> System.Data.SQLite.SQLiteException : The database file is
locked
database is locked


--SQLiteException
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at System.Data.SQLite.SQLiteTransaction..ctor(SQLiteConnection
connection, Boolean deferredLock)
at System.Data.SQLite.SQLiteConnection.BeginTransaction(Boolean
deferredLock)
at System.Data.SQLite.SQLiteConnection.BeginDbTransaction
(IsolationLevel isolationLevel)
at
System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction
()
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel
isolationLevel)



Any ideas why it was working before and now does not?

[Fredy Treboux]

How about providing the test?

[J M]

SchemaUpdate is not supported by SQLite. You'll have to move to
another database type that does support it if you really need it.

I can't find a complete list of which databases support SchemaUpdate,
but I know at least SQL Server does.

[J M]

Sorry, ignore that. Wrong thread.

[Nelson Cabral]

To make it clear : SchemaUpdate works with SQLite. The SQLite file
lock problem is due to multithreaded access to an SQLite db (file).