Uploaded image for project: 'Poulpe'
  1. Poulpe
  2. POULPE-413

The system incorrectly handles cases when the several users perform editing/deleting the same items.

VotersWatchers
    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 0.20 Swallows
    • Fix Version/s: backlog
    • Labels:
      None

      Description

      Precondition:

      • two users has been created; User1 is loggen in in Browser1 and User2 in Browser2;
      • some section has been created
      • both users open the page with forum structure

      Steps:

      1. User1 delete section
      2. User2 delete section

      As a result, error message about JCommune notification appears

      Note that this section will not disappear until you clik F5; if you just opening other pages like Users forum structure page will not be refreshed.

      Expected, that page will be refreshed after going to other pages

      Note the same issue can be reproduced when one user tries to remove a branch/component/(or create new branch in the deleted section/create several components/create section/branch in the deleted component, so on), which was already deleted the other user.

      Exceptions appears in somecases like

      on editing branches/section for ex:

      Could not execute JDBC batch update; SQL [/* create one-to-many row org.jtalks.common.model.entity.Section.branches */ update BRANCHES set SECTION_ID=?, POSITION=? where BRANCH_ID=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update[SQL: 1452, 23000]

      on deleting component

      Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

        Attachments

        1. section_delete.png
          25 kB
          Julia Atlygina
        2. section_detetion.swf
          591 kB
          Julia Atlygina

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  julik Julia Atlygina
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - 2h Original Estimate - 2h
                    2h
                    Remaining:
                    Time Spent - 3h Remaining Estimate - 1h 40m
                    1h 40m
                    Logged:
                    Time Spent - 3h Remaining Estimate - 1h 40m
                    3h

                      Structure Helper Panel