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)
      

            [CONFSERVER-14096] Deadlocks in SQL Server in OS_PROPERTYENTRY table

            We are also experience this in Confluence 5.8.18 version too.

            SDLC Support added a comment - We are also experience this in Confluence 5.8.18 version too.

            Apoorva added a comment -

            We are experiencing the same in 5.4.4 version which is degrading the performance of our application.
            Can someone please do the needful?

            Apoorva added a comment - We are experiencing the same in 5.4.4 version which is degrading the performance of our application. Can someone please do the needful?

            Matt Ryall added a comment -

            We haven't seen any support cases or evidence of this bug for more than four years. Assume it is fixed or obsolete due to changes in the product.

            If you experience this problem in a modern version of Confluence (5.x or later), please raise a support ticket at https://support.atlassian.com.

            Matt Ryall added a comment - We haven't seen any support cases or evidence of this bug for more than four years. Assume it is fixed or obsolete due to changes in the product. If you experience this problem in a modern version of Confluence (5.x or later), please raise a support ticket at https://support.atlassian.com .

            Are people still seeing this issue? Is this still happening? No updates in the last 4 years it would be good to see if this is still happening in Confluence 5 and above.

            Steve Haffenden (Inactive) added a comment - Are people still seeing this issue? Is this still happening? No updates in the last 4 years it would be good to see if this is still happening in Confluence 5 and above.

            On this issue https://support.atlassian.com/browse/CSP-48286, the problem was the Tracking Plugin.
            Disable it solved the problem.

            Luzia Azevedo Mendes [Atlassian] added a comment - - edited On this issue https://support.atlassian.com/browse/CSP-48286 , the problem was the Tracking Plugin. Disable it solved the problem.

            Don Willis added a comment -

            If you encounter these problems, please file a case with support, and they will supply you with a logging patch to help determine what is writing to your OS_PROPERTYENTRY table.

            Currently the main suspected culprit is this tracking plugin so if you are experiencing this error and have that plugin enabled, please disable it.

            Don Willis added a comment - If you encounter these problems, please file a case with support, and they will supply you with a logging patch to help determine what is writing to your OS_PROPERTYENTRY table. Currently the main suspected culprit is this tracking plugin so if you are experiencing this error and have that plugin enabled, please disable it.

              matt@atlassian.com Matt Ryall
              don.willis@atlassian.com Don Willis
              Affected customers:
              5 This affects my team
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: