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

              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