topic Re: Migrating from windows to Ubuntu in Alfresco Archive

Migrating from windows to Ubuntu

tbee — Tue, 06 Jul 2010 09:59:08 GMT

Since I have problems with CIFS on windows, I'm in the process of migrating Alfresco 3.2r2 to Ubuntu (CIFS worked like that during a test). I started with a working Ubuntu setup running alfresco 3.2 (not r2). Next I created a new mysql database "alfresco2" and imported the mysqldump from the windows

Re: Migrating from windows to Ubuntu

mrogers — Tue, 06 Jul 2010 10:57:26 GMT

You can't migrate backwards (3.2r2 back to older version 3.2).

I suggest you migrate to exactly the same version of alfresco.   Take the WAR file from your source and use it for your target.

Edit - is that what you did?

What did you "rename the existing WAR to"   Did it still have the extension .war if so you will still have the "old" alfresco causing chaos?

The update should not run if the version is the same. That it tried to do so indicates that the version is not correct.

There should be more information in the stack trace from mysql.   I suspect some sort of permission error or an error restoring your database.

Re: Migrating from windows to Ubuntu

tbee — Tue, 06 Jul 2010 11:11:50 GMT

You can't migrate backwards (3.2r2 back to older version 3.2).

I suggest you migrate to exactly the same version of alfresco. Take the WAR file from your source and use it for your target.

I have an Alfresco that runs 3.2 and I am copying the 3.2r2 WAR into it. The database also is 3.2 but I exported the 3.2r2 and imported it. So for all means and purposes the Ubuntu 3.2 version is then running 3.2r2, but it still is trying to update the schema.

Re: Migrating from windows to Ubuntu

tbee — Tue, 06 Jul 2010 11:24:41 GMT


SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: 06060000 Schema auto-update failed
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1386)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1258)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
Caused by: java.sql.SQLException: Can't create table 'alfresco2.#sql-7fc_83' (errno: 121)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1092)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1046)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:744)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1258)
        … 39 more
Jul 6, 2010 7:21:56 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Jul 6, 2010 7:21:56 AM org.apache.catalina.core.ApplicationContext log
INFO: Shutting down Log4J
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Migrating from windows to Ubuntu

tbee — Tue, 06 Jul 2010 14:34:21 GMT

Ok. This is really really strange. I did a complete new install; Ubuntu 10 and Alfresco 3.3. Works. Then I imported the mysql 3.2r2 database and restarted Alfresco: same error!

org.alfresco.error.AlfrescoRuntimeException: 06060000 Schema auto-update failed
Caused by: java.sql.SQLException: Can't create table 'alfresco.#sql-138e_36' (errno: 121)

How can this be? This is Alfresco 3.3!

Re: Migrating from windows to Ubuntu

tbee — Tue, 06 Jul 2010 15:13:32 GMT

Making the mysqldump from Ubuntu instead of Windows does not make a difference.

I'm running out of options.

Re: Migrating from windows to Ubuntu

tbee — Thu, 08 Jul 2010 12:09:11 GMT

Ok. It seems that this may be caused by the fact that Alfresco's installation on windows has the JBMP_* table filenames in lowercase and on Linux these filenames are uppercase.

On windows show tables gives:

