AnsweredAssumed Answered

Upgrade 32r2 -> 40D (Centos, Mysql)

Question asked by dranakan on Sep 27, 2012
Hi,

I doing an upgrade from 32r2 to 40D (On Centos 6.3 64bit, Mysql).

I have install 34d and 4.0D. All works good from 32r2 to 34d but from 34d to 40D I get WARN in logs. Is it serious ?
I am doing tests but all seems working well…

2012-09-27 08:34:26,820  WARN  [domain.schema.SchemaBootstrap] [main] Schema validation found 76 potential problems, results written to: /opt/Alfresco/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3492945341986215865.txt


Difference: missing column from database, expected at path: .alf_acl_change_set.commit_time_ms
Difference: unexpected column found in database with path: .alf_acl_change_set.version
Difference: missing index from database, expected at path: .alf_acl_change_set.idx_alf_acs_ctms
Difference: expected index .alf_acl_member.aclm_acl_id.name="aclm_acl_id", but was .alf_acl_member.acl_id.name="acl_id"
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_an
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_mod
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_dis
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_app
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_dis
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_model
Difference: expected index .alf_audit_app.idx_alf_aud_app_an.name="idx_alf_aud_app_an", but was .alf_audit_app.idx_alf_audit_app_app.name="idx_alf_audit_app_app"
Difference: expected index .alf_audit_app.fk_alf_aud_app_mod.name="fk_alf_aud_app_mod", but was .alf_audit_app.fk_alf_audit_app_model.name="fk_alf_audit_app_model"
Difference: expected index .alf_audit_app.fk_alf_aud_app_dis.name="fk_alf_aud_app_dis", but was .alf_audit_app.fk_alf_audit_app_dis.name="fk_alf_audit_app_dis"
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_app
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_use
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_pro
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_app
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_prop
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_user
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_app.name="fk_alf_aud_ent_app", but was .alf_audit_entry.fk_alf_audit_ent_app.name="fk_alf_audit_ent_app"
Difference: expected index .alf_audit_entry.idx_alf_aud_ent_tm.name="idx_alf_aud_ent_tm", but was .alf_audit_entry.idx_alf_audit_ent_time.name="idx_alf_audit_ent_time"
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_use.name="fk_alf_aud_ent_use", but was .alf_audit_entry.fk_alf_audit_ent_user.name="fk_alf_audit_ent_user"
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_pro.name="fk_alf_aud_ent_pro", but was .alf_audit_entry.fk_alf_audit_ent_prop.name="fk_alf_audit_ent_prop"
Difference: missing foreign key from database, expected at path: .alf_audit_model.fk_alf_aud_mod_cd
Difference: unexpected foreign key found in database with path: .alf_audit_model.fk_alf_audit_model_cd
Difference: expected index .alf_audit_model.idx_alf_aud_mod_cr.name="idx_alf_aud_mod_cr", but was .alf_audit_model.idx_alf_audit_cfg_crc.name="idx_alf_audit_cfg_crc"
Difference: expected index .alf_audit_model.fk_alf_aud_mod_cd.name="fk_alf_aud_mod_cd", but was .alf_audit_model.fk_alf_audit_model_cd.name="fk_alf_audit_model_cd"
Difference: missing column from database, expected at path: .alf_node.locale_id
Difference: expected column .alf_node.acl_id.order="9", but was .alf_node.acl_id.order="8"
Difference: expected column .alf_node.audit_creator.order="10", but was .alf_node.audit_creator.order="9"
Difference: expected column .alf_node.audit_created.order="11", but was .alf_node.audit_created.order="10"
Difference: expected column .alf_node.audit_modifier.order="12", but was .alf_node.audit_modifier.order="11"
Difference: expected column .alf_node.audit_modified.order="13", but was .alf_node.audit_modified.order="12"
Difference: expected column .alf_node.audit_accessed.order="14", but was .alf_node.audit_accessed.order="13"
Difference: missing foreign key from database, expected at path: .alf_node.fk_alf_node_loc
Difference: missing index from database, expected at path: .alf_node.idx_alf_node_txn_del
Difference: missing index from database, expected at path: .alf_node.fk_alf_node_loc
Difference: missing column from database, expected at path: .alf_node_assoc.assoc_index
Difference: expected index .alf_node_assoc.fk_alf_nass_snode.columnNames[1]="type_qname_id", but was .alf_node_assoc.fk_alf_nass_snode.columnNames="[source_node_id]"
Difference: expected index .alf_node_assoc.fk_alf_nass_snode.columnNames[2]="assoc_index", but was .alf_node_assoc.fk_alf_nass_snode.columnNames="[source_node_id]"
Difference: expected index .alf_node_assoc.fk_alf_nass_tnode.columnNames[1]="type_qname_id", but was .alf_node_assoc.fk_alf_nass_tnode.columnNames="[target_node_id]"
Difference: expected index .alf_prop_class.idx_alf_propc_crc.name="idx_alf_propc_crc", but was .alf_prop_class.idx_alf_prop_class_crc.name="idx_alf_prop_class_crc"
Difference: expected index .alf_prop_class.idx_alf_propc_clas.name="idx_alf_propc_clas", but was .alf_prop_class.idx_alf_prop_class_class.name="idx_alf_prop_class_class"
Difference: expected index .alf_prop_date_value.idx_alf_propdt_dt.name="idx_alf_propdt_dt", but was .alf_prop_date_value.idx_alf_prop_date_units.name="idx_alf_prop_date_units"
Difference: expected index .alf_prop_double_value.idx_alf_propd_val.name="idx_alf_propd_val", but was .alf_prop_double_value.idx_alf_prop_dbl_val.name="idx_alf_prop_dbl_val"
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_root
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_key
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_val
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_key
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_root
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_val
Difference: expected index .alf_prop_link.fk_alf_propln_key.name="fk_alf_propln_key", but was .alf_prop_link.fk_alf_prop_link_key.name="fk_alf_prop_link_key"
Difference: expected index .alf_prop_link.fk_alf_propln_val.name="fk_alf_propln_val", but was .alf_prop_link.fk_alf_prop_link_val.name="fk_alf_prop_link_val"
Difference: expected index .alf_prop_link.idx_alf_propln_for.name="idx_alf_propln_for", but was .alf_prop_link.idx_alf_prop_link_for.name="idx_alf_prop_link_for"
Difference: expected index .alf_prop_string_value.idx_alf_props_crc.name="idx_alf_props_crc", but was .alf_prop_string_value.idx_alf_prop_crc.name="idx_alf_prop_crc"
Difference: expected index .alf_prop_string_value.idx_alf_props_str.name="idx_alf_props_str", but was .alf_prop_string_value.idx_alf_prop_str.name="idx_alf_prop_str"
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v1
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v2
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v3
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_1
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_2
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_3
Difference: expected index .alf_prop_unique_ctx.idx_alf_propuctx.name="idx_alf_propuctx", but was .alf_prop_unique_ctx.idx_alf_prop_unique_ctx.name="idx_alf_prop_unique_ctx"
Difference: expected index .alf_prop_unique_ctx.fk_alf_propuctx_v2.name="fk_alf_propuctx_v2", but was .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_2.name="fk_alf_prop_unique_ctx_2"
Difference: expected index .alf_prop_unique_ctx.fk_alf_propuctx_v3.name="fk_alf_propuctx_v3", but was .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_3.name="fk_alf_prop_unique_ctx_3"
Difference: expected index .alf_prop_value.idx_alf_propv_act.name="idx_alf_propv_act", but was .alf_prop_value.idx_alf_prop_act.name="idx_alf_prop_act"
Difference: expected index .alf_prop_value.idx_alf_propv_per.name="idx_alf_propv_per", but was .alf_prop_value.idx_alf_prop_per.name="idx_alf_prop_per"
Difference: missing table from database, expected at path: .alf_subscriptions
Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_audit_config
Difference: unexpected table found in database with path: .alf_audit_date
Difference: unexpected table found in database with path: .alf_audit_fact
Difference: unexpected table found in database with path: .alf_audit_source
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries


