A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated: Connection was terminated)

Bastien NOEL 30 Reputation points
2023-10-06T09:09:54.5866667+00:00

Hello,

We have an application connect to a sql azure database. Since few days, we've been getting random TCP errors to this database.

The application is deployed on an AKS with an azure application gateway.

The error is :

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated: Connection was terminated)

I found this microsoft documentation:

https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql#error-10053-a-transport-level-error-has-occurred-when-receiving-results-from-the-server

The aks metrics are ok, everything's fine.

This problem occurs without any update on our part.

The error occurs randomly once every 5-10-30min...

Do you have more information?

Azure SQL Database
Azure Application Gateway
Azure Application Gateway
An Azure service that provides a platform-managed, scalable, and highly available application delivery controller as a service.
968 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,883 questions
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
    2023-10-06T09:33:13.9866667+00:00

    Hi
    Bastien NOEL
    •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you are getting an error "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated: Connection was terminated)" when connecting from an AKS application to Azure SQL database.

    We are sorry about the inconvenience you are currently facing.

    In some situations, we found that application reported the following error message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated ). It might be caused when application server reaches CPU throttling, High Memory Utilization.

    Also, in AKS, High CPU Reservation (Requests) plus too many pods have very large difference between their CPU Requests and CPU Limits, these pods will be affected by CPU Throttling. To Protect the pods against CPU Throttling the recommendation is to Set their CPU Request equal to the high value of the CPU Limit, only then it will be protected because it will be using Kubernetes QOS Class Guaranteed.

    Let us know if above scenario helps in your case.

    If not we will look further into the issue. Thanks

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful