Hive Metastore Server Health Tests

Hive Metastore Server Audit Pipeline Test

This Hive Metastore Server health test checks that the Auditing for the Hive Metastore Server role is getting processed correctly and is not blocked. A failure of this health test may indicate a problem with the audit pipeline of Hive Metastore Server process. This test can fail either because the Cloudera Audit Server is not accepting audits, or the Cloudera Manager Agent on the Hive Metastore Server host isn't able to send audits because of some network issue. Check the Cloudera Manager Agent logs and Cloudera Audit Server logs for more details. This test can be enabled or disabled using the Navigator Audit Pipeline Health Check Hive Metastore Server monitoring setting.

Short Name: Audit Pipeline Test

Monitoring Period For Audit Failures

Description
The period to review when checking if audits are blocked and not getting processed.
Template Name
mgmt_navigator_failure_window
Default Value
20
Unit(s)
MINUTES

Navigator Audit Failure Thresholds

Description
The health test thresholds for failures encountered when monitoring audits within a recent period specified by the mgmt_navigator_failure_window configuration for the role. The value that can be specified for this threshold is the number of bytes of audits data that is left to be sent to audit server.
Template Name
mgmt_navigator_failure_thresholds
Default Value
critical:any, warning:never
Unit(s)
BYTES

Navigator Audit Pipeline Health Check

Description
Enable test of audit events processing pipeline. This will test if audit events are not getting processed by Audit Server for a role that generates audit.
Template Name
mgmt_navigator_status_check_enabled
Default Value
true
Unit(s)
no unit

Hive Metastore Server Compaction System Health Check

