nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

[rohith-yadav-miq]

Description:
We have a composed task which triggers 4 parallel tasks. While composed task is triggering the child taask it is failing with nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

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 09:00:43.741 ERROR 1 --- [ taskExecutor-3] o.s.batch.core.step.AbstractStep : Encountered an error executing step dsp-comp-task-segment_0 in job dsp-comp-task
2025-04-02 09:00:43.741
2025-04-02 09:00:43.741
org.springframework.cloud.dataflow.rest.client.DataFlowClientException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
2025-04-02 09:00:43.741
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 09:00:43.741
at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 09:00:43.741
at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:825) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 09:00:43.741
at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:783) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 09:00:43.741
at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:717) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 09:00:43.741
at org.springframework.web.client.RestTemplate.postForObject(RestTemplate.java:443) ~[spring-web-5.3.39.jar!/:5.3.39]
2025-04-02 09:00:43.741
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 09:00:43.741
at org.springframework.cloud.dataflow.composedtaskrunner.TaskLauncherTasklet.execute(TaskLauncherTasklet.java:217) ~[classes!/:na]
2025-04-02 09:00:43.741
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 09:00:43.741
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 09:00:43.741
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.39.jar!/:5.3.39]
2025-04-02 09:00:43.741
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 09:00:43.741
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 09:00:43.741
at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:382) ~[spring-batch-infrastructure-4.3.10.jar!/:4.3.10]
2025-04-02 09:00:43.741
at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215) ~[spring-batch-infrastructure-4.3.10.jar!/:4.3.10]
2025-04-02 09:00:43.741
at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145) ~[spring-batch-infrastructure-4.3.10.jar!/:4.3.10]
2025-04-02 09:00:43.741
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 09:00:43.741
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 09:00:43.741
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 09:00:43.741
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 09:00:43.741
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 09:00:43.741
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 09:00:43.741
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 09:00:43.741
at org.springframework.batch.core.job.flow.support.state.FlowState.handle(FlowState.java:56) ~[spring-batch-core-4.3.10.jar!/:4.3.10]
2025-04-02 09:00:43.741
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 09:00:43.741
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 09:00:43.741
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 09:00:43.741
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 09:00:43.741
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[na:na]
2025-04-02 09:00:43.741
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[na:na]
2025-04-02 09:00:43.741
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[na:na]
2025-04-02 09:00:43.741
at java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na]

[rohith-yadav-miq]

@corneil @cppwfs Can you please help us with the resolution