PXF server error : HikariPool-xx - Connection is not available, request timed out after 30000ms.

Products

• VMware Tanzu Greenplum

Issue/Introduction

As mentioned in the PXF doc, The PXF JDBC Connector uses JDBC connection pooling implemented by HikariCP. This error indicates the maximum amount of time to wait for a connection from the pool has been reached.

Environment

Product Version: 6.23

Resolution

Increase properly the value of the param "jdbc.pool.property.connectionTimeout" in PXF jdbc server configuration.

Refer doc: https://docs.vmware.com/en/VMware-Greenplum-Platform-Extension-Framework/6.9/greenplum-platform-extension-framework/jdbc_cfg.html