We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


admintools locale issue — Vertica Forum

admintools locale issue

What do you think about the below problem? If I did not set my locale correctly admintools did not show me the correct results. Is it the expected thing?

[dbadmin@ver04 ~]$ locale
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
LANG=en_US.UTF-8
LC_CTYPE=UTF-8
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
[dbadmin@ver04 ~]$ admintools -t list_allnodes
WARNING: Unable resolve host  10.2.1.2
WARNING: Unable resolve host  10.2.1.3
WARNING: Unable resolve host  10.2.1.5
WARNING: Unable resolve host  10.2.1.4
 Node                 | Host          | State   | Version           | DB
----------------------+---------------+---------+-------------------+-----------
 v_myvert_node0001 | 10.2.1.2  | UNKNOWN | vertica-7.0.1.000 | myvert
 v_myvert_node0002 | 10.2.1.4 | UNKNOWN | vertica-7.0.1.000 | myvert
 v_myvert_node0003 | 10.2.1.5 | UNKNOWN | vertica-7.0.1.000 | myvert
 v_myvert_node0004 | 10.2.1.3  | UNKNOWN | vertica-7.0.1.000 | myvert

[dbadmin@ver04 ~]$ export LC_ALL=en_US.UTF-8
[dbadmin@ver04 ~]$ admintools -t list_allnodes
WARNING: Unable resolve host  10.2.1.3
WARNING: Unable resolve host  10.2.1.2
WARNING: Unable resolve host  10.2.1.4
WARNING: Unable resolve host  10.2.1.3
 Node                 | Host          | State | Version           | DB
----------------------+---------------+-------+-------------------+-----------
 v_myvert_node0001 | 10.2.1.2  | UP    | vertica-7.0.1.000 | myvert
 v_myvert_node0002 | 10.2.1.4 | UP    | vertica-7.0.1.000 | myvert
 v_myvert_node0003 | 10.2.1.5 | UP    | vertica-7.0.1.000 | myvert
 v_myvert_node0004 | 10.2.1.3  | UP    | vertica-7.0.1.000 | myvert

Comments

  • Hi Ozi!

    >> Is it the expected thing?
    Yes, its expected. Please read your output:
    [dbadmin@ver04 ~]$ locale
    locale: Cannot set LC_CTYPE to default locale: No such file or directory
    locale: Cannot set LC_ALL to default locale: No such file or directory
    LANG=en_US.UTF-8
    LC_CTYPE=UTF-8
    ...

    UTF-8 what? Where is language? UTF-8 its just encoding.

Leave a Comment

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