Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-40037

Delete two gradebook categories and add one produces database lock

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.4, 12.1, 19.0
    • Fix Version/s: 12.2, 19.0
    • Component/s: edu-services, Gradebook
    • Labels:
      None
    • 12 status:
      Resolved
    • 11 status:
      Please Merge
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      Steps to replicate:

      1) Login as instructor1 and create site with GB
      2) Go to Categories and add a few categories and save
      3) Go back to GB Categories and delete two categories (Remove) and add one new one

      Object of class [org.sakaiproject.tool.gradebook.GradeMapping] with identifier [88005]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [org.sakaiproject.tool.gradebook.GradeMapping#88005]
      
      ---TRANSACTION 28524792502, ACTIVE 16 sec starting index read
      mysql tables in use 1, locked 1
      LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
      MySQL thread id 133110, OS thread handle 0x2b4167749700, query id 157143096 10.1.1.1 sakai_dev updating
      /* update org.sakaiproject.tool.gradebook.GradebookAssignment */ update GB_GRADABLE_OBJECT_T set VERSION=4, GRADEBOOK_ID=18410, NAME='Blog #1', REMOVED=0, SORT_ORDER=2, CATEGORIZED_SORT_ORDER=0, POINTS_POSSIBLE=10, DUE_DATE=NULL, NOT_COUNTED=1, EXTERNALLY_MAINTAINED=0, EXTERNAL_STUDENT_LINK=NULL, EXTERNAL_INSTRUCTOR_LINK=NULL, EXTERNAL_ID=NULL, EXTERNAL_APP_NAME=NULL, IS_EXTRA_CREDIT=0, ASSIGNMENT_WEIGHTING=NULL, RELEASED=1, CATEGORY_ID=NULL, UNGRADED=0, IS_NULL_ZERO=NULL, HIDE_IN_ALL_GRADES_TABLE=0 where ID=151152 and VERSION=3
      ------- TRX HAS BEEN WAITING 16 SEC FOR THIS LOCK TO BE GRANTED:
      RECORD LOCKS space id 41499 page no 2348 n bits 172 index `PRIMARY` of table 
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ottenhoff Sam Ottenhoff
                  Reporter:
                  ottenhoff Sam Ottenhoff
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code