0 Replies Latest reply on Aug 6, 2002 11:35 AM by tbauer

    Error doing inserts; General error: Lock wait timeout exceed

    tbauer

      One 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)