'Intermittent error 'This node is not ready to answer queries yet' in Azure Data Explorer (kusto)
On a 5 node V2 kusto cluster, there are intermittent errors while running both commands and queries:
"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=BecomingPrimary"
How to avoid this error altogether, and how long should one wait before retrying?
Solution 1:[1]
This error suggests that the database admin node is transitioning - it's 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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Yoni L. |