0 Replies Latest reply on Sep 9, 2002 6:37 AM by Lepargneul

    Transaction marked for rollback, possibly a timeout!! Can yo

    Lepargneul Newbie

      hi,

      I tried to fill 4 MySQL tables of 2000 lines for each one and i got the following error :

      11:44:30,402 WARN [TxCapsule] Transaction XidImpl [FormatId=257, GlobalId=cocon
      ut//143, BranchQual=] timed out. status=STATUS_ACTIVE
      11:44:37,041 ERROR [BeanLock] Saw rolled back tx=TransactionImpl:XidImpl [Format
      Id=257, GlobalId=coconut//143, BranchQual=]
      11:44:37,041 ERROR [LogInterceptor] TransactionRolledbackException, causedBy:
      java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout
      at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.doSchedule(Queued
      PessimisticEJBLock.java:183)
      <..........>

      To insert my records i used the method create of my entity beans. And it seems that this method try to do a rollback after each create..is it right? why?
      But it's strange because my job works fine when i try to insert less datas (100 in the 4 tables for example)...is there a limit somewhere?

      I'm running with :
      JBoss 3.0.0final
      Mysql-max 3.23.41 with innodb enabled
      Jdbc driver is mm.mysql-2.0.11-bin.jar

      Other informations :
      My tables have the type Innodb
      My trans-attribute is set to "Required"

      Could someone try to help me on this please?
      Thanks in advance
      Gaetan