JDBC Read timed out during pool initialization when initializing many Pools in parallel
Currently each filemaker jdbc connector has its own connection pool. When starting many connectors sequentially the JDBC requests for connections fail with a read timeout. This problem already has been reduced by introducing the CLIENT_START_JITTER
(value = 0.5) with commit 7ac96163.
Never the less, 9 of 29 sources tasks still fail with below exception:
kafka-connect | [2022-06-21 11:18:15,742] ERROR HikariPool-26 - Exception during pool initialization. (com.zaxxer.hikari.pool.HikariPool)
kafka-connect | com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Read timed out
kafka-connect | at com.filemaker.jdbc.FM_API.getColumnDefinitions(Unknown Source)
kafka-connect | at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)
kafka-connect | at com.filemaker.jdbc.FM_API.execDirect(Unknown Source)
kafka-connect | at com.filemaker.jdbc1.CommonJ1Statement.execDirect(Unknown Source)
kafka-connect | at com.filemaker.jdbc1.CommonJ1Statement.execute(Unknown Source)
kafka-connect | at com.zaxxer.hikari.pool.PoolBase.executeSql(PoolBase.java:583)
kafka-connect | at com.zaxxer.hikari.pool.PoolBase.checkValidationSupport(PoolBase.java:467)
kafka-connect | at com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:447)
kafka-connect | at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:416)
kafka-connect | at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
kafka-connect | at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
kafka-connect | at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
kafka-connect | at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
kafka-connect | at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
kafka-connect | at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
kafka-connect | at io.confluent.connect.jdbc.dialect.GenericDatabaseDialect.getConnection(GenericDatabaseDialect.java:258)
kafka-connect | at io.confluent.connect.jdbc.dialect.FilemakerDialect.access$101(FilemakerDialect.java:47)
kafka-connect | at io.confluent.connect.jdbc.dialect.FilemakerDialect$1.run(FilemakerDialect.java:144)
kafka-connect | at java.base/java.lang.Thread.run(Thread.java:829)