0 Replies Latest reply on Jan 12, 2006 11:41 AM by vijaiah vangara

    JBoss shutting down the Informix Database Engine

    vijaiah vangara Newbie

      Hello All,

      We are using JBoss 4.0.2 and our DB is Informix 9.3
      When we are performing a load test with 330 messages, some of the messages are holding up and are not moving farward and once all the messages are processed, we are getting the following messages about the hold transactions. Any help would be greatly appreciated.

      15:18:33,497 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3195, BranchQual=, localId=3195] timed out. status=STATUS_ACTIVE
      15:18:36,386 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3233, BranchQual=, localId=3233] timed out. status=STATUS_ACTIVE
      15:18:45,579 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3353, BranchQual=, localId=3353] timed out. status=STATUS_PREPARING
      15:18:46,411 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3364, BranchQual=, localId=3364] timed out. status=STATUS_ACTIVE
      15:18:57,846 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3507, BranchQual=, localId=3507] timed out. status=STATUS_ACTIVE
      15:19:02,222 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3563, BranchQual=, localId=3563] timed out. status=STATUS_PREPARING
      15:19:03,275 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3578, BranchQual=, localId=3578] timed out. status=STATUS_ACTIVE
      15:19:12,257 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3691, BranchQual=, localId=3691] timed out. status=STATUS_ACTIVE
      15:19:21,846 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3822, BranchQual=, localId=3822] timed out. status=STATUS_PREPARING
      15:19:22,897 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ralph/3837, BranchQual=, localId=3837] timed out. status=STATUS_ACTIVE

      Once i get those messages for the hold transactions, if i try to shutdown the JBoss, it is not shutting down completely. Then i am trying to kill the Jboss with kill -4 and kill -9, jboss is coming down but it is shutting down the Informix engine also.

      Please help as I an nearing the production deadline. Thanks. Vijay