VMware Greenplum Command Center 7.x Release Notes

This document contains release information about VMware Greenplum Command Center 7.x releases. Greenplum Command Center 7.x provides management and monitoring functionality for VMware Greenplum 7.x.

Supported Platforms

Greenplum Command Center 7 is compatible with the following platforms.

VMware Greenplum 7.x
Red Hat Enterprise Linux 64-bit 8.7+
Oracle Linux 64-bit 8.7+, using the Red Hat Compatible Kernel (RHCK)

See VMware Greenplum Command Center Supported Platforms for the most current compatibility information.

Release 7.1.1

Release Date: 2024-05-31

VMware Greenplum Command Center 7.1.1 is a minor release that resolves several issues.

Resolved Issues

N/A: Resolves an issue where more than one agent could start on the same host because GPCC’s agent manager did not correctly filter the duplicate hosts. This led to errors caused by multiple agents running simultaneously on one host.
N/A: Resolves an issue when Greenplum Database executed queries containing user-defined functions (UDFs) with CREATE TABLE AS SELECT statements as inner queries, it could cause memory leaks in GPCC and results in queries remaining in GPCC memory, and was not deleted. Additionally, such queries could be erroneously recorded with an unknown status in the history.
N/A: Resolves an issue where Red Hat 8 did not have the default Kerberos library symlink if the development package was not installed, which caused GPCC’s Kerberos authentication to fail.
N/A: Resolves an issue where the recommendation API did not correctly handle malformed parameters, leading to potential errors.
N/A: Resolves an issue where GPCC could encounter an extra data after last expected column error while loading plannode data into history.
N/A: Resolves an issue where the gpmetrics.gpcc_canary_queries table could not be created when Greenplum’s default configuration had appendonly set to true.
N/A: Resolves an issue where GPCC could not be installed if the short hostname of a segment host could not be resolved by the coordinator host.
N/A: Resolves an issue where GPCC will display both MEMORY LIMIT and MEMORY QUOTA correctly in the resource group page.

Release 7.1.0

Release Date: 2024-04-09

VMware Greenplum Command Center 7.1.0 is a minor release that includes new and changed features and resolves several issues.

New and Changed Features

The web server configuration file $GPCC_HOME/conf/app.conf now supports the new parameter XSRFExpire = $number, which determines the session time in seconds. By setting this parameter, Command Center sessions will end following $number seconds of user inactivity.
Command Center now supports canary queries, a periodic SQL statement used to monitor database response times and workload. Users can use the default canary query or create their own. These canary queries are accessible and manageable on the Cluster Metrics page, given that resource groups are enabled.
The gpmetrics Configuration File Reference now supports the following new parameters:
- process_history_interval: Specifies the frequency at which Command Center displays process history.
- filesize_threshold: Sets the maximum size, in GB, of a single *.dat file in ccdata.
- allow_self_only_see_others_query_info: Determines whether users can view queries initiated by others in Command Center.
  - When set to true (default), users can see queries initiated by both themselves and other users.
  - When set to false, users with self-only access can only view their own query information and session details.
Cluster Metrics, Query History and Host Metrics in Cluster Realtime Status can now display details about committed memory in addition to memory.
Users can now activate the following alerts from the Alerts tab of the Command Center Admin view:
- The Command Center temporary files in $GPCC_HOME/ccdata and $GPCC_HOME/query_text exceed a specified limit on any Greenplum host.
- Committed Memory exceeds a specified limit.
In the Cluster Metrics view, a Committed Memory option is available in the View Charts dropdown menu. This allows users to toggle the inclusion of Committed Memory graphs in the Cluster Metrics view.
Command Center has enhanced the performance of history table purging by dropping unused partitions.
When selecting only one resource group on the Resource Group Monitor page, the graph displays CPU Max Percent instead of CPU Limit.
The Resource Group Settings view includes a new Disk I/O Settings section for managing disk I/O limits, supporting both default and customized I/O limit values. For more information about disk I/O limits, see VMware Greenplum documentation.
Advanced Search in Query Monitor, Table Browser and Query History now offers enhanced capabilities for more powerful searching. It now supports:
- Selecting multiple databases in Query History and Query Monitor.
- Filtering search results by using query text in Query History. When searching queries by query text, normal text input triggers “ILIKE” style matching; input enclosed in slashes “/” activates regular expression matching.
- Filtering search results by including or excluding the queries that match the query text.
- Filtering search results by excluding canary queries in Query History.
- Filtering search results by query tag, status and query ID in Query Monitor and Query History.
Command Center now saves the ps command output from each host into a new history table under the gpmetrics schema at intervals of every five minutes.
Command Center now collects and records some performance indicators of a system process called “kswapd” on each host, aiding in troubleshooting memory-related issues. The gpmetrics.gpcc_system_history table is updated with the new columns for these indicators.

Resolved Issues

370009: Resolves an issue where, when gpmon started up the Command Center, the Query Details page did not display CPU and memory usage.
N/A: Resolves an issue where a completed query’s status was not correctly displayed when the Query Monitor was paused.
N/A: Resolves an issue where Command Center agent left some 0-size gpcc_exec_xxxx_xxxxxxxx.dat files in the $GPCC_HOME/ccdata directory.
N/A: Resolves an issue where some slice IDs displayed in the visual query plan were incorrect.

Release 7.0.0

Release Date: 2023-11-1

VMware Greenplum Command Center 7.0.0 is the first release of VMware Greenplum Command Center, introducing support for VMware Greenplum 7.

Features

The Resource Group Settings page was updated to support creating and editing Resource Groups with VMware Greenplum 7. See Resource Groups.
The gpmetrics.gpcc_resgroup_history table was updated for Greenplum 7 Resource Groups compatibility. Compared to previous 6.x releases of Greenplum Command Center, this table removes the columns: segid, cpu_rate_limit, cpu_usage_percent, mem_used_mb, mem_available_mb, mem_quota_used_mb, mem_quota_available_mb, mem_quota_granted_mb, mem_quota_proposed_mb, mem_shared_used_mb, mem_shared_available_mb, mem_shared_granted_mb, and mem_shared_proposed_mb. The following columns are added: host_name, cpu_max_percent, cpu_weight, memory_limit, cpu_usage, memory_usage. See gpcc_resgroup_history.
The user interface for the Administration > Authentication page was updated to more easily edit the pg_hba.conf file contents. Changes to the file can now be synched to the standby coordinator using Command Center. See Managing Greenplum Command Center Authentication.
The gpcc_queries_history and gpcc_plannode_history tables are now partitioned by day, instead of by month, for optimal performance. Existing month partitions are not changed.
Command Center 7 has the capability of generating core dump files in the event of a crash. See Core Dump in the VMware Greenplum documentation for instructions to enable core dumps on RHEL systems.
Command Center 7 now handles changes to Daylight Savings Time automaticallly; you do not need to restart Command Center for changens to take effect.
The Greenplum Command Center enable_history option is now configured in gpcc.conf instead of in app.conf.