Recreate the Vertica Metrics Database

Applies to CA6000 and CA6300 appliances

Recreate the Vertica metrics database to resolve database corruption. If the System Status page of the CA Multi-Port Monitor web interface indicates that Database Status is DOWN, and the database cannot be restarted, it is corrupted.

Database corruption typically occurs when the CA Multi-Port Monitor experiences a power outage or hardware hang.

Important: When you recreate the Vertica metrics database, all Session data is lost. Session data appears in the Analysis tab of the Multi-Port Monitor web interface.

Before you recreate the Vertica metrics database, verify:

The System Status page of the CA Multi-Port Monitor web interface indicates that Database Status is DOWN. You do not need to recreate the Vertica metrics database if its status is UP.
Assess the XFS file system for corruption on the /nqxfs partition, and if necessary, repair the XFS file system. Note that the XFS file system repair fails when the XFS file system is corrupted.
Assess and recover from SCSI disk errors.

Estimated time to recreate database: 5 minutes

Follow these steps:

Open a command prompt.
Stop all CA Multi-Port Monitor daemon processes:
```
sudo /opt/NetQoS/scripts/stopprocs.sh
```

Recreate the Vertica DB:

sudo /opt/NetQoS/install/setupVertica.sh  --new
sudo /opt/NetQoS/install/setupReplicateMySqlToVertica.sh

Start all the CA Multi-Port Monitor daemon processes:
```
sudo  /opt/NetQoS/scripts/startprocs.sh
```
Use the System Status page of the CA Multi-Port Monitor web interface to verify the Database Status of the Metrics database is UP.

More information:

Assess and Recover SCSI Disk Corruption