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

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

    Details

    • 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:
      None
    • 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:
      External
    • Resolution Time Custom Field:
      93 weeks, 3 days, 26 minutes, 32 seconds

      Description

      Stale Data Issue: if 2 or more users try to edit the same web project (Edit Web Project Settings 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:

      12:45:26,125 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.ChildAssocImpl#941

      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.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  mkononovich mkononovich
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Date of First Response:

                    Structure Helper Panel