This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 12%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Hi,
One of our team is getting the below error when their API hosted in AKS connecting to Postgres DB (Configured using Private endpoint). This error is generated at random requests, say in a day 50 requests fails due to this. I verified the internal routes and everything looks to be good. Sometimes DNS fails. Anyone has any guess about this error (Attached screenshot for info).
ConnectionError [SequelizeConnectionError]: getaddrinfo EAI_AGAIN dev-airside.postgres.database.azure
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Hello Ravichandran, Gopi Krishna,
Welcome to microsoft Q&A, thankyou for posting your query here.
"getaddrinfo" is a function used to translate a hostname into an IP address.
"EAI_AGAIN" indicates a temporary failure to resolve the hostname.
DNS errors are suspicious. Look at any timeouts or irregularities in your internal DNS setup.
In your AKS cluster, use dig or nslookup to verify that the IP address of the Postgres endpoint resolves correctly.
For any DNS resolution issues or connectivity issues, review the pod logs.
Make sure the Postgres database instance is stable and operating as it should. Look for any errors in its logs.
to get more info and possible causes please refer this link
https://github.com/nodejs/node/issues/15780
hope this helps you.
Thanks for checking. Postgres DB is configured with Private End point using Azure Private DNS Zones. Also, the postgres DNS is resolving from Pod level.
It looks like most of the connection works and very few connection requests fails with above error.
Does it sound like any issues with Private DNS Zones that connects the Postgres DB.
Hello Ravichandran, Gopi Krishna,
There is possibility that DNS hostname cannot be resolved to ip address.
Hello Ravichandran, Gopi Krishna,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help
There was no resolution found for this issue. DNS is resolving from pods. But the DNS fails randomly. Not sure how to proceed further on this. Please let me know if you have any other approach to fix this.
Hello Ravichandran, Gopi Krishna,
Can you provide any error messages from your API and Postgres logs during connection failures.
and configuration details of your private zone.
Hello @Anveshreddy Nimmala
I am attaching screenshot of the error popping up from the API. image (7).png
Here is our private dns zone - dev-airside.private.postgres.database.azure.com [Private DNS Zone configured/virtual network linked to our hub VNET]
nslookup resolves to an IP
Non-authoritative answer:
Name: dev-airside.private.postgres.database.azure.com
Address: 10.X.X.4
Hello Ravichandran, Gopi Krishna,
It's possible that your application isn't set up to use the private DNS zone for DNS resolution. The application settings may need to be changed to utilize the private endpoint's FQDN in the format {your-postgresql-server-name}.privatelink.postgres.database.azure.com if your application connects to the database using its hostname.
Your application is running on a virtual network that is set up to use the hub VNET's private DNS resolver.
https://video2.skills-academy.com/en-us/azure/dns/dns-private-resolver-overview
Hope this helps you
Hello @Anveshreddy Nimmala
I am wondering if Postgres DB Flexible server can have {your-postgresql-server-name}.privatelink.postgres.database.azure.com.
Are you suggesting to use private endpoint FQDN [{postgres-server-name}.private.postgres.database.azure.com] in application to connect the DB.
Hello Ravichandran, Gopi Krishna,,
yes I am suggesting to use private endpoint FQDN [{postgres-server-name}.private.postgres.database.azure.com] in application to connect the DB.
Have a check on this as well.
Check if Your application is running on a virtual network that is set up to use the hub VNET's private DNS resolver.
https://video2.skills-academy.com/en-us/azure/dns/dns-private-resolver-overview
OK. Let me ask the application team to do this change and test it. I shall come back to you again.
thankyou @Ravichandran, Gopi Krishna, we will be looking forward for the update.
Hello Ravichandran, Gopi Krishna,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help
I am yet to get a response from application team. May be it was not tried from their side. I will come back if the issue still persists.
Thanks for responding back on this, please contact us back if you need any further assistance.