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

Question

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].

Answer 1

@_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.