How to fix transient socket exception in Kusto when trying to query huge data

Ankit Awadhiya 55 Reputation points
2023-10-20T15:37:41.64+00:00

I see transient socket exceptions when querying large data sets, Something like this..

Kusto client failed to send a request to the service: 'Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond..
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
487 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Sander van de Velde 29,461 Reputation points MVP
    2023-10-20T17:09:09.17+00:00

    Hello @Ankit Awadhiya ,

    There is extended documentation explaining transient fault handling.

    The default solution is to work with a retry loop together with cool-off time.

    If this happens a lot, you probably need to scale up your resources.

    It's also valuable to check the query being executed and to find out why it fails. Perhaps the logic has too much freedom (gathering too much data) or the query is just not efficient resulting in extra costs (due to scaling up need).


    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.