Unable to start the Vertica database

Article Id: 37369
Status: Published
Updated On: 19-05-2020 14:07
Legacy Id: TEC1744084
Products:
CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration
Issue/Introduction:

Unable to start the Vertica database

Environment:

Release: PM 3.7
Component:

Resolution:

To get a valid epoch to perform the following steps:

  1. cd /opt/vertica/bin
  2. Run the following command: ./admintools -t start_db -d <DB name> -F
  3. The above command will likely fail but the act of attempting a "force" repair of the Vertica database will put an Epoch.log in the catalog directory.  This would be the same directory that contains the vertica.log
  4. Take the hexidecimal number in Epoch.log and convert it to a decimal number.  You can use the following URL to make the conversion: http://www.binaryhexconverter.com/hex-to-decimal-converter
  5. Now open adminTools on the Data Repository
    • Choose #7 Advanced Menu
    • Choose #1 RollBack Database To Last Good Epoch
    • Choose the database in question
    • Add the converted number from step #4 into the "Restart epoch" field
    • Choose OK
  6. The database should now start successfully