dpalinic opened a new issue, #1213:
URL: https://github.com/apache/camel-karavan/issues/1213
I observed connection leaks when using SQL component using Karavan 4.4.0.
**How to reproduce:**
1. Create integration which has SQL component as a source
2. Leave default settings for everything, but add DataSource
3. Observe connection errors in logs after 50-10 minutes of work
**Error:**
`2024-04-03 09:36:24.743 WARN 15 --- [l-1 housekeeper]
om.zaxxer.hikari.pool.ProxyLeakTask : Connection leak detection triggered for
com.ibm.db2.jcc.t4.b@5fc3fcb8 on thread Camel (camel-1) thread #5 -
sql://SELECT%20*%20FROM%20SIVDB.FHOPEHS%20LIMIT%2050;, stack trace follows
java.lang.Exception: Apparent connection leak detected
at
com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:127)
~[HikariCP-5.1.0.jar:?]
at
org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160)
~[spring-jdbc-6.1.3.jar:6.1.3]
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118)
~[spring-jdbc-6.1.3.jar:6.1.3]
at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
~[spring-jdbc-6.1.3.jar:6.1.3]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:653)
~[spring-jdbc-6.1.3.jar:6.1.3]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:701)
~[spring-jdbc-6.1.3.jar:6.1.3]
at
org.apache.camel.component.sql.SqlConsumer.poll(SqlConsumer.java:204)
~[camel-sql-4.4.0.jar:4.4.0]
at
org.apache.camel.support.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:204)
~[camel-support-4.4.0.jar:4.4.0]
at
org.apache.camel.support.ScheduledPollConsumer.run(ScheduledPollConsumer.java:118)
~[camel-support-4.4.0.jar:4.4.0]
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
[?:?]
at
java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) [?:?]
at
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
[?:?]
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:840) [?:?]`
**Integration which we used for confirming the issue:**
[connection-leaks.zip](https://github.com/apache/camel-karavan/files/14850177/connection-leaks.zip)
**Additional notes:**
- We confirmed this against DB2 database
- We confirmed this with both HikariCP and Apache BasicDataSource
- We confirmed this issue exists without using `useIterator` option
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@camel.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
