nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms. #6116
Description
Description:
We have a composed task that triggers 4 parallel tasks. While the composed task is triggering the child task it is failing with a nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available.
We checked our DB connections it's well within the expected limits
Release versions:
We are using 2.11.5-debian-12-r2
Steps to reproduce:
This is happening intermittently for us.
Additional context:
2025-04-02 20:00:44.013
2025-04-02 20:00:44.012 ERROR 1 --- [ taskExecutor-2] o.s.batch.core.step.AbstractStep : Encountered an error executing step dsp-comp-task-pixel_0 in job dsp-comp-task
2025-04-02 20:00:44.013
2025-04-02 20:00:44.013
org.springframework.cloud.dataflow.rest.client.DataFlowClientException: Could not obtain last_insert_id(); nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
2025-04-02 20:00:44.013
at org.springframework.cloud.dataflow.rest.client.VndErrorResponseErrorHandler.handleError(VndErrorResponseErrorHandler.java:65) ~[spring-cloud-dataflow-rest-client-2.11.5.jar!/:na]
2025-04-02 20:00:44.013
at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 20:00:44.013
at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:825) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 20:00:44.013
at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:783) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 20:00:44.013
at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:717) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 20:00:44.013
at org.springframework.web.client.RestTemplate.postForObject(RestTemplate.java:443) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 20:00:44.013
at org.springframework.cloud.dataflow.rest.client.TaskTemplate.launch(TaskTemplate.java:231) ~[spring-cloud-dataflow-rest-client-2.11.5.jar!/:na]
2025-04-02 20:00:44.013
at org.springframework.cloud.dataflow.composedtaskrunner.TaskLauncherTasklet.execute(TaskLauncherTasklet.java:217) ~[classes!/:na]
2025-04-02 20:00:44.013
at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.39.jar!/:5.3.39]
2025-04-02 20:00:44.013
at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:382) ~[spring-batch-infrastructure-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215) ~[spring-batch-infrastructure-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145) ~[spring-batch-infrastructure-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:68) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:167) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:142) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:94) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at org.springframework.batch.core.job.flow.support.state.SplitState$1.call(SplitState.java:91) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 20:00:44.013
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[na:na]
2025-04-02 20:00:44.013
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[na:na]
2025-04-02 20:00:44.013
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[na:na]
2025-04-02 20:00:44.013
at java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na]
2025-04-02 20:00:44.013