Timeout on UpdateAndCommitAsync() about butterfly-server HOT 3 CLOSED

Which version of SQL Server are you running?
Also thanks for the stack trace, but please provide the rest of the exception as well. Hopefully something useful in there.

from butterfly-server.

I'm using the version 2012.

Full stack :
Butterfly.Core.Database.DatabaseException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Butterfly.SqlServer.SqlServerDatabase.<ExecuteCommandAsync>d__171.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.SqlServer\SqlServerDatabase.cs:line 275
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Butterfly.SqlServer.SqlServerDatabase.<DoSelectRowsAsync>d__9.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.SqlServer\SqlServerDatabase.cs:line 73 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Butterfly.Core.Database.Dynamic.DynamicView.d__21.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.Core\Database\Dynamic\DynamicView.cs:line 252
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Butterfly.Core.Database.Dynamic.DynamicViewSet.<StoreImpactedRecordsInDataEventTransaction>d__23.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.Core\Database\Dynamic\DynamicViewSet.cs:line 115 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Butterfly.Core.Database.Dynamic.DynamicViewSet.<ProcessUncommittedDataEventTransactionAsync>d__21.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.Core\Database\Dynamic\DynamicViewSet.cs:line 100 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Butterfly.Core.Database.BaseDatabase.<PostDataEventTransactionAsync>d__46.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.Core\Database\BaseDatabase.cs:line 147 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Butterfly.Core.Database.BaseTransaction.<CommitAsync>d__27.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.Core\Database\BaseTransaction.cs:line 258 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Butterfly.Core.Database.BaseDatabase.<UpdateAndCommitAsync>d__60.MoveNext() in C:\Users\marcoc\Desktop\butterfly-server-dotnet-master\Butterfly.Core\Database\BaseDatabase.cs:line 257 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at ConsoleApp1.Program.d__1.MoveNext() in c:\users\marcoc\source\repos\ConsoleApp1\ConsoleApp1\Program.cs:line 151`

from butterfly-server.

Could you possibly try to set your Isolation Level just to see if that solves the problem?

ALTER DATABASE MyDatabase  
SET ALLOW_SNAPSHOT_ISOLATION ON  
  
ALTER DATABASE MyDatabase  
SET READ_COMMITTED_SNAPSHOT ON

from butterfly-server.