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

    Transaction Timeouts/Deadlocks using MSSQL  (none using MySQ

    lpmon Novice
    lpmon Nov 6, 2008 5:55 PM

      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.

      • 1848 Views
      • Tags:
        • 1. Re: Transaction Timeouts/Deadlocks using MSSQL  (none using
          jaikiran pai Master
          jaikiran pai Nov 7, 2008 4:18 AM (in response to lpmon)

           

          "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.