MTP Vertica database is down ? comprehensive guide

Document ID : KB000056944
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

MTP Vertica database is down.

Environment:

Multi-Port Collector appliance

Cause:

MTP Vertica database may become corrupted due to a power outage or hardware failure. For planned MTP shutdown it is recommended to gracefully shutdown the database to prevent database corruption.

Resolution:

1. Logon as the dbadmin user and launch the adminTools utility:

    $ su - dbadmin

2. This will bring up the menu below. Select (1) to check the database status, if it is down, check the option (3) to start it:

    1.jpg

3. If a message states that the database could not be started because vertica process is still running, go back to the sudo user and issue the command below:

    ps -ef | vertica

4. Use kill command to terminate all processes listed by the above command and then follow the procedures from 1 to 3 again and you should be prompted to the screen similar to the one below. Click Yes to confirm database restoration from the last known epoch:

    2.jpg

5. If successful, the vertica database will be up and you will be brought back to the menu where you can select (E) to exit the menu and return to the Linux prompt.

6. If the steps above are not successful in bringing the Vertica database up, then re-create the database by following the procedure below:

    6.1. Log into the MTP Linux command line using the netqos account.
    6.2. sudo   /opt/NetQoS/scripts/stopprocs.sh  (stops all the daemon processes)
    6.3. sudo   /opt/NetQoS/install/setupVertica.sh  --new
    6.4. sudo   /opt/NetQoS/install/setupReplicateMySqlToVertica.sh
    6.5. sudo  /opt/NetQoS/scripts/startprocs.sh