DataAction / AdoNetCore.AseClient

AdoNetCore.AseClient - a .NET Core DB Provider for SAP ASE
Apache License 2.0
106 stars 44 forks source link

When under load we are seeing a common error in our application logs: AdoNetCore.AseClient.AseException: There is no server listening at ... #215

Open bbarry opened 3 years ago

bbarry commented 3 years ago

Describe the bug This is going to be frustrating...

We have a scanning application performing compliance scans against our application which overnight makes a large number of requests to the application and eventually causes the application to become unavailable. When it becomes unavailable the exception is the one from https://github.com/DataAction/AdoNetCore.AseClient/blob/a0d87f8e5e321119acc8de90528ce17f89380b39/src/AdoNetCore.AseClient/Internal/InternalConnectionFactory.cs#L163

This exception hides the internal details of what is happening from us and we are unable to further diagnose our issue.

Can the internal exception that is here be added to the constructor of this exception on this line?

Mies75 commented 2 years ago

We still have this with version 0.19.2: at AdoNetCore.AseClient.Internal.InternalConnectionFactory.CreateConnection(Socket socket, CancellationToken token) in C:\Users\tiennguyen\source\repos\AdoNetCore.AseClient.0.19.2\src\AdoNetCore.AseClient\Internal\InternalConnectionFactory.cs:line 166\r\n at AdoNetCore.AseClient.Internal.InternalConnectionFactory.GetNewConnection(CancellationToken token, IInfoMessageEventNotifier eventNotifier) in C:\Users\tiennguyen\source\repos\AdoNetCore.AseClient.0.19.2\src\AdoNetCore.AseClient\Internal\InternalConnectionFactory.cs:line 49\r\n at AdoNetCore.AseClient.Internal.ConnectionPool.Reserve(IInfoMessageEventNotifier eventNotifier) in C:\Users\tiennguyen\source\repos\AdoNetCore.AseClient.0.19.2\src\AdoNetCore.AseClient\Internal\ConnectionPool.cs:line 55\r\n at AdoNetCore.AseClient.AseConnection.Open() in C:\Users\tiennguyen\source\repos\AdoNetCore.AseClient.0.19.2\src\AdoNetCore.AseClient\AseConnection.cs:line 278\r\n at System.Data.Common.DbConnection.OpenAsync(CancellationToken cancellationToken)

Any idea?