[Building Sakai] Sakai 2.9.0 MySQL DB Conversion, MSGCNTR - Incorrect index name 'FK1DDE4138A306F94D'

[Gast, Cynthia (cmw6s)]

I created MSGCNTR-778 for this issue.

Thanks for considering,
Cynthia Gast * UVa

________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Gast, Cynthia (cmw6s) [cmw6s at eservices.virginia.edu]
Sent: Monday, January 28, 2013 12:14 PM
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] Sakai 2.9.0 MySQL DB Conversion, MSGCNTR - Incorrect index name 'FK1DDE4138A306F94D'

Hello:

Converting from 2.8.1 to 2.9.0 with MySQL 5.5.x DB, I'm seeing a SQL error from the MSGCNTR-438 section of 'sakai_2_9_0_mysql_conversion.sql':


CREATE TABLE MFR_HIDDEN_GROUPS_T  (
    ID                bigint(20) AUTO_INCREMENT NOT NULL,
    VERSION           int(11) NOT NULL,
    a_surrogateKey    bigint(20) NULL,
    GROUP_ID          varchar(255) NOT NULL,
    PRIMARY KEY(ID)
);

ALTER TABLE MFR_HIDDEN_GROUPS_T
    ADD CONSTRAINT FK1DDE4138A306F94D
    FOREIGN KEY(a_surrogateKey)
    REFERENCES MFR_AREA_T(ID)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT;

CREATE INDEX FK1DDE4138A306F94D
    ON MFR_HIDDEN_GROUPS_T(a_surrogateKey);

ERROR 1280 (42000): Incorrect index name 'FK1DDE4138A306F94D'


Wondering if anyone else has seen this with a MySQL upgrade, or if there is a suggested fix for this that I've missed (i.e., a different index name, or removal of this 'create index' statement)?  Note the Fkey and the Index have the same name.


I checked out 29x source, and this code is the same as what I'm running (after fixing the 'alter table' statement to uppercase the 2.9.0 'mfr_area_t' table name).  I've been looking, but have not found a Jira issue about this; I can create one if needed.

Thanks for suggestions on this issue.
Cynthia Gast
UVa


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130204/fadcf9d1/attachment.html