Re: Upgrading Sakai 2.1.1 to 2.1.2 - MySQL "alter table drop foreign key" Error

Hi Lyndon & Vivie,

I talked to Jarrod and we have decided to leave teh old indexes and the
foreign key as is till 2.2. We would dropthe old index in 2.2 but the
foreign key relation is something taht we need to keep. So please ignore
these 4 drop foreign key stmt:

--drop index FKB68E6756D4927 on SAM_ITEMGRADING_T;
alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756D4927;

--drop index FKB68E6756A75F9029 on SAM_ITEMGRADING_T;
alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756A75F9029;

--drop index FKB68E6756C42AA2BC on SAM_ITEMGRADING_T;
alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756C42AA2BC;

--drop index FKB2E48A65C07F835D on SAM_PUBLISHEDASSESSMENT_T;
alter table SAM_PUBLISHEDASSESSMENT_T drop foreign key FKB2E48A65C07F835D;

Thanks for reporting teh error.

*Lyndon:* let me know how it goes. Thanks.

Daisy

On 4/18/06, Lyndon Tiu <ltiu@xxxxxxxxxx> wrote:
>
> Hello guys,
>
> Regarding upgrading from Sakai 2.1.1 to Sakai 2.1.2.
>
>
> On this website:
>
> http://bugs.sakaiproject.org/confluence/display/DOC/Database+Configuration
>
> You will find the MySQL script that converts a Sakai 2.1.1 database to
> Sakai 2.1.2:
>
>
> https://source.sakaiproject.org/svn/tags/sakai_2-1-2/docs/updating/sakai_2_1_1-2_1_2_mysql_conversion.sql
>
>
> Most of the script's sql commands run fine, except for the 5 "alter
> table" statements, which drops 5 foreign keys:
>
> -----------------------------------------------------------------
> --drop index FKB68E6756D4927 on SAM_ITEMGRADING_T;
> alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756D4927;
>
> --drop index FKB68E6756A75F9029 on SAM_ITEMGRADING_T;
> alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756A75F9029;
>
> --drop index FKB68E6756C42AA2BC on SAM_ITEMGRADING_T;
> alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756C42AA2BC;
>
> --drop index FKB2E48A65C07F835D on SAM_PUBLISHEDASSESSMENT_T;
> alter table SAM_PUBLISHEDASSESSMENT_T drop foreign key FKB2E48A65C07F835D;
>
> -- change constraint name for hbm change
> alter table SAM_PUBLISHEDANSWER_T drop foreign key FKB41EA361B9BF0B8E;
> -----------------------------------------------------------------
>
>
> Running any one of them produces the following error:
>
> mysql> alter table SAM_ITEMGRADING_T drop foreign key FKB68E6756D4927;
> ERROR 1025 (HY000): Error on rename of './sakai_ng2/SAM_ITEMGRADING_T'
> to './sakai_ng2/#sql2-1d19-12' (errno: 152)
>
>
> Research on Google seems to point to a corrupted database:
>
> http://dev.mysql.com/doc/refman/4.1/en/alter-table-problems.html
>
> But this is not the case with our database as there are no A- or B-
> files left behind in the data directories before or after running the
> alter table statements.
>
>
> It seems that Foothills is having this issue.
>
>
> I wonder:
>
> What are the negative implications of NOT running these alter table
> statements and hence NOT dropping the foreign keys?
>
>
> Thanks for any leads.
>
> --
> Lyndon Tiu
> Unicon, Inc.
> 3140 North Arizona Avenue, Suite 113
> Chandler, AZ 85225
> 480.558.2400 Phone
> 480.558.2320 Fax
> http://www.unicon.net
>
> ----------------------
> This automatic notification message was sent by Sakai Collab (
> http://collab.sakaiproject.org/portal) from the DG: Development site.
> You can modify how you receive notifications at My Workspace >
> Preferences.
>
>


--
Daisy Flemming
SUL / ACOMP @ Stanford University
daisyf@xxxxxxxxxxxx
tel#  617-253-4472 (Tues, Wed, Thur)
tel#  617-795-0890 (Mon, Fri)
cell# 617-480-9877
[see attachment: "message0.html", size: 4611 bytes]


Attachments:

message0.html
http://collab.sakaiproject.org/access/content/attachment/129cadfc-667c-4371-80e2-b0647583b67c/message0.html

----------------------
This automatic notification message was sent by Sakai Collab 
(http://collab.sakaiproject.org/portal) from the DG: Development site.
You can modify how you receive notifications at My Workspace > Preferences.