[Building Sakai] Sakai 2.9.0 MySQL DB Conversion, Lessons - new index fails to be created if LB already exists

[Warwick Chapman]

Hi All

Can confirm this - I dropped the indexes and re-reran the section of the
conversion script and all seems to be working well.

Also applies to permissions and other entries which may have already been
created in instances where LessonBuilder was already being used with 2.8.



-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com


On Mon, Jan 28, 2013 at 7:46 PM, Gast, Cynthia (cmw6s) <
cmw6s at eservices.virginia.edu> wrote:

>  Hi again:
>
> I found an issue in the 2.9.0 MySQL DB conversion script for Lesson
> Builder:  the 'create index' statements assume each index does not already
> exist, but we have Lesson Builder installed with 2.8.1 and many of the
> indexes do exist, so their 290 creation shows 'Duplicate key name'ERRORs, which masks the fact that one of the indexes has been redefined.
>
> This index, in particular, is of concern:
>
>     create index lesson_builder_log_index on
> lesson_builder_log(userId,itemId, studentPageId);
>
>
> This preexisting index originally was on 2 columns; now it is on 3 -- it
> fails to create, so the index is now incorrect for 2.9.0.
>
> To fix this, the index can be dropped and then created:
>
> ALTER TABLE lesson_builder_log  DROP INDEX `lesson_builder_log_index`;
> create index lesson_builder_log_index on lesson_builder_log(userId,itemId,
> studentPageId);
>
> Note: here are the indexes that we already have in our 2.8.1 DB:
> lesson_builder_comments_itemid_author
> lesson_builder_student_pages_pageId
> lesson_builder_student_pages_itemId
> lesson_builder_log_index
> lesson_builder_log_index3
> lesson_builder_log_index2
> lesson_builder_groups_itemid
> lesson_builder_pages_pageid
> lesson_builder_pages_toolid
> lesson_builder_items_pageid
> lesson_builder_items_sakaiid
>
> So, these indexes are new for us with the 290 upgrade:
> lesson_builder_student_pages_index
> lesson_builder_comments_uuid
> lesson_builder_comments_author
>
>
> Let me know if I should create a JIRA issue for this; I could not find one
> about this issue.
> Thank-you,
> Cynthia Gast @ UVa
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130131/04c25ee0/attachment.html