SQL Azure Random Timeout

0

I have web apps right now is connecting to the SQL Azure,
Right now i have an issue on this line of code

_userManager.GetUserAsync(User).Result;

The issue is very randomly happen. My Connection Timeout: 300, I have increase to 1000 also not working

System.AggregateException HResult=0x80131500 Message=One or more errors occurred. (Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The group or resource is not in the correct state to perform the requested operation.)) Source=System.Private.CoreLib StackTrace: at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification) at Panda.LMS.Web.Controllers.Api.QuestionController.ValidateAnswer(ValidateAnswerModel input) in C:+Beta\LMS2\LMS\Panda.LMS.Web\Controllers\Api\QuestionController.cs:line 62 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<g__Logged|12_1>d.MoveNext()

Inner Exception 1: SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The group or resource is not in the correct state to perform the requested operation.)

Inner Exception 2: Win32Exception: The wait operation timed out.

c#
sql
asp.net-web-api
.net-core
azure-sql-database
asked on Stack Overflow Feb 2, 2020 by Herman

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0