Waring message in Greenplum "WARNING - time constraints added on superuser role"

Products

• VMware Tanzu Greenplum

Issue/Introduction

The warning message "time constraints added on superuser role" is frequently logged in the database log.

For example:

2020-01-02 13:24:53.396844 CET,"gpadmin","postgres",p98792,th-1075087232,"[local]",,2020-01-02 13:24:53 CET,0,con6,,seg-1,,,,sx1,"WARNING","01000","time constraints added on superuser role",,,,,,,0,,"auth.c",2966, 
2020-01-02 13:24:53.408259 CET,"gpadmin","template1",p98794,th-1075087232, "127.0.0.1","20770",2020-01-02 13:24:53 CET,0,con7,,seg-1,,,,sx1,"WARNING","01000"," time constraints added on superuser role",,,,,,,0,,"auth.c",2966,

Environment

Product Version: 6.1

Resolution

Note

This message can be ignored. It is logged every time a superuser logs into the database.

• It does not affect the functionality for the time constraints.
• It is not possible to place time constraints on a superuser role.

Fix

The message is no longer printed in Greenplum 6.4.