Getting database deadlock in Bonita with MYSQL

Q&A
1

We are using Bonita 7.6.1 with MySQL 5.7.24, nowadays we are frequently getting database deadlock around the following query. And the Bonita app is throwing 500 errors with the provided log. Anyone know what is the issue here. Please help.

the query gets stuck at deadlock
insert into contract_data (scopeId, name, val, kind, tenantid, id) values (..

Bonita log

2019-10-16T06:34:21.288361394Z at java.lang.Thread.run(Thread.java:748) 2019-10-16T06:34:21.288365594Z Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected 2019-10-16T06:34:21.288369694Z at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604) 2019-10-16T06:34:21.288374194Z at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583) 2019-10-16T06:34:21.288378394Z at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.end(MysqlXAConnection.java:478) 2019-10-16T06:34:21.288382594Z at bitronix.tm.internal.XAResourceHolderState.end(XAResourceHolderState.java:172) 2019-10-16T06:34:21.288386894Z at bitronix.tm.internal.XAResourceManager.delist(XAResourceManager.java:133) 2019-10-16T06:34:21.288390694Z at bitronix.tm.BitronixTransaction.delistResource(BitronixTransaction.java:186)

2

Can you let me know which version of MySQL JDBC Driver you are using?

Also can you share the number of row currently stored in the contract_data table?

Thanks.

3

Hi @antoine.mottier,
Thanks for your reply. Please find the required details below.

  • No. of rows in contract_data table is 406
  • MySQL JDBC Driver mysql-connector-java-5.1.26.jar