+——————————–+
| Tables_in_alfresco             |
+——————————–+
| alf_access_control_entry       |
| alf_access_control_list        |
| alf_ace_context                |
| alf_acl_change_set             |
| alf_acl_member                 |
| alf_activity_feed              |
| alf_activity_feed_control      |
| alf_activity_post              |
| alf_applied_patch              |
| alf_attributes                 |
| alf_audit_app                  |
| alf_audit_config               |
| alf_audit_date                 |
| alf_audit_entry                |
| alf_audit_fact                 |
| alf_audit_model                |
| alf_audit_source               |
| alf_authority                  |
| alf_authority_alias            |
| alf_child_assoc                |
| alf_content_clean              |
| alf_content_data               |
| alf_content_url                |
| alf_encoding                   |
| alf_global_attributes          |
| alf_list_attribute_entries     |
| alf_locale                     |
| alf_lock                       |
| alf_lock_resource              |
| alf_map_attribute_entries      |
| alf_mimetype                   |
| alf_namespace                  |
| alf_node                       |
| alf_node_aspects               |
| alf_node_assoc                 |
| alf_node_properties            |
| alf_permission                 |
| alf_prop_class                 |
| alf_prop_date_value            |
| alf_prop_double_value          |
| alf_prop_link                  |
| alf_prop_root                  |
| alf_prop_serializable_value    |
| alf_prop_string_value          |
| alf_prop_unique_ctx            |
| alf_prop_value                 |
| alf_qname                      |
| alf_server                     |
| alf_store                      |
| alf_transaction                |
| alf_usage_delta                |
| alf_version_count              |
| avm_aspects                    |
| avm_child_entries              |
| avm_history_links              |
| avm_merge_links                |
| avm_node_properties            |
| avm_nodes                      |
| avm_store_properties           |
| avm_stores                     |
| avm_version_layered_node_entry |
| avm_version_roots              |
| jbpm_action                    |
| jbpm_bytearray                 |
| jbpm_byteblock                 |
| jbpm_comment                   |
| jbpm_decisionconditions        |
| jbpm_delegation                |
| jbpm_event                     |
| jbpm_exceptionhandler          |
| jbpm_job                       |
| jbpm_log                       |
| jbpm_moduledefinition          |
| jbpm_moduleinstance            |
| jbpm_node                      |
| jbpm_pooledactor               |
| jbpm_processdefinition         |
| jbpm_processinstance           |
| jbpm_runtimeaction             |
| jbpm_swimlane                  |
| jbpm_swimlaneinstance          |
| jbpm_task                      |
| jbpm_taskactorpool             |
| jbpm_taskcontroller            |
| jbpm_taskinstance              |
| jbpm_token                     |
| jbpm_tokenvariablemap          |
| jbpm_transition                |
| jbpm_variableaccess            |
| jbpm_variableinstance          |
+——————————–+‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

On Ubunut show tables gives:

+——————————–+
| Tables_in_alfresco             |
+——————————–+
| JBPM_ACTION                    |
| JBPM_BYTEARRAY                 |
| JBPM_BYTEBLOCK                 |
| JBPM_COMMENT                   |
| JBPM_DECISIONCONDITIONS        |
| JBPM_DELEGATION                |
| JBPM_EVENT                     |
| JBPM_EXCEPTIONHANDLER          |
| JBPM_JOB                       |
| JBPM_LOG                       |
| JBPM_MODULEDEFINITION          |
| JBPM_MODULEINSTANCE            |
| JBPM_NODE                      |
| JBPM_POOLEDACTOR               |
| JBPM_PROCESSDEFINITION         |
| JBPM_PROCESSINSTANCE           |
| JBPM_RUNTIMEACTION             |
| JBPM_SWIMLANE                  |
| JBPM_SWIMLANEINSTANCE          |
| JBPM_TASK                      |
| JBPM_TASKACTORPOOL             |
| JBPM_TASKCONTROLLER            |
| JBPM_TASKINSTANCE              |
| JBPM_TOKEN                     |
| JBPM_TOKENVARIABLEMAP          |
| JBPM_TRANSITION                |
| JBPM_VARIABLEACCESS            |
| JBPM_VARIABLEINSTANCE          |
| alf_access_control_entry       |
| alf_access_control_list        |
| alf_ace_context                |
| alf_acl_change_set             |
| alf_acl_member                 |
| alf_activity_feed              |
| alf_activity_feed_control      |
| alf_activity_post              |
| alf_applied_patch              |
| alf_attributes                 |
| alf_audit_app                  |
| alf_audit_config               |
| alf_audit_date                 |
| alf_audit_entry                |
| alf_audit_fact                 |
| alf_audit_model                |
| alf_audit_source               |
| alf_authority                  |
| alf_authority_alias            |
| alf_child_assoc                |
| alf_content_clean              |
| alf_content_data               |
| alf_content_url                |
| alf_encoding                   |
| alf_global_attributes          |
| alf_list_attribute_entries     |
| alf_locale                     |
| alf_lock                       |
| alf_lock_resource              |
| alf_map_attribute_entries      |
| alf_mimetype                   |
| alf_namespace                  |
| alf_node                       |
| alf_node_aspects               |
| alf_node_assoc                 |
| alf_node_properties            |
| alf_permission                 |
| alf_prop_class                 |
| alf_prop_date_value            |
| alf_prop_double_value          |
| alf_prop_link                  |
| alf_prop_root                  |
| alf_prop_serializable_value    |
| alf_prop_string_value          |
| alf_prop_unique_ctx            |
| alf_prop_value                 |
| alf_qname                      |
| alf_server                     |
| alf_store                      |
| alf_transaction                |
| alf_usage_delta                |
| alf_version_count              |
| avm_aspects                    |
| avm_child_entries              |
| avm_history_links              |
| avm_merge_links                |
| avm_node_properties            |
| avm_nodes                      |
| avm_store_properties           |
| avm_stores                     |
| avm_version_layered_node_entry |
| avm_version_roots              |
+——————————–+
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This means that Alfresco create the tables with different case on each OS?

