AnsweredAssumed Answered

Migration from 4.2.c to 5.1.g Community

Question asked by joko71 on Jul 11, 2016
Latest reply on Aug 8, 2016 by joko71
I'm having a problem with migration on my Win-32 XP Professional VM machine. Server is JBoss 5.1.0 GA with Java 7 JDK and DB is MySQL 5.5.28.
We haven't used Solr in 4.2.c.

I was kinda expecting that upgrade from 4.2.c to 5.1.g will go pretty smooth.

In server.log the first strange occurence was the loop of these lines repeating:


[domain.schema.SchemaBootstrap] Schema validation found 48 potential problems, results written to: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-1323738560616869338.txt
2016-07-11 09:50:06,358 INFO  [STDOUT] (main) 09:50:06,358 INFO  [domain.schema.SchemaBootstrap] Normalized schema dumped to file C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Alfresco\Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-alf_-3847783597295113832.xml.
2016-07-11 09:50:06,358 INFO  [STDOUT] (main) 09:50:06,358 INFO  [domain.schema.SchemaBootstrap] Normalized schema dumped to file C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Alfresco\Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-5836808321826424787.xml.
2016-07-11 09:50:06,358 INFO  [STDOUT] (main) 09:50:06,358 INFO  [domain.schema.SchemaBootstrap] Normalized schema dumped to file C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Alfresco\Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-2347445323115065111.xml.


And then, after a not so small number of iterations, it gave up with the message in the log:


2016-07-11 09:50:11,389 INFO  [STDOUT] (main) 09:50:11,373 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 06110000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1716)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)



2016-07-11 09:50:11,420 INFO  [STDOUT] (main) 09:50:11,420 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06110001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1802)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
   at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
   at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
   at org.jboss.web.deployers.WebModule.start(WebModule.java:97)



Caused by: org.alfresco.error.AlfrescoRuntimeException: 06110000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1716)
   … 79 more
2016-07-11 09:50:11,436 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: 06110001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1802)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)



2016-07-11 09:50:11,452 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: 06110001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1802)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)



Caused by: org.alfresco.error.AlfrescoRuntimeException: 06110000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1716)
   … 79 more
2016-07-11 09:50:11,467 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Exception sending context initialized event to listener instance of class org.alfresco.repo.webdav.WebDAVSessionListener
org.alfresco.error.AlfrescoRuntimeException: 06110001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1802)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)



   at java.lang.Thread.run(Thread.java:722)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 06110000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1716)
   … 79 more


Dumped difference files and verbose server log are in the attachment.

I hope you can help me. Thanks in advance.

Attachments

Outcomes