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
