mysql 锁 启动失败_mysql-dbupdateException('尝试获取锁时发现死锁;尝试重新启动事务')...

我在.NET核心中有一个MVC应用程序使用MySQL。我有一个下载功能,通过它可以传递ID来下载文件。然而,错误不断发生,并且似乎不知怎么地,应用程序在服务器上的响应变得不那么灵敏,就好像它被回收了一样。下面的代码显示了负责下载文件的部分。我正在使用TransactionScope确保下载计数器已正确更新。我得到的错误与死锁有关。是否有可能有人指出问题所在?

using (var context = new MyDbContext())

using (TransactionScope scope = new TransactionScope())

{

ProjectDownload download = context.ProjectDownload.Include(pd => pd.Project).Where(d => d.Id == downloadId).FirstOrDefault();

if (download == null) throw new InvalidOperationException("Cannot find ProjectDownload.Id");

download.DownloadCounter++;

download.Project.DownloadCounter++;

try

{

context.SaveChanges();

scope.Complete();

return (ProjectDownloadModel)download;

}

catch (DbUpdateException ex){

throw;

}

}

还尝试将以前的代码更改为:

using (var context = new MyDbContext())

using (TransactionScope scope = new TransactionScope())

{

ProjectDownload download = context.ProjectDownload.Where(d => d.Id == downloadId).FirstOrDefault();

download.DownloadCounter++;

Project proj = context.Project.Where(p => p.ProjectDownload.Any(pd => pd.Id == downloadId)).FirstOrDefault();

proj.DownloadCounter++;

...

出现以下错误:

Exception has occurred: CLR/MySql.Data.MySqlClient.MySqlException

An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in Microsoft.EntityFrameworkCore.dll but was not handled in user code: 'Deadlock found when trying to get lock; try restarting transaction'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)

at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)

at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)

at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()

at System.Linq.Enumerable.SelectEnumerableIterator`2.MoveNext()

at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable`1 source, Boolean& found)

at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable`1.GetEnumerator()

at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_trackentities>d__17`2.MoveNext()

at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()

at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable`1 source, Boolean& found)

at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)

at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass15_1`1.b__0(QueryContext qc)

at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)

at ProjectProcess.DownloadProject(Int32 downloadId) in C:\Users\Projects\ProjectWebsite\BusinessLogic\ProjectProcess.cs:line 124

at ProjectController.DownloadProject(Int32 downloadID) in C:\Users\Projects\ProjectWebsite\Controllers\ProjectController.cs:line 33

at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)

at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__12.MoveNext()

我不明白死锁是怎么发生的,怎么解决的