dadaemon and vertica don't auto-restart after reboot

Document ID : KB000048380
Last Modified Date : 17/05/2018
Show Technical Document Details
Introduction:

Description:

dadaemon and vertica not auto-restarting after a reboot. In the adminTools tool, user has verified that the vertica config is set to auto-restart.

Solution:

From the install guide - in case you don't have it handy. (With some handy highlights)

You can set up autostart on the data repository. If autostart is set up and you reboot the computer where the data repository is installed, the data repository starts automatically.

Data Aggregator stops automatically when the data repository becomes inaccessible. Restart Data Aggregator manually once the data repository is online again.

Note: Use a Bash shell to follow the steps in this procedure

 

  1. Type the following command to become the Linux user account for the database administrator user:

    su - dradmin                                                                                                                                                                                                                                            
  2. Be sure that the Linux user account for the database administrator user is set up with a passwordless ssh key:
     
    1. Type the following command to see if a passwordless ssh key is already set up:

      ssh hostname ls hostname
      Indicates the name of the host where the data repository is installed.
      If the passwordless ssh key is set up, you are not prompted for a password. You do not need to do anything further. However, if you are asked if you want to continue connecting, enter Yes.
       
    2. If you are prompted for a password, ignore the prompt and hit Ctrl+C. Type the following commands to set up the Linux user account for the database administrator user with a passwordless ssh key, pressing Enter after each line:

      ssh-keygen -N "" -t rsa -f ~/.ssh/id_rsa
      cp ~/.ssh/id_rsa.pub ~/.ssh/authorized_keys2 chmod 644 ~/.ssh/authorized_keys2

      Retype the following command to confirm that you are not prompted for a password:

      ssh hostname ls hostname
      Indicates the name of the host where the data repository is installed.

      Important! If you do not set up the passwordless ssh key, you cannot configure autostart on the data repository.
       
  3. Type the following command:

    /opt/vertica/bin/adminTools

    The Administration Tools dialog opens.
     
  4. Select (6) Configuration Menu and select OK.
     
  5. Select (4) Set Restart Policy and select OK.

    The Select Database dialog opens.
     
  6. Select the database name and select OK.

    The Select policy dialog opens.
     
  7. Select (always) and select OK. 'Always' means that upon the system restarting, the data repository automatically restarts.

    Note: In a cluster installation, keep this setting as ksafe so that the data repository only comes online when other hosts in the cluster are active.

    The Restart Policy setting is saved.
     
  8. Select OK to close the Select policy dialog.
     
  9. Return to the (M) Main Menu.
     
  10. Select (E) Exit.
     
  11. (Optional) Test that the data repository starts when you reboot the computer where the data repository is installed:
     
    1. Reboot the computer where the data repository is installed.

      Note: You may need to log in as the root user or sudo user to reboot the computer.
       
    2. Type the following command:

      /opt/vertica/bin/adminTools

      The Administration Tools dialog opens.
       
    3. Select (1) View Database Cluster State and select OK. d. The state is "UP." Select OK.

      Note: The data repository can take several minutes to start up after you reboot.
Instructions:
Please Update This Required Field