gpconfig reporting "Collections must have at least a master and segment value"

Products

• VMware Tanzu Data Intelligence
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

The gpconfig command reports oneof the following messages:

"Collections must have at least a master and segment value"

"Collections must have at least a coordinator and segment value"

Example:

$ gpconfig -s max_connections
gpconfig reporting "Collections must have at least a coordinator and segment value"

Cause

This message will be reported if connections to the database are in utility mode, that is, if "PGOPTIONS" is set to "-c gp_session_role=utility

Resolution

Check if PGOPTIONS is set, example:

$ echo $PGOPTIONS
-c gp_session_role=utility

$ gpconfig -s max_connections
Collections must have at least a coordinator and segment value

Unset the environment variable and try running gpconfig:

$ unset PGOPTIONS

$ gpconfig -s max_connections
Values on all segments are consistent
GUC              : max_connections
Coordinator value: 250
Segment     value: 750

NOTE: Check that PGOPTIONS is not being set in ~/.bashrc nor in ~/.bash_profile files.