hi,
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...