wjkhappy14 / Abp.VNext.Hello

Abp.VNext.Hello
158 stars 42 forks source link

SqliteException: SQLite Error 6: 'database table is locked'. #18

Open wjkhappy14 opened 3 years ago

wjkhappy14 commented 3 years ago

SqliteException: SQLite Error 6: 'database table is locked'.

when use sqlite databae for ef core, got this execption

so ..... how to resolve ?

wjkhappy14 commented 3 years ago

Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(int rc, sqlite3 db) Microsoft.Data.Sqlite.SqliteDataReader.NextResult() Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader() Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery() Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, string commandText, SqliteParameter[] parameters) Microsoft.Data.Sqlite.SqliteTransaction..ctor(SqliteConnection connection, IsolationLevel isolationLevel) Microsoft.Data.Sqlite.SqliteConnection.BeginTransaction(IsolationLevel isolationLevel) Microsoft.Data.Sqlite.SqliteConnection.BeginDbTransaction(IsolationLevel isolationLevel) System.Data.Common.DbConnection.BeginDbTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken) System.Threading.Tasks.ValueTask.get_Result() System.Runtime.CompilerServices.ValueTaskAwaiter.GetResult() Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken) Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransactionAsync(CancellationToken cancellationToken) Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList entriesToSave, CancellationToken cancellationToken)

jishufangui commented 2 years ago

Does it have any progress?