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

          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
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Git Source Code