3 Replies Latest reply on Jan 25, 2006 5:58 PM by conkan

    JBoss shutting down the Informix Database Engine

    vvangara

      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


      Thanks
      Vijay

        • 1. Re: JBoss shutting down the Informix Database Engine
          vvangara

          Actually i haven't post my problem completely. Here is the continuation.

          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

          • 2. Re: JBoss shutting down the Informix Database Engine

            Keep in mind that this does not seem like this is a portal question, but rather a JBoss AS question.

            Anyway, in regard to your question, did you try the shutdown script OR doing a -C before trying the 'kill' commands? (Keep in mind that the scripts are kept in the 'bin' directory.

            Next time, post your JBoss AS server questions in the JBoss AS forum.

            • 3. Re: JBoss shutting down the Informix Database Engine

              when you saw this '-C' below I really meant CTRL-C. (I put the '<' and the '>' around 'CTRL'.