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

Cannot delete questions from question pools

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 19.0, 20.0 [Tentative]
    • Fix Version/s: 19.0, 20.0 [Tentative]
    • Labels:
      None
    • Environment:
      Nightly MySQL 19.x, Nightly MySQL 20.x
    • 19 status:
      Verified
    • Test Plan:
      Hide
      1. In Tests & Quizzes as an Instructor create a question pool
      2. Add 2 questions of any type to the question pool
      3. Click on the both checkboxes and click remove
      4. Confirm that you want to remove

      Expected: Questions in the pool are removed

      Actual: Nothing removed, some of the question questions (usually the last) remain checked. Errors in the logs (see description)

      Show
      In Tests & Quizzes as an Instructor create a question pool Add 2 questions of any type to the question pool Click on the both checkboxes and click remove Confirm that you want to remove Expected: Questions in the pool are removed Actual: Nothing removed, some of the question questions (usually the last) remain checked. Errors in the logs (see description)

      Description

      When trying to remove individual or all questions from question pools it is not working in Sakai 19 or 20. This works as expected in Sakai 12 so this is a new regression.

      I don't see any workaround besides deleting the entire question pool which isn't great. This is a sample of the exception

      05-Jan-2019 10:38:25.714 WARN [http-nio-20019-exec-1] org.sakaiproject.tool.assessment.facade.QuestionPoolFacadeQueries.removeItemFromPool problem delete item from pool: Removing a detached instance org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData#org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData@bf28 
      05-Jan-2019 10:38:25.714 WARN [http-nio-20019-exec-1] org.sakaiproject.tool.assessment.services.PersistenceHelper.retryDeadlock Error saving to db...retry again.... 
      05-Jan-2019 10:38:25.715 WARN [http-nio-20019-exec-1] org.sakaiproject.tool.assessment.services.PersistenceHelper.retryDeadlock Removing a detached instance org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData#org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData@bf28 
      05-Jan-2019 10:38:25.726 WARN [http-nio-20019-exec-1] org.sakaiproject.tool.assessment.facade.QuestionPoolFacadeQueries.removeItemFromPool problem delete item from pool: Removing a detached instance org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData#org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData@c2e9 
      05-Jan-2019 10:38:25.726 WARN [http-nio-20019-exec-1] org.sakaiproject.tool.assessment.services.PersistenceHelper.retryDeadlock Error saving to db...retry again.... 
      05-Jan-2019 10:38:25.726 WARN [http-nio-20019-exec-1] org.sakaiproject.tool.assessment.services.PersistenceHelper.retryDeadlock Removing a detached instance org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData#org.sakaiproject.tool.assessment.data.dao.questionpool.QuestionPoolItemData@c2e9

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                maintenanceteam Core Team
                Reporter:
                jonespm Matthew Jones
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code