DB Data Repository Stuck in Initializing

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

DB Stuck in initializing stage, cant start or stop db.

 Node              | Host           | State        | Version          | DB
-------------------+----------------+--------------+------------------+--------
 v_drdata_node0001 | xx.xxx.xxx.xxx| INITIALIZING | vertica-10.1.1.0 | drdata
 v_drdata_node0002 | xx.xxx.xxx.xxx| INITIALIZING | vertica-10.1.1.0 | drdata
 v_drdata_node0003 | xx.xxx.xxx.xxx | INITIALIZING | vertica-10.1.1.0 | drdata

 DB     | Host | State
--------+------+--------------
 drdata | ALL  | INITIALIZING

When stop db, got an error:

Database drdata not stopped successfully for the following reason:
DB client operation "stop db" failed during `connect-plaintext`: ConnectionError: Severity: FATAL, Message: Node startup/recovery in progress. Not yet ready to accept connections, Sqlstate: 57V03, Routine: initSession, File: /data/qb_workspaces/jenkins2/ReleaseBuilds/Hammermill/REL-10_1_1-x_hammermill/build/vertica/Session/ClientSession.cpp, Line: 573, Error Code: 4149

 

Environment

Dx NetOps Performance Management any version

Resolution

To resolve you can do the following

1. Launch adminTools
2. Choose 7 Advanced Menu
3. Choose 3 Kill vertica process on host - this will stope all vertica processes on each host

Then restart the database.  The database should start at this point