Source Connection Failed Error to Postgres

[ananth4496]

I am trying to create a new source connection to PG database and I am getting this error. I am able to connect to this DB using psql CLI with same credentials.

Here is the error I am getting and stacktrace

Configuration check failed
Message: HikariPool-1 - Connection is not available, request timed out after 10001ms.

Internal message: io.airbyte.commons.exceptions.ConnectionErrorException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 10001ms.
Failure origin: source
Failure type: config_error

io.airbyte.commons.exceptions.ConnectionErrorException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 10001ms.
at io.airbyte.cdk.db.jdbc.DefaultJdbcDatabase.getMetaData(DefaultJdbcDatabase.java:84)
at io.airbyte.integrations.source.postgres.PostgresSource.createDatabase(PostgresSource.java:333)
at io.airbyte.integrations.source.postgres.PostgresSource.createDatabase(PostgresSource.java:122)
at io.airbyte.cdk.integrations.source.relationaldb.AbstractDbSource.check(AbstractDbSource.java:92)
at io.airbyte.integrations.source.postgres.PostgresSource.check(PostgresSource.java:748)
at io.airbyte.cdk.integrations.base.ssh.SshTunnel.sshWrap(SshTunnel.java:270)
at io.airbyte.cdk.integrations.base.ssh.SshWrappedSource.check(SshWrappedSource.java:54)
at io.airbyte.cdk.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:150)
at io.airbyte.cdk.integrations.base.IntegrationRunner.run(IntegrationRunner.java:125)
at io.airbyte.integrations.source.postgres.PostgresSource.main(PostgresSource.java:710)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 10001ms.
at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
at io.airbyte.cdk.db.jdbc.DefaultJdbcDatabase.getMetaData(DefaultJdbcDatabase.java:78)
... 9 more

uploaded the log file
check_connection_source-failure-becd3eec-a6a3-47e0-ba22-373e4e435822.txt

Appreciate any help and Thanks in Advance!

[akozichev]

connection time out is very generic error. Does it run in Kubernetes, Docker? or Cloud

[ananth4496]

Thanks Andre for getting back! We are running in docker. Increased TO to 20k using JDBC optional fields in source setup. Now I am getting this error Server temporarily unavailable (http.502.gMTbr5aL2er7wTNtRj3aoi) Not sure what this is. ananth

…

On Thu, Mar 7, 2024 at 2:14 AM Andrey Kozichev ***@***.***> wrote: connection time out is very generic error. Does it run in Kubernetes, Docker? or Cloud — Reply to this email directly, view it on GitHub <#35872 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AZR5SYV3YY56GVWC447NOWTYXA4XJAVCNFSM6AAAAABEKI6HJOVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DOMBVGEYTQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[ananth4496]

I am not sure what server it is getting 502. There is no more error information.