We are using the vertica db, but last two days we are the getting the following message when we tried to start the database. Please suggest how can we resolve this issue ASAP .
Question
Unable to read database catalogs - cannot start database.
+2- Does the catalog directory accessible to Vertica on all nodes?
- Is it mounted as it should? (Try to mount again the volume)
- Does the catalog dir path is owned by dbadmin (or your Vertica super user) on all nodes?
- What is the message you get in vertica.log after /opt/vertica/bin/admintools -t start_db -d -F
tail -f catalog-path/database-name/node-name_catalog/vertica.log - If database fails to start before it can write messages into vertica.log check
catalog-path/database-name/dbLog
** /opt/vertica/log/adminTools.log**
/opt/vertica/log/adminTools.errors - If the problem persists please open a support ticket.
Run the following command :
ssh IP address of the node
I had the same issue and this worked for me.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
