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

Upgrade to Hibernate 3.5.x

    XMLWordPrintable

    Details

    • Type: Task
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.8.x
    • Fix Version/s: 10.0
    • Component/s: Kernel
    • Labels:
      None

      Description

      Upgrade Sakai to use latest Hibernate version to bring latest bugfixes to Sakai, with special attention to HHH-1012 which is a long-standing issue affecting Sakai (indexes not created in MySQL with auto.dll=true):

      http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012

      Relevant sakai-dev/sakai-qa thread:
      http://sakai-project-mail-list-archives.1343168.n2.nabble.com/Building-Sakai-Fwd-2-7-0-conversion-scripts-index-variations-msgcntr-profile2-sitestats-td5050675.html#a5050675

      Things that need to be fixed:
      An initial test made with 2.7.x + hibernate 3.2.7.qa (with HHH-1012 applied) revealed some issues with MySQL db indexes that need to be resolved. Here are the (truncated) startup messages:

      • Unsuccessful schema statement: create index MFR_PVT_MSG_USR_I1 on MFR_PVT_MSG_USR_T (USER_ID, TYPE_UUID, CONTEXT_ID, READ_STATUS)
        -> java.sql.SQLException: Specified key was too long; max key length is 1024 bytes
      • Unsuccessful schema statement: create index irwikihistory_ref on rwikihistory (referenced)
        -> java.sql.SQLException: BLOB/TEXT column 'referenced' used in key specification without a key length
      • Unsuccessful schema statement: create index irwikiobject_ref on rwikiobject (referenced)
        -> java.sql.SQLException: BLOB/TEXT column 'referenced' used in key specification without a key length
      • Sql.dbWrite(): error code: 1061 sql: create index GB_GRADE_RECORD_STUDENT_ID_IDX on GB_GRADE_RECORD_T (STUDENT_ID) binds:
        -> java.sql.SQLException: Duplicate key name 'GB_GRADE_RECORD_STUDENT_ID_IDX'

      After this Sakai dies when Gradebook tries to insert/update data during startup (SqlService.dbWrite failure).
      Please note that this is on MySQL 4.1.15 - MySQL 5 may or may not complain about the same issues.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  noahbotimer Noah Botimer
                  Reporter:
                  nfernandes Nuno Fernandes (Inactive)
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  8 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code