gpcheckcat report inconsistent_pg_extension error after installed extension "diskquota"

Products

• VMware Tanzu Greenplum

Issue/Introduction

In Greenplum database, after installing the extension "diskquota", we will find the error below in gpcheckcat: 

Object oid: 16392
Table name: pg_extension

    Name of test which found this issue: inconsistent_pg_extension
           extconfig is '{16394}' on content -1 (gp-aio-01:5432)
           extconfig is 'None' on all other segments
        extcondition is '' on content -1 (gp-aio-01:5432)
        extcondition is 'None' on all other segments

If we look into the catalog table in DB, it is similar to the one below:

-- master 
diskquota=# select '-1' as gp_segment_id,oid,* from pg_extension where extname = 'diskquota';
 gp_segment_id |  oid  |  extname  | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
---------------+-------+-----------+----------+--------------+----------------+------------+-----------+--------------
 -1            | 16392 | diskquota |       10 |         2200 | t              | 1.0        | {16394}   | {""}

-- segments
diskquota=# select gp_segment_id,oid,* from gp_dist_random('pg_extension') where extname = 'diskquota';
 gp_segment_id |  oid  |  extname  | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
---------------+-------+-----------+----------+--------------+----------------+------------+-----------+--------------
             1 | 16392 | diskquota |       10 |         2200 | t              | 1.0        |           |
             0 | 16392 | diskquota |       10 |         2200 | t              | 1.0        |           |

Environment

Product Version: 6.11

Resolution

R&D has confirmed that this is not an issue, it is expected behavior for the diskquota extension.

The R&D team will fix this error in a future release(target version is 6.12 and afterward)

If you need to fix the catalog issue, please contact greenplum support to assist.