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

Duplicate gradebook items fix might cause deadlock

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: OPEN
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 12.0
    • Fix Version/s: None
    • Component/s: edu-services
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      On SAK-27494 it was originally reported that some tools (like Samigo) could create duplicate gradebook items. However this was this comment here that with this new patch Samigo (Test and Quizzes) caused Deadlock exceptions. I haven't tried to reproduce this myself but I believe it's unchanged from this comment.

      The patch proposed by Brian works. At least duplicated gradebook items aren't saved, but some exceptions are thrown:
2014-12-16 15:54:42,504 WARN http-apr-8080-exec-22 org.hibernate.util.JDBCExceptionReporter - SQL Error: 60, SQLState: 61000
2014-12-16 15:54:42,504 ERROR http-apr-8080-exec-22 org.hibernate.util.JDBCExceptionReporter - ORA-00060: Deadlock detected while waiting for resource
2014-12-16 15:54:42,763 ERROR http-apr-8080-exec-1 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.sakaiproject.tool.gradebook.Assignment#226628

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

              relates to

              Bug - A problem which impairs or prevents functionality of the product. SAK-27494 Duplicate gradebook items created by GradebookExternalAssessmentService

              • Critical - Crashes, loss of data, severe memory leak, need functionality ASAP in production.
              • RESOLVED

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  jonespm Matthew Jones
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                    Dates

                    Created:
                    Updated:

                      Git Integration