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

Gradeable student content pages/comments break when lessons is highly utilized

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.9.0
    • Fix Version/s: 2.9.0
    • Component/s: Lessons
    • Labels:
      None
    • Previous Issue Keys:
      LSNBLDR-284

      Description

      The DB fields lesson_builder_item.altgradebook and lesson_builder_item.gradebookid have limits of 35 characters.

      This caused us a lot of problems in production as Lessons is highly utilized. Therefor, the ID generated for this table becomes very high (currently ours is hovering around 15 million in production).

      Once the ID becomes large enough, the DB will throw a constraint violation.

      For instance, this is the string that is added to the altgradebook field:

      "lesson-builder:page-comment:1140629"

      where 1140629 is the ID of the record in the lesson_builder_item table. As you can see, with an ID in the million range, the actual length of this field is 35 characters. Once that ID moves on to 10 million and greater, it will violate the constraint, and you will be unable to create student content pages with graded comments.

      The solution is to give yourself some more room in these fields. We changed it to VARCHAR(100 char) just to be on the safe side. (Change in .hbm.xml file too).

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  hedrick Charles Hedrick
                  Reporter:
                  bjones86 Brian Jones
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration