Upgrade to Hibernate 3.5.x
Description
Environment
None
Test Plan
None
Attachments
2
- 25 Jun 2012, 09:06 AM
- 19 May 2010, 03:13 AM
depends on
incorporates
is depended on by
is duplicated by
is incorporated by
is related to
relates to
Activity
Show:
Hudson CI Server June 17, 2013 at 5:46 AM
Integrated in metaobj trunk #1471 (See http://builds.sakaiproject.org:8080/job/metaobj%20trunk/1471/)
Result = SUCCESS
Noah Botimer May 31, 2013 at 6:49 AM
As of the 4AM trunk build on nightly2, all known issues are resolved.
Hudson CI Server May 31, 2013 at 3:43 AM
Integrated in site-manage trunk #739 (See http://builds.sakaiproject.org:8080/job/site-manage%20trunk/739/)
Result = SUCCESS
Hudson CI Server May 31, 2013 at 2:42 AM
Integrated in emailtemplateservice trunk #661 (See http://builds.sakaiproject.org:8080/job/emailtemplateservice%20trunk/661/)
Result = SUCCESS
Hudson CI Server May 31, 2013 at 2:15 AM
Integrated in assignment trunk #673 (See http://builds.sakaiproject.org:8080/job/assignment%20trunk/673/)
Result = SUCCESS
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.