Deadlocks from sql - Githubissues

Get next task , can still get deadlocks from sql:
↑8 (ApiWrapper) : 500 : {
  "Message": "An error has occurred.",
  "ExceptionMessage": "Transaction (Process ID 53) was deadlocked on lock resources with another pro
cess and has been chosen as the deadlock victim. Rerun the transaction.",
  "ExceptionType": "System.Data.SqlClient.SqlException",
  "StackTrace": "   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean b
reakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.SqlInternalConnection.OnE
rror(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Da
ta.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConn
ectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehav
ior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsPa
rserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlCommand.FinishExecut
eReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n   at System.Data.S
qlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolea
n returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Bool
ean describeParameterEncryptionRequest)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(C
ommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskComple
tionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n   at System.Data.SqlClie
nt.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean
sendToPipe, Int32 timeout, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteNonQ
uery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Actio
n`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command
)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction tran
saction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at API.Repository.JobRepository.Ge
tNextJob() in C:\\Projects\\ffmpeg-farm\\ffmpeg-farm-server\\API.Repository\\JobRepository.cs:line 2
75\r\n   at API.WindowsService.Controllers.TaskController.GetNext(String machineName) in C:\\Project
s\\ffmpeg-farm\\ffmpeg-farm-server\\API.WindowsService\\Controllers\\TaskController.cs:line 38\r\n
 at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpAc
tionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] method
Parameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execut
e(Object instance, Object[] arguments)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescr
iptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationTok
en cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown --
-\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System
.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Sy
stem.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- E
nd of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.Comp
ilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.Task
Awaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.Acti
onFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where
exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Tas
k task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification
(Task task)\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()
\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Web
.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()\r\n--- End of stack trace from
 previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwait
er.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSucce
ssAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<S
endAsync>d__1.MoveNext()"
}
drdk / ffmpeg-farm

Deadlocks from sql #7
