- Is this your first time deploying Airbyte?: Yes
- OS Version / Instance: MacOS
- Memory / Disk: 16gb/1tb
- Deployment: Docker
- Airbyte Version: 0.40.0-alpha
- Source name/version: Google Analytics
- Destination name/version: MySQL hosted on Bluehost Server
- Step: I have worked with blue host support to ensure that the IP address is white-listed. There has been a new database created and a new database user. Everything on the server end should be good.
- Description: Everything on the host server looks good but I am getting an error “Could not connect with provided configuration. HikariPool-1 - Connection is not available, request timed out after 60002ms.”
I am attaching Logs to complete the picture hopefully:
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-13 21:07:24 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-08-13 21:07:24 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-08-13 21:07:24 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-08-13 21:07:24 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-08-13 21:07:24 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-08-13 21:07:24 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-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - at java.lang.Thread.run(Thread.java:833) ~[?:?]
2022-08-13 21:07:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-13 21:07:23 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated…
2022-08-13 21:07:25 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-13 21:07:25 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed.
2022-08-13 21:07:25 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-13 21:07:25 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-08-13 21:07:25 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-13 21:07:25 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
2022-08-13 21:07:25 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling…