IBM Support

JDBC_77: HikariPool-53 - Connection is not available, request timed out

Troubleshooting


Problem

The issue could be caused because of temporary network issues or because the Database is taking a long time to return a response to the client. For example, for Postgres Database we get the following error. 

Message: HikariPool-53 - Connection is not available, request timed out after 30908ms. Cause: org.postgresql.util.PSQLException: Connection to hostX:portY refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Cause: java.net.ConnectException: Connection refused (Connection refused) '

Symptom

A running Pipeline fails or intermittently fails to connect or get a response from the Database.

Resolving The Problem

Check that there are no network problems connecting to your Database from the Data Collector:

  • Check from the SDC server the telnet command against the Database host/port: 

telnet databasehost:databaseport

  • Increase the 'Connection Timeout' on the JDCB stage to 60s.

  • Restart the Pipeline/SDC and try again to run the Pipeline in cases it doesn’t recover from the transient issue on the communication with the Database.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
15 March 2025

UID

ibm17186098

Page Feedback