2012-09-27 08:34:39,319  WARN  [domain.schema.SchemaBootstrap] [main] Schema validation found 58 potential problems, results written to: /opt/Alfresco/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Post-Upgrade-4059901726890481042.txt



Difference: expected index .alf_acl_member.aclm_acl_id.name="aclm_acl_id", but was .alf_acl_member.acl_id.name="acl_id"
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_an
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_mod
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_dis
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_app
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_dis
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_model
Difference: expected index .alf_audit_app.idx_alf_aud_app_an.name="idx_alf_aud_app_an", but was .alf_audit_app.idx_alf_audit_app_app.name="idx_alf_audit_app_app"
Difference: expected index .alf_audit_app.fk_alf_aud_app_mod.name="fk_alf_aud_app_mod", but was .alf_audit_app.fk_alf_audit_app_model.name="fk_alf_audit_app_model"
Difference: expected index .alf_audit_app.fk_alf_aud_app_dis.name="fk_alf_aud_app_dis", but was .alf_audit_app.fk_alf_audit_app_dis.name="fk_alf_audit_app_dis"
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_app
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_use
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_pro
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_app
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_prop
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_user
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_app.name="fk_alf_aud_ent_app", but was .alf_audit_entry.fk_alf_audit_ent_app.name="fk_alf_audit_ent_app"
Difference: expected index .alf_audit_entry.idx_alf_aud_ent_tm.name="idx_alf_aud_ent_tm", but was .alf_audit_entry.idx_alf_audit_ent_time.name="idx_alf_audit_ent_time"
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_use.name="fk_alf_aud_ent_use", but was .alf_audit_entry.fk_alf_audit_ent_user.name="fk_alf_audit_ent_user"
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_pro.name="fk_alf_aud_ent_pro", but was .alf_audit_entry.fk_alf_audit_ent_prop.name="fk_alf_audit_ent_prop"
Difference: missing foreign key from database, expected at path: .alf_audit_model.fk_alf_aud_mod_cd
Difference: unexpected foreign key found in database with path: .alf_audit_model.fk_alf_audit_model_cd
Difference: expected index .alf_audit_model.idx_alf_aud_mod_cr.name="idx_alf_aud_mod_cr", but was .alf_audit_model.idx_alf_audit_cfg_crc.name="idx_alf_audit_cfg_crc"
Difference: expected index .alf_audit_model.fk_alf_aud_mod_cd.name="fk_alf_aud_mod_cd", but was .alf_audit_model.fk_alf_audit_model_cd.name="fk_alf_audit_model_cd"
Difference: expected index .alf_prop_class.idx_alf_propc_crc.name="idx_alf_propc_crc", but was .alf_prop_class.idx_alf_prop_class_crc.name="idx_alf_prop_class_crc"
Difference: expected index .alf_prop_class.idx_alf_propc_clas.name="idx_alf_propc_clas", but was .alf_prop_class.idx_alf_prop_class_class.name="idx_alf_prop_class_class"
Difference: expected index .alf_prop_date_value.idx_alf_propdt_dt.name="idx_alf_propdt_dt", but was .alf_prop_date_value.idx_alf_prop_date_units.name="idx_alf_prop_date_units"
Difference: expected index .alf_prop_double_value.idx_alf_propd_val.name="idx_alf_propd_val", but was .alf_prop_double_value.idx_alf_prop_dbl_val.name="idx_alf_prop_dbl_val"
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_root
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_key
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_val
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_key
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_root
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_val
Difference: expected index .alf_prop_link.fk_alf_propln_key.name="fk_alf_propln_key", but was .alf_prop_link.fk_alf_prop_link_key.name="fk_alf_prop_link_key"
Difference: expected index .alf_prop_link.fk_alf_propln_val.name="fk_alf_propln_val", but was .alf_prop_link.fk_alf_prop_link_val.name="fk_alf_prop_link_val"
Difference: expected index .alf_prop_link.idx_alf_propln_for.name="idx_alf_propln_for", but was .alf_prop_link.idx_alf_prop_link_for.name="idx_alf_prop_link_for"
Difference: expected index .alf_prop_string_value.idx_alf_props_crc.name="idx_alf_props_crc", but was .alf_prop_string_value.idx_alf_prop_crc.name="idx_alf_prop_crc"
Difference: expected index .alf_prop_string_value.idx_alf_props_str.name="idx_alf_props_str", but was .alf_prop_string_value.idx_alf_prop_str.name="idx_alf_prop_str"
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v1
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v2
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v3
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_1
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_2
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_3
Difference: expected index .alf_prop_unique_ctx.idx_alf_propuctx.name="idx_alf_propuctx", but was .alf_prop_unique_ctx.idx_alf_prop_unique_ctx.name="idx_alf_prop_unique_ctx"
Difference: expected index .alf_prop_unique_ctx.fk_alf_propuctx_v2.name="fk_alf_propuctx_v2", but was .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_2.name="fk_alf_prop_unique_ctx_2"
Difference: expected index .alf_prop_unique_ctx.fk_alf_propuctx_v3.name="fk_alf_propuctx_v3", but was .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_3.name="fk_alf_prop_unique_ctx_3"
Difference: expected index .alf_prop_value.idx_alf_propv_act.name="idx_alf_propv_act", but was .alf_prop_value.idx_alf_prop_act.name="idx_alf_prop_act"
Difference: expected index .alf_prop_value.idx_alf_propv_per.name="idx_alf_propv_per", but was .alf_prop_value.idx_alf_prop_per.name="idx_alf_prop_per"
Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_audit_config
Difference: unexpected table found in database with path: .alf_audit_date
Difference: unexpected table found in database with path: .alf_audit_fact
Difference: unexpected table found in database with path: .alf_audit_source
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries

Thank you.

Outcomes