1 Reply Latest reply on Nov 7, 2008 4:18 AM by jaikiran

    Transaction Timeouts/Deadlocks using MSSQL  (none using MySQ

    lpmon

      I see these in the log.

      2008-11-05 14:35:35,457 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=ch2wpiwhse/2352, BranchQual=, localId=2352] timed out. status=STATUS_ACTIVE

      Using MSSQL 2005
      jTds driver 1.2.2
      JBoss AS 4.0.5 w/EJB3

      How can I change logging to get more information. What I show above is the only thing in the log suggesting an error has occurred. I think there are deadlocks.

      Has anyone seen this issue? Works find in MySQL.

        • 1. Re: Transaction Timeouts/Deadlocks using MSSQL  (none using
          jaikiran

           

          "lpmon" wrote:

          How can I change logging to get more information.


          I had once enabled the Arjuna logs to log at TRACE level:
          <category name="com.arjuna">
           <priority value="TRACE" />
          
           </category>


          I don't remember if there was any useful information in the logs after this change.

          "lpmon" wrote:

          I think there are deadlocks.

          Then the best place to look for information would be the DB server administration tool.