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

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2903587 ] New: CONFSERVER Bug Workflow v4 [ 2998196 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2801879 ] New: JAC Bug Workflow v3 [ 2903587 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2734331 ] New: JAC Bug Workflow v2 [ 2801879 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2399739 ] New: JAC Bug Workflow [ 2734331 ]

            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.
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2298641 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2399739 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233427 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2298641 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2194664 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233427 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1934789 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2194664 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1734302 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1934789 ]

              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: