https://linen.dev logo
#troubleshooting
Title
# troubleshooting
l

Larry Gormley

04/12/2022, 11:02 PM
I want to create a destination connection to Postgres but it is failing telling me it is unable to create a poolable Data Factory. Any good advice is appreciated. Here is the log: 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at sun.nio.ch.Net.pollConnect(Native Method) ~[?:?] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at sun.nio.ch.Net.pollConnectNow(Net.java:672) ~[?:?] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549) ~[?:?] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597) ~[?:?] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) ~[?:?] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.net.Socket.connect(Socket.java:633) ~[?:?] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.PGStream.createSocket(PGStream.java:231) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.PGStream.<init>(PGStream.java:95) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:98) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:225) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.Driver.makeConnection(Driver.java:465) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.postgresql.Driver.connect(Driver.java:264) ~[postgresql-42.2.18.jar:42.2.18] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:55) ~[commons-dbcp2-2.7.0.jar:2.7.0] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) ~[commons-dbcp2-2.7.0.jar:2.7.0] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:115) ~[commons-dbcp2-2.7.0.jar:2.7.0] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:665) ~[commons-dbcp2-2.7.0.jar:2.7.0] 2022-04-12 223743 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - ... 13 more 2022-04-12 223744 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
3 Views