Restart the Data Repository

Restart the Data Repository when required, such as for the following reasons:
capm360
Restart the data repository when required, such as for the following reasons:
  • The data repository host loses power or locks up.
  • The data repository host is relocated.
  • You install an operating system patch.
This procedure includes a restart of the data aggregator.
For more information, see Restart the Data Aggregator.
If you try to restart one data repository node before another restarted node has completely rejoined the cluster, the whole cluster can go down. The cluster does not come back up until you manually start it.
Stop the Data Aggregator
Before you shut down the data repository, stop the data aggregator. In an environment with fault-tolerant data aggregators, put the inactive data aggregator and then the active data aggregator into maintenance mode.
Follow these steps:
  1. Log in to the data aggregator host as the root user or a sudo user.
  2. Do one of the following steps:
    • Stop the Data Aggregator service by issuing the following command:
      service dadaemon stop
      For RHEL 7.x,
      service
      invokes
      systemctl
      . You can use
      systemctl
      instead.
    • (Fault-tolerant environment) Issue one of the following commands to shut down the inactive data aggregator and prevent it from restarting. Then run the command on the active data aggregator:
      • RHEL 6.x:
        service dadaemon maintenance
      • RHEL 7.x, SLES, OL:
        DA_Install_Directory
        /scripts/dadaemon maintenance
Shut Down the Data Repository
Shut down the data repository in preparation for any required tasks (for example, applying a security patch).
If you try to restart a data repository node before another restarted node has completely rejoined the cluster, the whole cluster can go down. The cluster does not come back up until you manually start it.
Stop the Database
Follow these steps:
  1. Log in to the data repository host as the database administrator user.
  2. Open Vertica adminTools by issuing the following command:
    /opt/vertica/bin/adminTools
  3. Select
    (4) Stop Database
    .
  4. Select the database, select
    OK
    , and then press
    Enter
    on your keyboard.
  5. Provide the database password, and then press
    Enter
    on your keyboard.
    The data repository stops.
    If the data repository does not stop, select
    (2) Stop Vertica on Host
    from
    (7) Advanced Tools Menu
    .
  6. Select
    (E) Exit
    , and press
    Enter
    on your keyboard.
Stop Vertica on One Node in a Cluster
Follow these steps:
  1. With the Vertica adminTools open, select
    (7) Advanced Tools Menu
    .
  2. Select
    (2) Stop Vertica on Host
    .
  3. Select the node to stop, and then press
    Enter
    on your keyboard.
  4. Provide the database password, and then press
    Enter
    on your keyboard.
    The data repository on the node stops.
  5. Select
    (M) Main Menu
    , and then press
    Enter
    on your keyboard.
  6. Select
    (E) Exit
    , and then press
    Enter
    on your keyboard.
Start the Data Repository
After you complete required tasks, such as applying a security patch, restart the data repository.
To avoid the cluster from going down and having to manually restart it, ensure that other restarted nodes have completely rejoined the cluster before restarting a data repository node.
Start the Database
Follow these steps:
  1. With the Vertica adminTools open, select
    (3) Start Database
    .
  2. Select the database, select
    OK
    , and then press
    Enter
    on your keyboard.
    You are prompted for the database password.
  3. Provide the database password, and then press
    Enter
    on your keyboard.
    The Data Repository starts.
    If Vertica fails to start normally, try running the following command:
    /opt/vertica/bin/admintools -t restart_node -d
    dbname
    --hosts
    host_ip_address
    --force
  4. Select
    (E) Exit
    and press Enter.
Start a Node that is Down in a Cluster
Follow these steps:
  1. With the Vertica adminTools open, select
    (5) Restart Vertica on Host
    .
  2. Select the database, select
    OK
    . and then press
    Enter
    on your keyboard.
  3. Select the node to start, and then press
    Enter
    on your keyboard.
  4. Provide the database password, and then press
    Enter
    on your keyboard.
    The Data Repository on the node starts.
  5. Select
    (E) Exit
    , and then press
    Enter
    on your keyboard.
Start the Data Aggregator
After you start the data repository, start the data aggregator. In an environment with fault-tolerant data aggregators, activate each data aggregator.
Follow these steps:
  1. Do one of the following steps:
    • Start the Data Aggregator service:
      service dadaemon start
    • (Fault-tolerant environment) Run one the following commands to enable the fault-tolerant data aggregator so that it can start when necessary:
      • RHEL 6.x:
        service dadaemon activate
      • RHEL 7.x, SLES, OL:
        DA_Install_Directory
        /scripts/dadaemon activate
    The data aggregator starts and the system resumes normal operations.