Re: Migrating from windows to Ubuntu

tbee — Thu, 08 Jul 2010 12:42:52 GMT

To be more exact; the Alfresco community edition windows installation has not configured mysql so that easy migration to Linux is possible.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

I have 'sed"ed all JBPM tables in the dump from lowercase to uppercase and then it worked.

cat $1 |
sed "s/\`jbpm_action\`/\`JBPM_ACTION\`/g" |
sed "s/\`jbpm_bytearray\`/\`JBPM_BYTEARRAY\`/g" |
sed "s/\`jbpm_byteblock\`/\`JBPM_BYTEBLOCK\`/g" |
sed "s/\`jbpm_comment\`/\`JBPM_COMMENT\`/g" |
sed "s/\`jbpm_decisionconditions\`/\`JBPM_DECISIONCONDITIONS\`/g" |
sed "s/\`jbpm_delegation\`/\`JBPM_DELEGATION\`/g" |
sed "s/\`jbpm_event\`/\`JBPM_EVENT\`/g" |
sed "s/\`jbpm_exceptionhandler\`/\`JBPM_EXCEPTIONHANDLER\`/g" |
sed "s/\`jbpm_job\`/\`JBPM_JOB\`/g" |
sed "s/\`jbpm_log\`/\`JBPM_LOG\`/g" |
sed "s/\`jbpm_moduledefinition\`/\`JBPM_MODULEDEFINITION\`/g" |
sed "s/\`jbpm_moduleinstance\`/\`JBPM_MODULEINSTANCE\`/g" |
sed "s/\`jbpm_node\`/\`JBPM_NODE\`/g" |
sed "s/\`jbpm_pooledactor\`/\`JBPM_POOLEDACTOR\`/g" |
sed "s/\`jbpm_processdefinition\`/\`JBPM_PROCESSDEFINITION\`/g" |
sed "s/\`jbpm_processinstance\`/\`JBPM_PROCESSINSTANCE\`/g" |
sed "s/\`jbpm_runtimeaction\`/\`JBPM_RUNTIMEACTION\`/g" |
sed "s/\`jbpm_swimlane\`/\`JBPM_SWIMLANE\`/g" |
sed "s/\`jbpm_swimlaneinstance\`/\`JBPM_SWIMLANEINSTANCE\`/g" |
sed "s/\`jbpm_task\`/\`JBPM_TASK\`/g" |
sed "s/\`jbpm_taskactorpool\`/\`JBPM_TASKACTORPOOL\`/g" |
sed "s/\`jbpm_taskcontroller\`/\`JBPM_TASKCONTROLLER\`/g" |
sed "s/\`jbpm_taskinstance\`/\`JBPM_TASKINSTANCE\`/g" |
sed "s/\`jbpm_token\`/\`JBPM_TOKEN\`/g" |
sed "s/\`jbpm_tokenvariablemap\`/\`JBPM_TOKENVARIABLEMAP\`/g" |
sed "s/\`jbpm_transition\`/\`JBPM_TRANSITION\`/g" |
sed "s/\`jbpm_variableaccess\`/\`JBPM_VARIABLEACCESS\`/g" |
sed "s/\`jbpm_variableinstance\`/\`JBPM_VARIABLEINSTANCE\`/g" |
cat
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