nminaya / grammar-nazi-bot

Bot that corrects spelling mistakes.
MIT License
31 stars 8 forks source link

Application Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. #516

Open nminaya opened 2 years ago

nminaya commented 2 years ago

This is an issue created automatically by GrammarNazi when an exception was captured.

Date (UTC): 11/10/2022 02:36:27

Exception:

Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): Unknown error 258 at Microsoft.Data.SqlClient.SqlCommand.<>c.b__188_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken) at GrammarNazi.Core.Repositories.EFRepository1.GetAll(Expression1 filter) in /src/GrammarNazi.Core/Repositories/EFRepository.cs:line 43 at GrammarNazi.App.HostedServices.BaseTwitterHostedService.PublishScheduledTweets() in /src/GrammarNazi.App/HostedServices/Twitter/BaseTwitterHostedService.cs:line 57 at GrammarNazi.App.HostedServices.TwitterBotMentionHostedService.ExecuteAsync(CancellationToken stoppingToken) in /src/GrammarNazi.App/HostedServices/Twitter/TwitterBotMentionHostedService.cs:line 142 ClientConnectionId:a0f8c357-36aa-4ce4-be8e-b0358e830225 Error Number:-2,State:0,Class:11

Exception caught counter: 6.

nminaya commented 2 years ago

This seems to be an open issue with SqlClient https://github.com/dotnet/SqlClient/issues/1530

I'll just close this issue since it doesn't seem to happen very often.

bddotbd commented 1 year ago

It's happening. I am getting the same problem everyday. I am using docker in redhat server. .net 6. Still i am struggling with this.

nminaya commented 1 year ago

@bddotbd Hi, they have an open issue in https://github.com/dotnet/SqlClient/issues/1530

nminaya commented 1 year ago

Issue still happening #562