Vertica does not start on node, after host reboot

Grzegorz

I have Vertica 7.0 Community version installed on 3 RedHat nodes cluster, K-Safety = 1.
In case of one node reboot, after system is back up, I want to have vertica restarted automatically on the node.

I checked Restart Policy with values of 'ksafe' and 'always' but it does not work - after system is back up
state of node remain DOWN until manually interventions.

Fault tolerance is 1:
dbadmin=> select designed_fault_tolerance, current_fault_tolerance from system;
 designed_fault_tolerance | current_fault_tolerance
--------------------------+-------------------------
 1                        | 1
(1 row)

Please advice why node is not automatically restarted after node restart.

Thanks

Greg

Curtis_1

You might need to script this out in a node startup script. 

Everything you do with admintools, you can script.  Check here:

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/AdminTools/WritingAdministrationToolsScripts.htm?Highlight=admintools script

Grzegorz

Hi Curtis,
Thank you for your answer,

So how the restart policy works?
Setting restart policy to 'ksafe' or 'always' I expected it should restart Vertica on node after node reboot.

Please clarify

Thank you

saumya_tamma

Greg,


"The Restart Policy enables you to determine whether or not nodes in a K-Safe database are automatically restarted when they are rebooted. Since this feature does not automatically restart nodes if the entire database is DOWN, it is not useful for databases that are not K-Safe."

I think the restart is automatic when database is still running and one of the node is down

if the whole database is down or if its not ksafe then the restart of database is not automatic on node reboot.

Thanks
Saumya