"ERROR: relation "master_data_dir" does not exist LINE 1: select * from master_data_dir" error after installing Tanzu Greenplum Command Center

Products

• VMware Tanzu Greenplum

Issue/Introduction

After an installation of Tanzu Greenplum Command Center (GPCC) in 6.x, errors appear indicating that the 'gpmon' user is querying tables that do not exist.

PDT|gpmon|gpperfmon|p23815|th-608413568|[local]||2021-08-16
06:21:33 PDT|0|con498053|cmd1|seg-1||||sx1|ERROR:
|42P01|relation "master_data_dir" does not exist||||||select * from
master_data_dir|15||parse_relation.c|1028| 2021-08-16 06:22:01.205771

query: select * from master_data_dir

2021-08-16 06:08:31|:-WARNING: [gpmondb.c:96] GPDB error ERROR: relation
"master_data_dir" does not exist LINE 1: select * from master_data_dir

These errors occurs when GPCC history data collection and gpperfmon data collection are both running, which affects performance. In addition, gpperfmon is referencing old tables from Tanzu Greenplum Database (GPDB) 5.x that are no longer present in GPDB 6.x.

Environment

Product Version: 6.15

Resolution

To resolve these errors, disable gpperfmon data collection with this command:

$ gpconfig -c gp_enable_gpperfmon -v 'off'

You need to restart the database for this change to take effect.

For more information, refer to Settings.