pg log report lots of "could not unlink file xxx" in Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

From the Master log, it reports a lot of message like the one below:

could not unlink file ""base/12345/pgsql_tmp/pgsql_tmp_sess12345_w12345_qdxid12345_qdcid0_sync1"": No such file or directory",

Environment

Product Version: 5.0

Resolution

This is a known issue in Greenplum 5.x. To avoid this issue, upgrade to Greenplum 5.21.5 or higher. future releases will avoid generating such logs.

Note: If an upgrade is not possible, then changing the log level is a possible workaround, but reducing the log level is not suggested.

gpconfig -c log_min_messages -v  "log_level"
INFO                      high level
NOTICE
WARNING
LOG
ERROR
FATAL 
PANIC                     low level