Active Statement count in Resource Queue in incorrect

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms

1. Active Statement count in Resource Queue in incorrect.
2. Sessions are not being cleared from the queue after ending.
3. gp_toolkit.gp_resqueue_status rsqcountvalue reports an incorrect value for one or more of the queues

Environment

Product Version: 6.18

Resolution

Fix

Fixed in 6.19.0 and above.
Fixed in 5.29.2 and above

See issue 31887 in the respective Release Notes for the versions.

Workaround:

1. Temporarily increase the ACTIVE_STATEMENTS limit for the queue to allow for the incorrect Active Statementcount
2. Restart Greenplum to clear the Active Statements count.