Uploaded image for project: 'University of Michigan'
  1. University of Michigan
  2. UMICH-888

dbWrite errors in SAKAI_SESSION table due to duplicate SESSION_IDs

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: CTools 2.9G
    • Fix Version/s: CTools 2.9H
    • Component/s: CLE: Other
    • Labels:

      Description

      A problem was introduced in the 2.9G release with a change (KNL-1050) that truncated WEBDAV session-ids in a misguided attempt to treat the symptom rather than the root cause of the many session ids generated by webdav sessions. This change is reverted in the next Sakai release and should be reverted in the next CTools release.

      IMPACT: This problem has no impact on users, although it does impact our archive of event and session data. Non-unique sessions are not written to the production database, and non-unique sessions in production are not copied to the archive database. SessionIds are created based on the user, and so far it appears that all duplicate sessionIds map one-to-one with the same users, so the risk is low that a single event would map to multiple users/sessions for staff that look at the archive tables.

      Proposed fix: Merge -r 126050 to the kernel (see KNL-1050)

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  bkirschn Beth Kirschner
                  Reporter:
                  bkirschn Beth Kirschner
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved: