Open Closed

Connection reset by peer #5245


User avatar
0
cicna created
  • ABP Framework version: v7.2.2
  • UI type: MVC
  • DB provider: EF Core
  • Tiered (MVC) or Identity Server Separated (Angular): no
  • Exception message and stack trace:
  • [00:06:05 INF] Request starting HTTP/1.1 GET http://203.195.177.144:8080/api/app/orders?filterText=&orderNo=&projectName=&projectPriceMin=&projectPriceMax=&projectRemarks=&executionGenre=&auditStatus=&contractId=&customerId=&myApplyFlow=false&myApprovalFlow=false&sorting=contract.contractNo%20desc&skipCount=0&maxResultCount=10 application/json - [00:06:05 INF] Executing endpoint 'Ywz.Bms.Orders.OrdersAppService.GetListAsync (Ywz.Bms.Application)' [00:06:05 INF] Route matched with {action = "GetList", controller = "Orders", area = "", page = ""}. Executing controller action with signature System.Threading.Tasks.Task1[Volo.Abp.Application.Dtos.PagedResultDto`1[Ywz.Bms.Orders.OrderWithNavigationPropertiesDto]] GetListAsync(Ywz.Bms.Orders.GetOrdersInput) on controller Ywz.Bms.Orders.OrdersAppService (Ywz.Bms.Application).

[00:06:05 ERR] An exception occurred while iterating over the results of a query for context type 'Ywz.Bms.EntityFrameworkCore.BmsDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 35 - An internal exception was caught) ---> System.IO.IOException: Unable to read data from the transport connection: Connection reset by peer. ---> System.Net.Sockets.SocketException (104): Connection reset by peer --- End of inner exception stack trace --- at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException(SocketError error, CancellationToken cancellationToken) at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.System.Threading.Tasks.Sources.IValueTaskSource<System.Int32>.GetResult(Int16 token) at Microsoft.Data.SqlClient.SNI.SNINetworkStream.ReadAsync(Memory1 buffer, CancellationToken cancellationToken) at Microsoft.Data.SqlClient.SNI.SslOverTdsStream.ReadAsync(Memory1 buffer, CancellationToken cancellationToken) at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](CancellationToken cancellationToken) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource

  • Steps to reproduce the issue:"
  • DB:mssql2022

  • 多个用户不停的点击“合同管理”、“订单管理”菜单,主要速度够快,就会报错。
  • Multiple users keep clicking on the "contract management", "order management" menu, the main speed is fast enough, will report an error.
  • 请问,这个是什么原因呢?怎么修复呢?
  • Excuse me, what is the reason for this? How do you fix it?

1 Answer(s)
  • User Avatar
    0
    gterdem created
    Senior .NET Developer

    This seems related to SQL Server, not ABP. Perhaps there might be a time-out duration in SQL server that breaks the connection based on long running queries. Need to check with SQL-Server configurations.

    You can also check this SO answer.

Made with ❤️ on ABP v9.1.0-preview. Updated on December 13, 2024, 06:09