Getting database deadlock in Bonita with MYSQL
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)
Comments
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.
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