Uploaded image for project: 'Alfresco'
  1. Alfresco
  2. ALF-1738

StaleObjectStateException appears on attempt to edit the same web form by 2 or more users simultaneously


    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.2 Enterprise
    • Fix Version/s: 4.0 Enterprise
    • Component/s: ZZ_Archive
    • Labels:
    • Environment:
      Alfresco Enterprise Network v2.2 SP3 (build 368), MS Windows 2003 Enterprise SP2 32bit, Tomcat 5.5.23 (JDK 1.6.0_07-b06), MySQL 5.0.51b.
      Standalone installation.
    • Resource:
    • Resolution Time Custom Field:
      93 weeks, 3 days, 22 hours, 51 minutes, 36 seconds


      Stale Data Issue: if 2 or more users try to edit the same web form (Edit Web Form action) simultaneously then only changes made by user who saves changes the last will be saved and changes made by other users will be lost (without any warning message has been shown).
      Moreover org.hibernate.StaleObjectStateException appears for users whose updates were lost:

      13:50:34,421 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
      org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): org.alfresco.repo.domain.hibernate.NodeImpl#1018

      Seems to be more user-friendly and fairly to show any friendly warning message like "Item that you want to change has been changed by another user. Please close dialog and refresh your view to see actual values" if user tries to save changes made for content just edited by another user to prevent data loss (since web forms haven't versions/revisions).

      (please see attached log for more info)

      Note: issue was found via running jmeter-script.
      Note: issue was submitted for Alfresco Enterprise 2.2 sp3 build 368.


          Issue Links




                • Assignee:
                  closedbugs Closed Bugs
                  mkononovich mkononovich
                • Votes:
                  0 Vote for this issue
                  2 Start watching this issue


                  • Created:
                    Date of First Response:

                    Structure Helper Panel