[jboss-user] [JBoss jBPM] - Lock wait timeout exceeded probelm with mysql
do-not-reply at jboss.com
Mon Mar 24 05:33:36 EDT 2008
I'm having problem of starting a process, I'm using spring module to intergrate spring, hibernate and jbpm,database is mysql innodb, for transaction it's using <tx:annotation-driven/>.
The function to create a processinstance is wrapped in @Transactional tag and I can see transaction lauchned successfully each time from the log entries.
All works fine except to start a new process, for few cases I got following errors:
org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not insert: [org.jbpm.graph.exe.ProcessInstance]; SQL [insert into JBPM_PROCESSINSTANCE (VERSION_, START_, END_, ISSUSPENDED_, PROCESSDEFINITION_, ROOTTOKEN_, SUPERPROCESSTOKEN_) values (?, ?, ?, ?, ?, ?, ?)]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
But it works out in my independent test case so I believe the configuration clips for jbpm and transaction should be fine. Also, please note it just happens few times.
Does any body here experience a similar problem or anybody could give me some clues? I was getting crzay on this issue.
tks in advance.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4138501#4138501
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4138501
More information about the jboss-user