[WG: Sakai QA] SAK-19894: sakai-2.8.0 conversion script testing (MySQL 5.1) -- first run
Anthony Whyte
arwhyte at umich.edu
Mon Jan 31 12:13:31 PST 2011
First Liquibase run comparing an auto.ddl-generated sakai-2.8.0-b04 MySQL 5.1 db against a sakai-2.7.1 MySQL 5.1 db upgraded to 2.8.0 using trunk. Diff'ing between the two databases reveals an anemic 2.7.1->2.8.0 converted db. The missing tables, columns, etc. encountered tend to be clustered around the following projects:
announcement
jobscheduler
profile2
reset-pass (account validator)
sitestats
shortenedurl
In short, the conversion scripts are incomplete at present and constitute a 2.8.0 blocker. If you are responsible for missing scripts please add them and then let me know when complete so that I can test the scripts again.
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
2.8.0 auto.ddl=true Missing Tables: [EXPECTED -- reports tool removed]
report_xsl_file
reports_def_xml
reports_param
reports_report
reports_result
2.8.0 auto.ddl=true Unexpected Tables: [UNEXPECTED -- conversion scripts missing CREATE TABLE statements]
profile_company_profiles_t
profile_gallery_images_t
profile_images_official_t
profile_kudos_t
profile_message_participants_t
profile_message_threads_t
profile_messages_t
profile_social_info_t
sakai_message_bundle
scheduler_trigger_events
sst_presences
url_randomised_mappings_t
validationaccount_item
Missing Views: NONE
Unexpected Views: NONE
2.8.0 auto.ddl=true Missing Columns: [UNEXPECTED -- do we need to move data stored in these fields elsewhere?]
profile_privacy_t.ACADEMIC_INFO
profile_privacy_t.SEARCH
2.8.0 auto.ddl=true Unexpected Columns: [UNEXPECTED -- conversion scripts missing ALTER TABLE...ADD COLUMN statements]
announcement_message.MESSAGE_ORDER
poll_poll.POLL_IS_PUBLIC
profile_preferences_t.EMAIL_MESSAGE_NEW
profile_preferences_t.EMAIL_MESSAGE_REPLY
profile_preferences_t.SHOW_GALLERY_FEED
profile_preferences_t.SHOW_KUDOS
profile_preferences_t.USE_OFFICIAL_IMAGE
profile_privacy_t.BUSINESS_INFO
profile_privacy_t.MESSAGES
profile_privacy_t.MY_KUDOS
profile_privacy_t.MY_PICTURES
profile_privacy_t.SOCIAL_NETWORKING_INFO
profile_privacy_t.STAFF_INFO
profile_privacy_t.STUDENT_INFO
2.8.0 auto.ddl=true Changed Columns: [DATA TYPE MISMATCHES]
email_template_item.HTMLMESSAGE
from TEXT to LONGTEXT
gb_grade_record_t.USER_ENTERED_GRADE
from VARCHAR(127) to VARCHAR(255)
profile_images_t.RESOURCE_MAIN
from VARCHAR(255) to TEXT
profile_images_t.RESOURCE_THUMB
from VARCHAR(255) to TEXT
2.8.0 auto.ddl=true 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)
2.8.0 auto.ddl=true 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)
2.8.0 auto.ddl=true Missing Primary Keys: [EXPECTED, reports removed]
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)
2.8.0 auto.ddl=true Unexpected Primary Keys:
null on profile_company_profiles_t(ID)
null on profile_gallery_images_t(ID)
null on profile_images_official_t(USER_UUID)
null on profile_kudos_t(USER_UUID)
null on profile_message_participants_t(ID)
null on profile_message_threads_t(ID)
null on profile_messages_t(ID)
null on profile_social_info_t(USER_UUID)
null on sakai_message_bundle(ID)
null on scheduler_trigger_events(uuid)
null on sst_presences(ID)
null on url_randomised_mappings_t(ID)
null on validationaccount_item(id)
Missing Unique Constraints: NONE
Unexpected Unique Constraints: NONE
2.8.0 auto.ddl=true 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)
FKD3B8420DC896C347 unique on reports_param(reportId)
FKA6F2CE9DC896C347 unique on reports_result(reportId)
2.8.0 auto.ddl=true 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3829 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-qa/attachments/20110131/21c471af/attachment.bin
More information about the sakai-qa
mailing list