Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-14096

Deadlocks in SQL Server in OS_PROPERTYENTRY table

    XMLWordPrintable

Details

    Description

      While many deadlocks have been fixed by the work in CONF-13668, some customers are still experiencing deadlock errors on page views in MS SQL Server due to updates on the OS_PROPERTYENTRY table. These are not yet understood. They may relate to particular macros being used.

      2010-04-06 13:51:14,269 ERROR [http-80-13] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Transaction (Process ID 149) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
       -- url: /display/mySpace/somePage | page: 2264286 | userName: admin | referer: http://confluence/display/mySpace/anotherPage | action: viewpage
      2010-04-06 13:51:14,269 ERROR [http-80-13] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
       -- url: /display/mySpace/somePage | page: 2264286 | userName: admin | referer: http://confluence/display/mySpace/anotherPage | action: viewpage
      2010-04-06 13:51:14,269 ERROR [http-80-13] [atlassian.xwork.interceptors.TransactionalInvocation] commitOrRollbackTransaction Action /pages/viewpage.action (ViewPageAction28.execute()) is already completed and can not be committed again.
       -- url: /display/mySpace/somePage | userName: admin | referer: http://confluence/display/mySpace/anotherPage
      2010-04-06 13:51:14,269 ERROR [http-80-13] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
       -- url: /display/mySpace/somePage | userName: admin | referer: http://confluence/display/mySpace/anotherPage
      org.springframework.transaction.IllegalTransactionStateException: Transaction is already completed - do not call commit or rollback more than once per transaction
      	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:725)
      	at com.atlassian.xwork.interceptors.TransactionalInvocation.commitOrRollbackTransaction(TransactionalInvocation.java:93)
      

      Attachments

        Issue Links

          Activity

            People

              matt@atlassian.com Matt Ryall
              don.willis@atlassian.com Don Willis
              Votes:
              5 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: