The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Vertica could not translate host name "xxxx" to address

ditheshdithesh
edited August 9 in General Discussion

Hello All,
When trying to connect to vertica database (Vertica Analytic Database v8.0.1-4), i get the below error. However it works some times.
SQL State: 08001
Native Error: 160
Error Message: [Vertica][VerticaDSII] (160) connection attempt failed:could not
translate host name "xxxxxxx.com" to address: This is usually
a temporary error during hostname resolution and means that the local server did
not receive a response from an authoritative server.

However when i tried to connect from a different machine, it works with out any error.
Appreciate your help.

Comments

  • SruthiASruthiA Employee

    Are you using DNS Server to resolve hostnames? If so check DNS Server logs to see if the name resolution to IP address is failing. In order to over come this error, you can use IP address instead of hostname while connecting or add an entry vertica server IP address to /etc/hosts file on the machine from where you are trying to connect to Vertica.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.