This is compaction system health test that checks whether compaction processes are properly configured and operational. Failure of this health test could indicate a problem with the compaction that could severely degrade query performance. Use the guidelines below for troubleshooting.
  • Oldest initiated compaction passed threshold: Check the last successful compactions in the SYS.COMPACTION view. If no compactions have finished recently, check the logs for errors in the Worker threads for either the Compactor Virtual Warehouse or in the DataHub clusters, if applicable. If compactions are running successfully, but there are many queued compactions, increase the number of Worker threads set for 'hive.compactor.worker.threads' in the Compactor Virtual Warehouse or DataHub clusters. Alternatively, you can increase the amount of available resources
  • Large number of compaction failures:
    1. Run SELECT * FROM SYS.COMPACTIONS WHERE C_STATE IN ("failed, "did not initiate"); to check the error message in the sys.compaction table.
    2. Check the logs in the Compactor Virtual Warehouse for the "Caught exception while trying to compact" message.
This test can be configured using the Hive Compaction Health Test Hive monitoring settings.

Short Name: Compaction System Health Check

Failed Compaction Thresholds

Description
The health test thresholds for the number of failed compactions.
Template Name
hive_compaction_failed_thresholds
Default Value
critical:never, warning:1.0
Unit(s)
PERCENT

Hive Compaction Health Test

Description
Enables the health test that checks whether compaction processes are properly configured and operational.
Template Name
hive_compaction_health_check_enabled
Default Value
false
Unit(s)
no unit

Oldest Initiated Compaction Thresholds

Description
The health test thresholds for the oldest initiated compaction.
Template Name
hive_compaction_oldest_initiated_thresholds
Default Value
critical:43200.0, warning:3600.0
Unit(s)
SECONDS

Hive Metastore Server File Descriptors

This Hive Metastore Server health test checks that the number of file descriptors used does not rise above some percentage of the Hive Metastore Server file descriptor limit. A failure of this health test may indicate a bug in either Hadoop or Cloudera Manager. Contact Cloudera support. This test can be configured using the File Descriptor Monitoring Thresholds Hive Metastore Server monitoring setting.

Short Name: File Descriptors

File Descriptor Monitoring Thresholds

Description
The health test thresholds of the number of file descriptors used. Specified as a percentage of file descriptor limit.
Template Name
hivemetastore_fd_thresholds
Default Value
critical:70.0, warning:50.0
Unit(s)
PERCENT

Hive Metastore Server Heap Dump Directory Free Space

This Hive Metastore Server health test checks that the filesystem containing the heap dump directory of this Hive Metastore Server has sufficient free space. This test can be configured using the Heap Dump Directory Free Space Monitoring Absolute Thresholds and Heap Dump Directory Free Space Monitoring Percentage Thresholds Hive Metastore Server monitoring settings.

Short Name: Heap Dump Directory Free Space

Heap Dump Directory Free Space Monitoring Absolute Thresholds

Description
The health test thresholds for monitoring of free space on the filesystem that contains this role's heap dump directory.
Template Name
heap_dump_directory_free_space_absolute_thresholds
Default Value
critical:5.36870912E9, warning:1.073741824E10
Unit(s)
BYTES

Heap Dump Directory Free Space Monitoring Percentage Thresholds

Description
The health test thresholds for monitoring of free space on the filesystem that contains this role's heap dump directory. Specified as a percentage of the capacity on that filesystem. This setting is not used if a Heap Dump Directory Free Space Monitoring Absolute Thresholds setting is configured.
Template Name
heap_dump_directory_free_space_percentage_thresholds
Default Value
critical:never, warning:never
Unit(s)
PERCENT

Hive Metastore Server Hive Metastore Canary

This is a Hive Metastore health test that checks that a client can connect and perform basic operations. The operations include: (1) creating a database, (2) creating a table within that database with several types of columns and two partition keys, (3) creating a number of partitions, and (4) dropping both the table and the database. The database is created under the /user/hue/.cloudera_manager_hive_metastore_canary/<Hive Metastore role name>/ and is named "cloudera_manager_metastore_canary_test_db". The test returns "Bad" health if any of these operations fail. The test returns "Concerning" health if an unknown failure happens. The canary publishes a metric 'canary_duration' for the time it took for the canary to complete. Here is an example of a trigger, defined for the Hive Metastore role configuration group, that changes the health to "Bad" when the duration of the canary is longer than 5 sec: "IF (SELECT canary_duration WHERE entityName=$ROLENAME AND category = ROLE and last(canary_duration) > 5s) DO health:bad" A failure of this health test may indicate that the Hive Metastore is failing basic operations. Check the logs of the Hive Metastore and the Cloudera Manager Service Monitor for more details. This test can be enabled or disabled using the Hive Metastore Canary Health Test Hive Metastore monitoring setting.

Short Name: Hive Metastore Canary

Hive Metastore Canary Health Test

Description
Enables the health test that checks that basic Hive Metastore operations succeed
Template Name
metastore_canary_health_enabled
Default Value
true
Unit(s)
no unit

Hive Metastore Server Host Health

This Hive Metastore Server health test factors in the health of the host upon which the Hive Metastore Server is running. A failure of this test means that the host running the Hive Metastore Server is experiencing some problem. See that host's status page for more details.This test can be enabled or disabled using the Hive Metastore Server Host Health Test Hive Metastore Server monitoring setting.

Short Name: Host Health

Hive Metastore Server Host Health Test

Description
When computing the overall Hive Metastore Server health, consider the host's health.
Template Name
hivemetastore_host_health_enabled
Default Value
true
Unit(s)
no unit

Hive Metastore Server Log Directory Free Space

This Hive Metastore Server health test checks that the filesystem containing the log directory of this Hive Metastore Server has sufficient free space. This test can be configured using the Log Directory Free Space Monitoring Absolute Thresholds and Log Directory Free Space Monitoring Percentage Thresholds Hive Metastore Server monitoring settings.

Short Name: Log Directory Free Space

Log Directory Free Space Monitoring Absolute Thresholds

Description
The health test thresholds for monitoring of free space on the filesystem that contains this role's log directory.
Template Name
log_directory_free_space_absolute_thresholds
Default Value
critical:5.36870912E9, warning:1.073741824E10
Unit(s)
BYTES

Log Directory Free Space Monitoring Percentage Thresholds

Description
The health test thresholds for monitoring of free space on the filesystem that contains this role's log directory. Specified as a percentage of the capacity on that filesystem. This setting is not used if a Log Directory Free Space Monitoring Absolute Thresholds setting is configured.
Template Name
log_directory_free_space_percentage_thresholds
Default Value
critical:never, warning:never
Unit(s)
PERCENT

Hive Metastore Server Pause Duration

This Hive Metastore Server health test checks that the Hive Metastore Server threads are not experiencing long scheduling pauses. The test uses a pause monitoring thread in the Hive Metastore Server that tracks scheduling delay by noting if it is run on its requested schedule. If the thread is not run on its requested schedule, the delay is noted and considered pause time. The health test checks that no more than some percentage of recent time is spent paused. A failure of this health test may indicate that the Hive Metastore Server is not getting enough CPU resources, or that it is spending too much time doing garbage collection. Inspect the Hive Metastore Server logs for any pause monitor output and check garbage collection metrics exposed by the Hive Metastore Server. This test can be configured using the Pause Duration Thresholds and Pause Duration Monitoring Period Hive Metastore Server monitoring settings.

Short Name: Pause Duration

Pause Duration Monitoring Period

Description
The period to review when computing the moving average of extra time the pause monitor spent paused.
Template Name
hivemetastore_pause_duration_window
Default Value
5
Unit(s)
MINUTES

Pause Duration Thresholds

Description
The health test thresholds for the weighted average extra time the pause monitor spent paused. Specified as a percentage of elapsed wall clock time.
Template Name
hivemetastore_pause_duration_thresholds
Default Value
critical:60.0, warning:30.0
Unit(s)
no unit

Hive Metastore Server Process Status

This Hive Metastore Server health test checks that the Cloudera Manager Agent on the Hive Metastore Server host is heart beating correctly and that the process associated with the Hive Metastore Server role is in the state expected by Cloudera Manager. A failure of this health test may indicate a problem with the Hive Metastore Server process, a lack of connectivity to the Cloudera Manager Agent on the Hive Metastore Server host, or a problem with the Cloudera Manager Agent. This test can fail either because the Hive Metastore Server has crashed or because the Hive Metastore Server will not start or stop in a timely fashion. Check the Hive Metastore Server logs for more details. If the test fails because of problems communicating with the Cloudera Manager Agent on the Hive Metastore Server host, check the status of the Cloudera Manager Agent by running /etc/init.d/cloudera-scm-agent status on the Hive Metastore Server host, or look in the Cloudera Manager Agent logs on the Hive Metastore Server host for more details. This test can be enabled or disabled using the Hive Metastore Server Process Health Test Hive Metastore Server monitoring setting.

Short Name: Process Status

Hive Metastore Server Process Health Test

Description
Enables the health test that the Hive Metastore Server's process state is consistent with the role configuration
Template Name
hivemetastore_scm_health_enabled
Default Value
true
Unit(s)
no unit

Hive Metastore Server Swap Memory Usage

This Hive Metastore Server health test checks the amount of swap memory in use by the role. A failure of this health test may indicate that your machine is overloaded. This test can be configured using the Process Swap Memory Thresholds monitoring settings.

Short Name: Swap Memory Usage

Process Swap Memory Thresholds

Description
The health test thresholds on the swap memory usage of the process. This takes precedence over the host level threshold.
Template Name
process_swap_memory_thresholds
Default Value
critical:never, warning:200.0
Unit(s)
BYTES

Hive Metastore Server Swap Memory Usage Rate Beta

This Hive Metastore Server health test checks the change of the amount of swap memory usage by the role during a predefined period. A failure of this health test may indicate that your machine is overloaded. This test can be configured using the Swap Memory Usage Rate Thresholds and Swap Memory Usage Rate Window monitoring settings.

Short Name: Swap Memory Usage Rate Beta

Swap Memory Usage Rate Thresholds

Description
The health test thresholds on the swap memory usage rate of the process. Specified as the change of the used swap memory during the predefined period.
Template Name
process_swap_memory_rate_thresholds
Default Value
critical:never, warning:never
Unit(s)
BYTES

Swap Memory Usage Rate Window

Description
The period to review when computing unexpected swap memory usage change of the process.
Template Name
process_swap_memory_rate_window
Default Value
5
Unit(s)
MINUTES

Hive Metastore Server Unexpected Exits

This Hive Metastore Server health test checks that the Hive Metastore Server has not recently exited unexpectedly. The test returns "Bad" health if the number of unexpected exits exceeds a critical threshold. For example, if this test is configured with a critical threshold of 1, this test returns "Good" health if there have been no unexpected exits recently. If 1 or more unexpected exits occured recently, this test returns "Bad" health. The test also indicates whether any of the exits were caused by an OutOfMemory error if the Cloudera Manager Kill When Out of Memory monitoring setting is enabled. This test can be configured using the Unexpected Exits Thresholds and Unexpected Exits Monitoring Period Hive Metastore Server monitoring settings.

Short Name: Unexpected Exits

Unexpected Exits Monitoring Period

Description
The period to review when computing unexpected exits.
Template Name
unexpected_exits_window
Default Value
5
Unit(s)
MINUTES

Unexpected Exits Thresholds

Description
The health test thresholds for unexpected exits encountered within a recent period specified by the unexpected_exits_window configuration for the role.
Template Name
unexpected_exits_thresholds
Default Value
critical:any, warning:never
Unit(s)
no unit