- Pivotal Greenplum Database (GPDB) 4.3.x
- Operating System- Red Hat Enterprise Linux 6.x
- DCA 2.1 and above
The log file $MASTER_DATA_DIRECTORY/gpperfmon/logs/gpmmon.YYYY.MM.DD_HHMMSS.log file is populated with errors such as the following:
WARNING: [gpmon_snmp.c:2298] failed appending file /opt/connectemc/poll/GPMON_CKM00133123456_030615_120728000_6_41590_0001.txt to /data/master/gpseg-1/gpperfmon/data/_emcconnect_tail.dat error 13 (Permission denied)
The umask on the DCA was changed from 022 to 077 on the newer DCAs. The connecthome feature creates the files in the /opt/connectemc/poll/ directory with ownership root:service and default permissions 600. This means that gpadmin cannot read the files and process the data.
The workaround is listed below, follow these steps to resolve this issue:
- Log on to the master host as root user
- Change directory to /opt/connectemc/poll/
- change permissions on the files to 664
chmod 664 GPMON*
A Service Request has been opened with the DCA support to ensure that the files are created with the correct permissions.