An admin command cannot be executed temporarily due to an internal state transition

_Esteban Bett 30 Reputation points
2024-05-31T22:51:48.55+00:00

We have an ADX cluster with two instances and java service querying external tables using jdbc sql driver.
We ran a performance test, more than 3k requests. We saw many db query errors with this message:

An admin command cannot be executed temporarily due to an internal state transition; please try again later (State='This node is not ready to answer queries yet. This is usually a temporary error that occurs while the service is becoming online. Admin service state is: 'Role=Secondary''.) RequestId: TDS;4e9d099c-f412-4594-833c-00e94b8add7d;6 Time: 2024-05-31T21:53:39.3511405Z] [n/a]; SQL [n/a].

User's image

User's image

User's image

User's image

User's image

User's image

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.
497 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 82,196 Reputation points Microsoft Employee
    2024-06-03T05:00:36.3+00:00

    @_Esteban Bett - Thanks for the question and using MS Q&A platform.

    The error message you received indicates that the ADX cluster is not ready to answer queries yet. This is usually a transient state that could occur periodically.

    If the issue persists, it could either be a result of over-usage, leading to significant load on the admin node, or a different issue.

    If you need assistance with troubleshooting, I would recommend that you open a support request via the Azure portal. The support team can help you investigate the issue further and provide guidance on how to resolve it.

    Hope this helps. Do let us know if you any further queries.