This article describes how a Vertica startup issue in the QA environment was resolved by modifying the cluster_config.json file from the daily restore archive. The resolution involved removing all S3 location entries from the configuration file.
Environment
- Vertica Database
- QA environment
- Daily archive restore location
cluster_config.jsonfile
Situation
Vertica failed to start in the QA environment following a restore operation. Investigation revealed that the issue was related to the contents of the cluster_config.json file.
Cause
The presence of outdated or invalid S3 location entries in the cluster_config.json file from the restore archive caused Vertica to fail during startup.