pg_log alerts is not shown in GPCC dashboard

Products

• VMware Tanzu Data Suite

Issue/Introduction

For a system user that is set not allowed to run the chmod command on system level possibly due to company security policy, if this user is used to run GPCC,  the section "Alerts from Greenplum Log"(please check the screenshot below as an example) in the bottom right corner of GPCC Dashboard Tab will show as blank.

Also, you might observe the following ERROR in GPCC webserver log:

PGLogHarvester: Harvest can't save to $GP_SEG_DATADIR/gpmetrics/gpcc_pg_log_cat.sh: pq: command not executable: early skip

Environment

GPCC versions prior to 6.13.0 / 7.3.0

Cause

Prior to GPCC 6.13.0 / 7.3.0, the system command chmod is needed for GPCC to implement pg_log havest. To be more precise, the system user who started GPCC will need to have full access to the following directory

$GP_SEG_DATADIR/gpmetrics/

$COORDINATOR_DATA_DIRECTORY/log/ or $MASTER_DATA_DIRECTORY/pg_log

Resolution

The temporary solution is to grant the needed permission(rwx) to the user

The chmod execution against $GP_SEG_DATADIR/gpmetrics/ failure issue has been resolved in GPCC 6.13.0 / 7.3.0.