1 Reply Latest reply on Aug 22, 2005 10:47 AM by Clebert Suconic

    Performance degradation JBoss 4.0.2 +Specj 2002 + MySQL

    prakash babu Newbie

      Hello all,

      I tried testing the performance of JBoss 4.0.2 with Specj2002 on HPUX with Mysql 4.x as the backend.
      The TOPS value reduces as the injection rate(txRate) increases.

      TOPS=1.7 * txRate

      txRate TOPS Expected Value

      I have removed the values. Due to spec rules you can't publish any numbers

      I have tried
      1. Fine tuning the kernel parameters (max_thread_proc,nkthread, maxdsiz)
      2. Using the various mysql configurations(small,medium,huge etc)
      3. I have tried using MySQL Innodb tables ( row level locking)
      4. Fine tuning the JAVA option (increase HEAP size to 2048)
      5. Using 3.x versions of JBoss

      The following error occurs frequently in the server log.

      06:44:29,860 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.spec.jappserver.util.helper.SequenceBlock org.spec.jappserver.util.sequenceent.ejb.SequenceEntLocal.nextSequenceBlock(), causedBy: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=neptune.kovaiteam.com//758, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.ejb.EJBException: Expected one updated row but got: 0)

      There is some problem with comitting the transaction.

      Is this a problem with JBoss or MySQL ?
      Has any you tried the above combination of components and got a better result?
      Do I have to tune any other parameter ?