Skip to main content

Vertica could not translate host name "xxxx" to address

  • August 9, 2019
  • 1 reply
  • 2 views
dithesh

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.

    1 reply

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • August 11, 2019

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement