Error doing inserts; General error: Lock wait timeout exceed
tbauer Aug 6, 2002 11:36 AMOne more time...
My configuration: Mac OS X (10.1.5)
G4 Titanium Powerbook (1Gig Memory)
mysql-3.23.49
JBoss-2.4.6_Jetty-4.0.1
mm.mysql-2.0.14-bin.jar (mysql jdbc driver)
I have been developing a JBoss EJB application for some time now using JBoss-2.4.6_Jetty-4.0.1 and Mysql mysql-3.23.49.
Everything has been working perfectlly until yesterday when I thought I would update Mysql to mysql-3.23.51. Install was fine, copied the data back into the proper directory and made sure the "mysql" user was the owner of everything.
Now, when I deploy my ear file, my application works fine EXCEPT when it goes to do INSERTS. Updates and reads are fine...Any clues would what is happening would be greatly appreciated...
Here's my datasource config from jboss.jcml
ICSRegDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
DatabaseName=icsrege
jdbc:mysql://localhost/icsrege
300000
icsregadmin
xxxxx
202
true
false
true
true
120000
1800000
true
false
1.0
0
TRANSACTION_SERIALIZABLE
Here's the stacktrace form my Jboss monitor:
An error has happened:
javax.ejb.CreateException: Could not create entity:java.sql.SQLException: General error: Lock wait timeout exceeded; Try restarting transaction
at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:148)
at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:129)
at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:239)
at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:640)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:867)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:234)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:147)
at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:97)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:142)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:102)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:103)
at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:429)
at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:458)
at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:237)
at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182)
at $Proxy53.create(Unknown Source)
at com.icshealth.ejb.session.ShiftManagerBean.createShiftRequest(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:542)