Destination Postgres : Connection not available

[subucodes]

I have 2 on-premise windows VMs namely, terra and mars.(no firewall enabled so connectivity is not restricted)

• In terra, Airbyte is installed.
• In mars, Postgresql is installed (plain installation and not running inside docker).

Connectivity tests done on terra VM:

I tested the connectivity to the mars from terra by doing the following:

1. CMD -> Ping mars (I was able to ping successfully and able to get response without any losses)
2. Installed "DBeaver" and I am able to access the "Postgres" DB present in "mars" VM and I was able to do CRUD operations.

Problem:

I created a Airbyte pipeline with Zendesk as source and Postgres as destination. The source is successful but the destination is not. When I setup the Postgres destination

, I am getting the following errors

Error:

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

Stacktrace:

at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733)
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)

Caused by: java.net.NoRouteToHostException: No route to host
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:554)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at org.postgresql.core.PGStream.createSocket(PGStream.java:243)
at org.postgresql.core.PGStream.(PGStream.java:98)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:132)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258)
... 14 more

Logs : check_connection_destination-failure-fc39aecf-6561-4ea3-86ef-e316bbc60dd8.txt

Actions taken so far

• Asked solution kapa.ai in the airbyte slack channel and after following the suggestions , I finally posting it here
• Checked discussions section about this , but did not get any hits

[sajarin]

hey, thanks for posting in the github discussions, what version of airbyte and connectors are you using?