Pivotal Greenplum® Command Center 6.4 Release Notes
Updated 2021-Feb-5
About This Release
This document contains release information about Pivotal Greenplum Command Center 6.4. Greenplum Command Center 6.4 provides management and monitoring functionality for Pivotal Greenplum Database 6.
This topic contains release notes for Greenplum Command Center 6.4.
Supported Platforms
Greenplum Command Center 6.4 is compatible with the following platforms.
- Pivotal Greenplum Database 6.x.
- Red Hat Enterprise Linux 6.x1 and 7.x
- CentOS 6.x1 and 7.x
- SUSE Enterprise Linux 12
- Ubuntu 18.04
See Pivotal Greenplum Command Center Supported Platforms for the most current compatibility information.
Enhancements and Changes in Greenplum Command Center 6.4
New and Changed Features
The History page now contains a new Advanced Search tool. The tool allows users to search based on query metrics such as custom time range, query text, database name, user name, and more. Selecting “Custom” from the Time Range dropdown also displays the Advanced Search pop-up window. For more information see the Query History documentation page.
The Query details page now displays the query cost when clicking on the “+” sign next to the query Planner name. The submitted time now inludes a tooltip which displays the query’s submitted date. See Query History Metrics for more details.
Greenplum Command Center now supports IPV6. To install an IPV6-compatible version of Greenplum Command Center, pass the new
-ipv6
parameter to thegpccinstall
command. To enable IPv6, you must set theHTTPAddr
configuration parameter in the$GPCC_HOME/conf/app.conf
file to the IPv6 address of the host Command Center is running on.The
stats_check_interval
parameter is now set in thegpcc.conf
file rather than theapp.conf
file. If you currently have it set inapp.conf
, you must reset it ingpcc.conf
; the value inapp.conf
will be ignored.Command Centre now displays a Notifications label at login. Clicking on the label displays the Alerts window with alert history from the last 7 days. For more information, see the Alerts documentation page.
The Table Browser page has a new Advanced search link to allow administrators to filter their search based on table name, table size, or table owners. The results can be exported to a local file. See the Table Browser documentation page for more details.
The
gpmetrics
schema contains a newgpcc_export_log
table that records the log notifications from the “EXPORT ALL” dropdown in the Query History or the Table Browser page.
Thegpcc_alert_log
table has been renamed togpcc_alert_history
and includes a newconfig
column that records the alert history from the Notification Center or from email alerts.
The tablegpcc_alert_rule
has been discontinued.
For more information , see the gpmetrics Schema Reference documentation page.The Command Center dashboard now displays a Feedback link, which displays a customer feedback form when clicked. Administrators can enter feedback for current Command Center features and experience. The form requires internet connectivity for the pop-up to appear.
Command Center now aggregates and displays a single alert notification when multiple segment failures occur at the same time.
Users can now customize security parameters in the
app.conf
file. For more details, see Setting Security Parameters.
Fixed Issues
31026 - Resolved an issue where Greenplum Command Center version 6.3.0 and 6.3.1 would not show a visual query plan in the query monitor in certain cases. Upgrade the
metrics_collector
if your Greenplum Database version is below 6.12.1.31061 - When a query ran less than 5 seconds, the CPU and Disk I/O were not captured. This issue has been resolved.
Known Issues
The following are known issues in the current Greenplum Command Center release.
Requirement for a trusted certificate, even when insecure authentication is enabled
When the “Allow insecure authentication” setting is enabled, but the email protocol is STARTTLS, Command Centre ignores the setting and still expects a trusted certificate.
Command Centre requires restart after Daylight Savings Time
When Daylight Saving Time occurs, Command Center requires a restart to repopulate certain data metrics.
Last Accessed column affected by persistent table rebuild
When using the gppersistentrebuild
utility, the Last Accessed column in the Table Browser view might be refreshed, although no queries accessed the tables.
Limitation for Defining Planner Cost in Workload Rules
When you define a workload management rule that uses the Planner Cost condition, the input field transforms your entry to a double datatype value. This can limit the ability to accurately define large planner costs that may be necessary for the GPORCA optimizer. For example, if you enter the GPORCA maximum cost value as 1457494496834852608, the actual value is converted to 1457494496834852600 for the rule. The value shown in the completed rule definition is the value that the rule enforces, and it may not be the exact value that you entered. Increase the cost value as necessary to cover the cost you want to set as the maximum.
External Updates to Workload Management Rules are Delayed
If you recreate the gp_wlm
extension from outside of Command Center after you have already created workload management rules using the Command Center interface, the rules engine may not run for a period of roughly 1 hour. This behavior occurs because Command Center checks for the availability of the extension every hour. Any changes you make outside of Command Center in this situation will not be visible until Command Center checks for the extension, or until you login to Command Center and access the Workload> Workload Mgmt page.
Customized SSH Path Not Supported with the Upgrade (-u) Option
If you upgrade your Command Center installation using the gpccinstall -u
option and you also specify an SSH binary using the -ssh-path <path>
option, the customized SSH path will not be used during the installation and the ssh_path
parameter will not be set in the app.conf
file.
Calculated Root Table Size Inaccurate for Some Partitioned Tables
When viewing the Table Browser view, the calculated size for a partitioned table is incorrect if some child partitions are in different schemas than the root table.
Sorting Tables by Size on Partition List Page is Slow
If there are a large number of tables in a schema in a database, sorting the partition table list by size can take a long time to display.