This document contains release information about Tanzu Greenplum Command Center 6.8 releases. Greenplum Command Center 6.8 provides management and monitoring functionality for Tanzu Greenplum Database 6.

This topic contains release notes for Greenplum Command Center 6.8.

Supported Platforms

Greenplum Command Center 6.8 is compatible with the following platforms.

  • Tanzu Greenplum Database 6.x
  • Red Hat Enterprise Linux 6.x1, 7.x, and 8.x
  • CentOS 6.x1 and 7.x
  • Ubuntu 18.04

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

Release 6.8.4

Release Date: 2023-01-13

VMware Tanzu Greenplum Command Center 6.8.4 is a maintenance release that includes one new feature and resolves several issues.

New Feature

The gpmetrics configuration file -- gpcc.conf -- now includes a set of configuration parameters to customize and optimize the Command Center agents' query sampling behavior. For more information, see the gpmetrics Configuration File Reference.

Resolved Issues

  • [32642] Resolves an issue where, when there were a very large number of queries running on a cluster, there was excessive CPU use on segment hosts and high memory usage on the Command Center web server.

Release 6.8.3

Release Date: 2022-12-8

VMware Tanzu Greenplum Command Center 6.8.3 is a maintenance release that resolves these issues:

  • [32486] Resolves an issue where stale queries were remaining in the Query Monitor after they had completed.
  • [183496099] Resolves an issue where Command Center erroneously reported an error about incompatible versions when users upgraded the metrics collector extension by following the instructions in the update-extension.txt file installed with Command Center 6.8.2.
  • [183880537] Resolves an issue where the Command Center process was using excessive amounts of memory and CPU.

Release Date: 2022-10-03

Release 6.8.2

Release Date: 2022-10-03

VMware Tanzu Greenplum Command Center 6.8.2 is a maintenance release that resolves these issues:

  • [32445] Resolves a crash that could occur when Greenplum Command Center collected its own performance data.
  • [32433] Resolves a problem that could cause Greenplum Command Center to terminate the wrong process with signal -9.
  • [183359122] Greenplum Command Center now prevents its agent from running a different version of the software. This is indicated by a log message similar to AgentManager: GPCC Version mismatch, Agent <agent>, webserver <webserver>, will be stopped

Release 6.8.0

Release Date: 2022-08-05

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

New and Changed Features

  • The default location of the gpmetrics directory is now $HOME -- the home directory of the user who starts up Command Center -- rather than $MASTER_DATA_DIRECTORY.

    If you are upgrading from Command Center 6.7.x or earlier and a directory called gpmetrics does not already exist under $HOME, Command Center will migrate the gpcc.conf and gpcc-alert.yaml files from $MASTER_DATA_DIRECTORY/gpmetrics directory to $HOME/gpmetrics.

    If a directory called gpmetrics does already exist under $HOME, you must copy the gpcc.conf and gpcc-alert.yaml files over manually before starting Command Center 6.8.0 for the first time.

    To specify a default location different than $HOME for the gpmetrics directory, configure the gpmetrics_home parameter in the app.conf file. For more information, see the Command Center Console Parameters topic.

    For more information, see Install the Greenplum Command Center Software.

  • A user can now configure Command Center to purge history data that exceeds the specified retention period. For more information, see the History Settings topic.

  • A user can now create Workload Management rules for logging queries that match a particular condition. For more information, see the Workload Management documentation page.

  • A user can now filter queries by by department name, using the Advanced Search tool in the Query Monitor dashboard. For more information, see the Query Monitor documentation page.

  • A user can now search query history by department name, using the Advanced Search tool in the History dashboard. For more information, see the History documentation page.

  • A user can now see the timestamp of each inner query.

  • A user can now view the size of a table on the table detail page in the Table Browser.

  • The realtime Query Details page now displays a list of the tables the query has accessed. For more information, see the Query Details documentation page.

  • The Query History details page now displays a list of the tables the query has accessed. For more information, see the Query History Details documentation page.

  • The gpmetrics schema has the following changes:

    • The gpmetrics.gpcc_queries_history table now has a column called access_tables_info, which stores the table OIDs of the tables the query accessed.

    • The gpmetrics.gpcc_table_info and gpmetrics.gpcc_table_info_history tables now have a column called last_size_ts, which stores the time when the current table's size column was last updated.

    For more information, see the gpmetrics Schema Reference.

  • This Command Center release introduces a new gpmetrics configuration parameter -- disable_size_check. When set to true, the Command Center table browser will not collect table size information, in order to prevent performance issues when there are a large number of tables. For more information, see the gpmetrics Configuration File Reference.

  • This Command Center release introduces a new console parameter -- XSRFSecure -- to protect the cookie Command Center uses. For more information, see the Command Center Console Parameters topic.

Resolved Issues

[32297] Resolved an issue where using "@" or "/" in the user field of the Command Center authentication screen resulted in an error.

[181943431] Resolved an issue where users could not use the cursor to edit the S3 file location they entered when creating a data loading job.

Known Issues

The following are known issues in the current Greenplum Command Center release.

  • [181749314] If a user creates a data loading job with the same data source and target table as an existing job, the existing job will be updated even if it was created by a different user.

  • [32049] Command Center does not monitor FETCH queries.

  • [31723] Submitting a large query string with psql -c or libraries causes Command Center performance issues.

  • [179572065] When the "Query is blocked for xxx minutes" alert is triggered, the query ID shown on the notification feed may be incorrect.

  • [178295227"] Resource group assignment by a query tags rule has no effect if the query tags are defined by PGOPTIONS with single quotes.

  • [31038] When Daylight Saving Time occurs, Command Center requires a restart to repopulate certain data metrics.

  • [30972] When using the gppersistentrebuild utility, the Last Accessed column in the Table Browser view might be refreshed, although no queries accessed the tables.

  • [174667383] 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.

  • [174395009] 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.

  • [167285013] 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.

  • 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.

  • 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.

check-circle-line exclamation-circle-line close-line
Scroll to top icon