I am fetching the record from data base using SQLConnection.queryStreamWithParams.
Heap Size: -Xmx=200m (I can not set more than this for my application)
Record in DB: 348000
Stacktrace:
20 Sep 2022 01:16:05,760 [vert.x-worker-thread-18] WARN com.zaxxer.hikari.pool.ProxyConnection- 156 - HikariPool-1 - Connection org.hsqldb.jdbc.JDBCConnection@5fe656bb marked as broken because of SQLSTATE(08006), ErrorCode(-1305)
java.sql.SQLTransientConnectionException: connection exception: connection failure: java.lang.OutOfMemoryError: GC overhead limit exceeded
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-java7-2.4.13.jar:?]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-java7-2.4.13.jar:?]
at io.vertx.ext.jdbc.impl.actions.StreamQuery.execute(StreamQuery.java:63) ~[vertx-jdbc-client-4.1.5.jar:4.1.5]
at io.vertx.ext.jdbc.impl.actions.StreamQuery.execute(StreamQuery.java:33) ~[vertx-jdbc-client-4.1.5.jar:4.1.5]
at io.vertx.ext.jdbc.impl.JDBCConnectionImpl.lambda$schedule$3(JDBCConnectionImpl.java:219) ~[vertx-jdbc-client-4.1.5.jar:4.1.5]
at io.vertx.core.impl.ContextImpl.lambda$null$0(ContextImpl.java:159) ~[vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.AbstractContext.dispatch(AbstractContext.java:100) ~[vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:157) ~[vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76) ~[vertx-core-4.1.5.jar:4.1.5]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_332]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_332]
at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_332]
Caused by: org.hsqldb.HsqlException: connection exception: connection failure: java.lang.OutOfMemoryError: GC overhead limit exceeded
at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
at org.hsqldb.ClientConnection.execute(Unknown Source) ~[hsqldb-2.5.1.jar:2.5.1]
... 15 more
20 Sep 2022 01:16:21,281 [vert.x-eventloop-thread-5] ERROR
io.vertx.core.eventbus.ReplyException: Timed out after waiting 30000(ms) for a reply. address: __vertx.reply.37f719e0-b75e-4bc5-b821-85033253ba0b, repliedAddress: activitylogdb.queue
at io.vertx.core.eventbus.impl.ReplyHandler.handle(ReplyHandler.java:76) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.eventbus.impl.ReplyHandler.handle(ReplyHandler.java:24) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.VertxImpl$InternalTimerHandler.handle(VertxImpl.java:952) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.VertxImpl$InternalTimerHandler.handle(VertxImpl.java:919) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.EventLoopContext.emit(EventLoopContext.java:50) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.DuplicatedContext.emit(DuplicatedContext.java:168) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.AbstractContext.emit(AbstractContext.java:53) [vertx-core-4.1.5.jar:4.1.5]
at io.vertx.core.impl.VertxImpl$InternalTimerHandler.run(VertxImpl.java:942) [vertx-core-4.1.5.jar:4.1.5]
at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:170) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:469) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500) [netty-transport-4.1.68.Final.jar:4.1.68.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:986) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [netty-common-4.1.68.Final.jar:4.1.68.Final]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_332]