[WG: Sakai QA] SAK-19088/19894 sakai-2.8.0 MySQL conversion scripts (update)
Maurer, Christopher Wayne
chmaurer at iupui.edu
Thu Feb 3 06:53:52 PST 2011
Quick note about the status of the oracle scripts...
Here are the errors I got when running the scripts for b04:
>[Error] Script lines: 1-2 --------------------------
ORA-01430: column being added already exists in table
Script line 2, statement line 2, column 31
>[Error] Script lines: 3-3 --------------------------
ORA-01430: column being added already exists in table
Script line 3, statement line 1, column 36
>[Error] Script lines: 98-101 -----------------------
ORA-00904: : invalid identifier
Script line 101, statement line 3, column 37
The first 2 are (obviously) already in place. I saw those columns added
in the 2.7.0 scripts.
The last one just needs to have the word "column" removed from the
statement.
I didn't see any other issues on startup.
Chris
On 2/2/11 5:39 PM, "Anthony Whyte" <arwhyte at umich.edu> wrote:
>Steve Swinsburg (profile2) and I (all others) have added the necessary
>CREATE TABLE and ADD COLUMN statements that were missing in the MySQL
>conversion scripts. Not all the missing scripts have been added to the
>Oracle conversion scripts however.
>
>I'm now reviewing changed datatypes, missing keys and indexes as well as
>tickets checked for conversion script changes/additions:
>
>https://jira.sakaiproject.org/secure/IssueNavigator.jspa?mode=hide&request
>Id=12383
>
>Cheers,
>
>Anthony
>
>________________________________
>
>Luthuli:liquibase-1.9.5 arwhyte$ java -jar ./liquibase-1.9.5.jar
>--driver=com.mysql.jdbc.Driver
>--url=jdbc:mysql://127.0.0.1:3306/sakai280convert --username=sakaiuser
>--password=sushi diff
>--baseUrl=jdbc:mysql://127.0.0.1:3306/sakai280autogen
>--baseUsername=sakaiuser --basePassword=sushi
>
>Diff Results:
>Base Database: sakaiuser jdbc:mysql://127.0.0.1:3306/sakai280autogen
>Target Database: sakaiuser jdbc:mysql://127.0.0.1:3306/sakai280convert
>Product Name: EQUAL
>Product Version: EQUAL
>Missing Tables: [EXPECTED]
> report_xsl_file
> reports_def_xml
> reports_param
> reports_report
> reports_result
>Unexpected Tables: NONE
>Missing Views: NONE
>Unexpected Views: NONE
>Missing Columns: NONE
>Unexpected Columns: NONE
>Changed Columns:
> email_template_item.HTMLMESSAGE
> from TEXT to LONGTEXT
> gb_grade_record_t.USER_ENTERED_GRADE
> from VARCHAR(127) to VARCHAR(255)
> poll_poll.POLL_IS_PUBLIC
> now nullable
> profile_gallery_images_t.RESOURCE_MAIN
> from VARCHAR(255) to TEXT
> profile_gallery_images_t.RESOURCE_THUMB
> from VARCHAR(255) to TEXT
> profile_images_t.RESOURCE_MAIN
> from VARCHAR(255) to TEXT
> profile_images_t.RESOURCE_THUMB
> from VARCHAR(255) to TEXT
>Missing Foreign Keys:
> qrtz_trigger_listeners_ibfk_1(qrtz_trigger_listeners.TRIGGER_NAME,
>TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP,
>TRIGGER_NAME, TRIGGER_GROUP ->qrtz_triggers.TRIGGER_NAME, TRIGGER_GROUP,
>TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME,
>TRIGGER_GROUP)
> qrtz_triggers_ibfk_1(qrtz_triggers.JOB_NAME, JOB_GROUP, JOB_NAME,
>JOB_GROUP ->qrtz_job_details.JOB_NAME, JOB_GROUP, JOB_NAME, JOB_GROUP)
> FK6C32ED588EA2574(report_xsl_file.reportDefId
>->reports_def_xml.reportDefId)
> FKA6F2CE9DC896C347(reports_result.reportId, reportId
>->reports_report.reportId, reportId)
>Unexpected Foreign Keys:
> qrtz_trigger_listeners_ibfk_1(qrtz_trigger_listeners.TRIGGER_NAME,
>TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP,
>TRIGGER_NAME, TRIGGER_GROUP ->qrtz_triggers.TRIGGER_NAME, TRIGGER_GROUP,
>TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME,
>TRIGGER_GROUP)
> qrtz_triggers_ibfk_1(qrtz_triggers.JOB_NAME, JOB_GROUP, JOB_NAME,
>JOB_GROUP ->qrtz_job_details.JOB_NAME, JOB_GROUP, JOB_NAME, JOB_GROUP)
>Missing Primary Keys:
> null on report_xsl_file(reportDefId, xslFileHash)
> null on reports_def_xml(reportDefId)
> null on reports_param(paramId)
> null on reports_report(reportId)
> null on reports_result(resultId)
>Unexpected Primary Keys: NONE
>Missing Unique Constraints: NONE
>Unexpected Unique Constraints: NONE
>Missing Indexes:
> ANNOUNCEMENT_MESSAGE_CDD unique on announcement_message(CHANNEL_ID,
>MESSAGE_DATE, DRAFT)
> IE_ANNC_MSG_ATTRIB unique on announcement_message(DRAFT, PUBVIEW,
>OWNER)
> user_type_context_idx unique on mfr_pvt_msg_usr_t(USER_ID,
>TYPE_UUID, CONTEXT_ID, READ_STATUS)
> PROFILE_COMPANY_PROFILES_USER_UUID_I unique on
>profile_company_profiles_t(USER_UUID)
> PROFILE_GALLERY_IMAGES_USER_UUID_I unique on
>profile_gallery_images_t(USER_UUID)
> PROFILE_MESSAGE_PARTICIPANT_DELETED_I unique on
>profile_message_participants_t(MESSAGE_DELETED)
> PROFILE_MESSAGE_PARTICIPANT_MESSAGE_ID_I unique on
>profile_message_participants_t(MESSAGE_ID)
> PROFILE_MESSAGE_PARTICIPANT_READ_I unique on
>profile_message_participants_t(MESSAGE_READ)
> PROFILE_MESSAGE_PARTICIPANT_UUID_I unique on
>profile_message_participants_t(PARTICIPANT_UUID)
> PROFILE_MESSAGES_DATE_POSTED_I unique on
>profile_messages_t(DATE_POSTED)
> PROFILE_MESSAGES_FROM_UUID_I unique on profile_messages_t(FROM_UUID)
> PROFILE_MESSAGES_THREAD_I unique on
>profile_messages_t(MESSAGE_THREAD)
> FKD3B8420DC896C347 unique on reports_param(reportId)
> FKA6F2CE9DC896C347 unique on reports_result(reportId)
> KEY_INDEX unique on url_randomised_mappings_t(TINY)
>Unexpected Indexes:
> ANNOUNCEMENT_MESSAGE_CDD unique on announcement_message(CHANNEL_ID,
>MESSAGE_DATE, MESSAGE_ORDER, DRAFT)
> IE_ANNC_MSG_ATTRIB unique on announcement_message(DRAFT, PUBVIEW,
>OWNER, MESSAGE_ORDER)
> ASSESSMENTGRADINGID on sam_itemgrading_t(ASSESSMENTGRADINGID,
>PUBLISHEDITEMID, PUBLISHEDITEMTEXTID, AGENTID, PUBLISHEDANSWERID)
>Missing Sequences: NONE
>Unexpected Sequences: NONE
>
>_______________________________________________
>sakai-qa mailing list
>sakai-qa at collab.sakaiproject.org
>http://collab.sakaiproject.org/mailman/listinfo/sakai-qa
>
>TO UNSUBSCRIBE: send email to
>sakai-qa-unsubscribe at collab.sakaiproject.org with a subject of
>"unsubscribe"
More information about the sakai-qa
mailing list