service verticad status not OK

Dear Support,

Vertica DB server hang, so customer committed cold shutdown, then start OS.
OS started successfully, but Vertica DB failed to start.
~~~
~]# /etc/init.d/verticad start
Vertica: start OK for users: dbadmin
[root@obrdb01 ~]# [ OK ]
[root@obrdb01 ~]#
[root@obrdb01 ~]# /etc/init.d/HPE_PMDB_Platform_Vertica status
HPE_PMDB_Platform_Vertica is stopped
[root@obrdb01 ~]# /etc/init.d/verticad status
Vertica: status not OK
[root@obrdb01 ~]#

Customer tried following:

[dbadmin@obrdb01 ~]$ id
uid=502(dbadmin) gid=502(dbadmin) groups=502(dbadmin)
[dbadmin@obrdb01 ~]$ service verticad start
Vertica: Password:
start not OK
[dbadmin@obrdb01 ~]$ service verticad status
Vertica: Password:
status not OK
[dbadmin@obrdb01 ~]$
~~~~~~~

We collected below info and attached vertica.log:
~~~~~~
[root@obrdb01 ~]# rpm -qa | grep vertica
vertica-7.1.2-0.x86_64

[dbadmin@obrdb01 ~]$ admintools -t list_allnodes
Node | Host | State | Version | DB
-----------------+--------------+-------+-------------------+------
v_pmdb_node0001 | 10.100.74.56 | DOWN | vertica-7.1.2.000 | pmdb
~~~~

Rgds,
Q

Comments

  • try starting vertica from admintools
    Login the su - dbadmin
    Admintools
    and start db from there

  • again it failed.

    *** Starting database: pmdb ***
    Starting nodes:
    v_pmdb_node0001 (10.100.74.56)

        Starting Vertica on all nodes. Please wait, databases with large catalog                                                                                        s may take a while to initialize.
    
        Node Status: v_pmdb_node0001: (INITIALIZING)
        Node Status: v_pmdb_node0001: (INITIALIZING)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Node Status: v_pmdb_node0001: (DOWN)
        Error starting database, no nodes are up
    

    Press RETURN to continue

  • you will have to check the startup.log file
    Maybe there is an issue with th epoc

  • [Deleted User][Deleted User] Administrator

    Please check vertica.log and startup.log in catalog directory for more details on failure.

Leave a Comment

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