Help Wanted ERR HikariPool-1 - Connection is not available, request timed out after 30000ms. about pxf HOT 2 CLOSED

@MaxSimba - the JDBC connector uses 1 connection from the Hikari pool per query per thread. The PXF JVM will allocate 1 thread for each Greenplum segment collocated on the same host. For eample, if you have 8 GP segments per host, PXF will use 8 JDBC connections per query. If you try to run 2 queries concurrently, then 16 connections will be used. The default configuration sets up the Hikari pool with 15 connections ( https://github.com/greenplum-db/pxf/blob/master/server/pxf-service/src/templates/templates/jdbc-site.xml#L37 ), so in this case 1 thread will wait for a connection for 30 secs and then error out.
You have several options:

• increase number of connections in the pool specified in jdbc.pool.property.maximumPoolSize
• increase connection timeout jdbc.pool.property.connectionTimeout: https://github.com/greenplum-db/pxf/blob/master/server/pxf-service/src/templates/templates/jdbc-site.xml#L42
• if that does not help, disable the connection pool altogether by setting jdbc.pool.enabled to false

from pxf.

Looks like this thread has been resolved, so we will be closing this for now. If this issue persists, please reopen this issue or create a new issue with all the details.

from pxf.