Managing Kinetica Services

Typical maintenance of the system may require starting & stopping of database services. The instructions for that are provided here:

• Start Database Services
• Stop Database Services

During a Kinetica system upgrade or other major system administration event, all Kinetica services may need to be started & stopped. The instructions for that are provided here:

• Start System Management Processes
• Stop System Management Processes

A variety of service status checks are available for assessing the health of the system and troubleshooting.

Start Database Services

The following database services can be started via GAdmin or command-line:

• Database
  • httpd
  • ODBC Server
  • Text Search
• Reveal

GUI Startup

1. Log in to GAdmin
2. Click Admin on the left menu
3. Click Start
4. On the Start Service? pop-up, click Start
5. Click Continue when the database has started

Command-Line Startup

Run the following as the root user:

service gpudb start

Note

This will, in turn, start system management processes, as well

Verify that Kinetica is running by browsing to http://<yourhostname>:8080/gadmin

Stop Database Services

The following database services can be stopped via GAdmin or command-line:

• Reveal
• Database
  • httpd
  • ODBC Server
  • Text Search

GUI Stop

1. Log in to GAdmin
2. Click Admin on the left menu
3. Click Stop
4. On the Stop Service? pop-up, click Stop
5. Click Continue when the database has stopped

Command-Line Stop

Run the following as the root user:

service gpudb stop

Start System Management Processes

To start all system management processes:

• Host Manager
• GAdmin
• Stats Services

Run the following as the root user:

service gpudb_host_manager start

Stop System Management Processes

To stop database services and all system management processes:

• GAdmin
• Stats Services
• Host Manager

Run the following as the root user:

service gpudb_host_manager stop

Note

This will, in turn, stop database services, as well

System Status Checks

There are several means to check the status of system components:

• Processes
• GAdmin
• API

Processes

To check the status of the database processes:

• Host Manager
• GAdmin
• Stats Services
• Database
  • httpd
  • ODBC Server
  • Text Search
• Reveal

Run the following as the root or gpudb user:

service gpudb status

GAdmin

The Kinetica Administration Application (GAdmin) provides a GUI for monitoring various aspects of the system:

• Cluster Health
• Running Jobs
• Information & Diagnostics

API

To determine whether the REST endpoint services are operating, the Python API can be invoked, as follows:

$ python /opt/gpudb/api/python/gpudb/gadmin_sim.py
**********************
Total tables:              0
Total top-level tables:    0
Total collections:         0
Total number of elements:  0
Total number of objects:   0

Statuses

The tables below list the various statuses you could experience in GAdmin or in logs for the system itself, the nodes and ranks employed by the system, or all three.

Important

It's likely you won't see many of the node and rank statuses in GAdmin as they are transient and only last for a few seconds during start up or shut down.

System

Status	Description
Init	The INIT signal has been received and the system is initializing
Rebalancing	The system is rebalancing data due to the addition/subtraction of ranks
Running	The system is up and available for requests
Shutdown	The system has shut down and is not available
Starting	The system is in the process of starting up
Stopped	The system has stopped all requests and is preparing for shutdown
System Limited	Something is interfering with the systems's ability to communicate between all ranks

Node

Status	Description
Enum Hardware	The node is processing the hardware being used and checking the license
Establishing Cluster	The node is ensuring its connection to the system and the other hosts in the cluster
Fatal Init Error	An error occurred while validating the gpudb.conf configuration file
Init	The INIT signal has been received and the node is initializing
Parsed Conf	The node has parsed configuration files for any changes
Post	The node has started and informed the system
Ready	The node has successfully shutdown and is ready to be started
Running	The node is up and available for requests
Shutdown	The node has shut down and is not available
Shutting Down	The node is in the process of shutting down and will not take requests
Started	The node has been started and is nearly ready for requests
Starting	The node is in the process of starting up
Stopping	The node is stopping all requests and preparing for shutdown
Validating Cluster	The node and any other nodes in the cluster are being validated by the system

Rank

Status	Description
Enum Hardware	The rank is processing the hardware being used and checking the license
Fatal Init Error	An error occurred while validating the gpudb.conf configuration file
Init	The INIT signal has been received and the rank is initializing
Initialized	The rank has been primed for start-up
Loaded Data	The rank has successfully loaded data from the persist directory(ies)
Loading Data	The rank is in the process of loading data from the persist directory(ies)
Not Responding	The rank is currently not responding to requests
Parsed Conf	The rank has parsed configuration files for any changes
Post	The rank has started and informed the system
Running	The rank is up and available for requests
Shutdown	The rank has shut down and is not available
Shutting Down	The rank is in the process of shutting down and will not take requests
Start	The rank has received a start signal
Started	The rank has been started and is nearly ready for requests
Starting	The rank is in the process of starting up
Syncing	The rank is in the process of syncing types, tables, records, etc.
Terminated	The rank has encountered an error and was terminated; the rank will often restart if possible