ERROR: column "rsqcountlimit" does not exist while connecting to HDB 2.x via pgadmin3

Products

• Services Suite

Issue/Introduction

Symptoms:

Upgrading from HAWQ 1.3.0.0 to HDB 2.x produces the following error message when connecting to HAWQ through pgAdmin:

ERROR: column "rsqcountlimit" does not exist

Environment

Cause

This error occurs during connection initiation when pgadmin3 tries to get the resource queues using the below query:

queues = SELECT rsqname, rsqcountlimit, rsqcostlimit, rsqovercommit, rsqignorecostlimit, oid 
FROM pg_resqueue ORDER BY 1");

In HAWQ 1.3, the catalog table that contains resource queue information pg_resqueue, has a column named rsqcountlimit as per the documentation.

The column rsqcountlimit has been removed from HDB 2.0 onwards as documented here. As a result, while querying resource queue status, pgAdmin throws this error message.

Resolution

Click OK on the error screen. You will able to proceed ahead and access pgadmin3 UI.

This needs to be fixed with pgAdmin's source code and will be available in future versions.