gp_resgroup_status_per_segment reports: ERROR: value "XXXXXXX" is out of range for type integer

Products

• VMware Tanzu Greenplum

Issue/Introduction

The following views report the error:

# select * from gp_toolkit.gp_resgroup_status;
ERROR:  value "2200086979" is out of range for type integer

gpadmin=# select * from gp_toolkit.gp_resgroup_status_per_segment;;
ERROR:  value "2200086979" is out of range for type integer

# select * from gp_toolkit.gp_resgroup_status_per_host;
ERROR:  value "2200086979" is out of range for type integer

Listing the OID of the Resource Groups shows that one or more OIDs are great then 2,147,483,647 (2^31 -1)

# select oid,* from pg_resgroup;
    oid     |    rsgname    | parent
------------+---------------+--------
       6437 | default_group |      0
       6438 | admin_group   |      0
 2200086979 | rq_test       |      0
(3 rows)

The cause of the error is due to a coding issue with the function pg_catalog.pg_resgroup_get_status which is used by the above views.

# select pg_catalog.pg_resgroup_get_status(NULL);
ERROR:  value "2200086979" is out of range for type integer

Environment

Product Version: 6.15

Resolution

The issue is fixed in 6.19.3.

32056:
Resolves an issue where querying the gp_toolkit.gp_resgroup_status_per_segment view returned the error value ... is out of range for type integer when the OID of a resource group was greater than 2^31.