Source Postgres: Could not connect with provided configuration

Connector Questions & Issues
,
1
  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Ubuntu
  • Memory / Disk: 20GB
  • Deployment: Docker
  • Airbyte Version: 0.39.21
  • Source name/version: Postgres 0.4.26
  • Destination name/version: None
  • Step: Creating a new source
  • Description: Getting an error while trying to connect to a Postgres RDS database. The version is 12.x.x. I tested the same credentials in another connector and they are working.

The error is: Could not connect with provided configuration. Error: HikariPool-1 - Connection is not available, request timed out after 60002ms.

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.SetupQueryRunner.run(SetupQueryRunner.java:55) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.v3.ConnectionFactoryImpl.runInitialQueries(ConnectionFactoryImpl.java:871) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:304) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.Driver.makeConnection(Driver.java:402) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.Driver.connect(Driver.java:261) ~[postgresql-42.3.4.jar:42.3.4]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.lang.Thread.run(Thread.java:833) ~[?:?]

2022-06-28 19:45:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-06-28 19:45:45 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated...

2022-06-28 19:45:46 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-06-28 19:45:46 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed.

2022-06-28 19:45:47 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling...
2

Hi @gguerra, thanks for your post. I know this might seem frustrating but It is likely that there is a problem with your configuration details. What other connector did you try testing the credentials with?

4

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.