Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-4204

WCM standalone: ConcurrencyFailureException appears in case of concurrent access to the user sandbox (on promote to staging)

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 3.2
    • Fix Version/s: 3.2.1
    • Component/s: ZZ_Archive
    • Labels:
      None
    • Environment:
      Alfresco 3.2.0 Enterprise 267, 270 (standalone installation), MS Windows 2003 Enterprise SP2 32bit, Tomcat 6.0.18 (JDK 1.6.0_11-b03), MySQL 5.0.67.
    • Bug Priority:
      Category 3

      Description

      Concurrency issues appear on attempt to promote content to staging by multiple users (30 and more) in the same shared web-project:

      ERROR [org.jbpm.graph.def.GraphElement] action threw exception: AVMStore with ID (1810) no longer exists or has been updated concurrently
      org.springframework.dao.ConcurrencyFailureException: AVMStore with ID (1810) no longer exists or has been updated concurrently

      and

      DEBUG [org.alfresco.repo.transaction.RetryingTransactionHelper]
      Transaction commit failed:
      Thread: http-8080-34
      Txn: UserTransaction[object=org.alfresco.util.transaction.SpringAwareUserTransaction@91c6d7, status=0]
      Iteration: 0
      Exception follows:
      org.springframework.dao.ConcurrencyFailureException: AVMStore with ID (1826) no longer exists or has been updated concurrently

      From 300 submitted items (scenario with 30 users and 10 submission loops) 283 haven't appeared in Staging Sandbox.
      For comparison: in case of 200 submitted items (scenario with 20 users and 10 submission loops) all items were successfully promoted to staging.
      (please see screens attached)

      Results of performing

      mysql> select * from jbpm_job where exception_ is not null and retries_=0 into outfile 'g:\jbpm_job_
      result.txt';
      Query OK, 173 rows affected (0.06 sec)

      are attached to the issue (jbpm_job_result_30_users_10_loops_standalone_3.2.0.270.txt).

      TEST PROPERTIES
      Test users count: 2...30 (standalone)
      Submission loops count: 10

      CUSTOM LOG4J PROPERTIES
      log4j.logger.org.alfresco.repo.avm.wf.AVMSubmitPackageHandler=debug
      log4j.logger.org.alfresco.repo.transaction.RetryingTransactionHelper=debug
      log4j.logger.org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutor=debug

      NOTE: logged as separate issues in accordance with this comment: https://issues.alfresco.com/jira/browse/ETHREEOH-3319?focusedCommentId=55473&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_55473.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs
                Reporter:
                alfrescoqa Alfresco QA Team
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: