Skip to main content

Vertica does not start on node, after host reboot

  • March 25, 2014
  • 3 replies
  • 18 views
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

    3 replies

    Curtis_1
    Forum|alt.badge.img
    • Curtis_1
    • Participating Frequently
    • March 27, 2014

    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
    • Grzegorz
    • Author
    • New Participant
    • March 27, 2014

    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
    Forum|alt.badge.img+1
    • saumya_tamma
    • Participating Frequently
    • November 7, 2014
    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement