Workflow stuck after a done task

Description

We had an issue in one of our production servers after someone finished a task.

Usualy, in this workflow, after this task is done, some automatic steps are done (as scripts execution). But this time, the task was marked as done in Bonita but the workflow was stucked here and the next automatic steps weren't done.

Hopefully, at each steps of this workflow, 2 persons are able to do a task that makes the workflow moves forward.

There is the output of the Bonita interface when the 1st person did it's task :

And then, when the 2nd person did it :

There is some stack traces catched from the server's logs :

2018-08-03 13:46:15 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
SEVERE: THREAD_ID=XXX | HOSTNAME=XXX | TENANT_ID=1 | The work [ExecuteFlowNodeWork: processInstanceId:7XXX9, flowNodeInstanceId: 1XXXXX3] failed. The failure will be handled.
2018-08-03 13:46:15 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
SEVERE: THREAD_ID=XXX | HOSTNAME=XXX | TENANT_ID=1 | Unexpected error while executing work [ExecuteFlowNodeWork: processInstanceId:7XXX9, flowNodeInstanceId: 1XXXXX3]. You may consider restarting the system. This will restart all works.
org.bonitasoft.engine.core.process.instance.api.exceptions.SFlowNodeExecutionException: org.bonitasoft.engine.core.process.instance.api.exceptions.SFlowNodeReadException: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not prepare statement
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:176)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.executeFlowNode(FlowNodeExecutorImpl.java:336)
at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:74)
at org.bonitasoft.engine.execution.work.TxBonitaWork$1.call(TxBonitaWork.java:48)
at org.bonitasoft.engine.execution.work.TxBonitaWork$1.call(TxBonitaWork.java:44)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:288)
at org.bonitasoft.engine.execution.work.TxBonitaWork.work(TxBonitaWork.java:53)
at org.bonitasoft.engine.execution.work.LockProcessInstanceWork.work(LockProcessInstanceWork.java:79)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork.work(FailureHandlingBonitaWork.java:66)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:56)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:47)
at org.bonitasoft.engine.work.BonitaRunnable.run(BonitaRunnable.java:35)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

2018-08-03 13:46:15 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork
SEVERE: THREAD_ID=XXX | HOSTNAME=XXX | TENANT_ID=1 | Unable to handle the failure.
org.bonitasoft.engine.core.process.instance.api.exceptions.SFlowNodeReadException: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not prepare statement

Environment

CentOS 7 / Tomcat 7.0.69 / 1.8.0_131

Steps to reproduce

Unknown

Workaround

None

External Link

None

Status

Assignee

Pierrick Voulet

Reporter

Jérôme

Reference

None

Components

Affects versions

6.4.2
Configure