Select on information_schema.tables view reports: ERROR: could not connect to server "server01"

Products

• VMware Tanzu Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

Select on information_schema.tables view reports and error:

cdw=# select * from information_schema.tables;
ERROR:  could not connect to server "fdw_gpdb02_server"
DETAIL:  could not connect to server: Connection timed out
        Is the server running on host "gpdb02.domain.com" (xxx.xxx.xxx.xxx) and accepting
        TCP/IP connections on port 5432?

Cause

The view calls the function pg_relation_is_updatable(oid, boolean) which attempts to connect to the remote server.

If the server is not available, then the error is reported.

Resolution

Fix

As of April 2025, a fix is being developed and will be released in a maintenance release of Greenplum.

Check Release Notes for fix/issue 36245608 

Additional Information

See article ERROR: user mapping not found for "gpadmin" for similar issue with the information_schema.tables view.