Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Content Management
- Alfresco
- Alfresco Archive
- Re: Upgrade from Alfresco Labs v3.0 d to 3.4a CE
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Upgrade from Alfresco Labs v3.0 d to 3.4a CE
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2010 10:49 AM
I am doing an upgrade from Alfresco Labs v3.0 to 3.4a but ran into the following error
The schema used by Alfresco Labs 3.0.0 (d-dev @build-number@) schema 1002
Have I missed out anything in the upgrade process ?
The schema used by Alfresco Labs 3.0.0 (d-dev @build-number@) schema 1002
Have I missed out anything in the upgrade process ?
15:33:13,730 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
15:36:24,698 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 09180000 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:1388)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
15:36:24,700 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 09180001 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1506)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 09180000 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:1388)
… 34 more
Oct 18, 2010 3:36:24 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Oct 18, 2010 3:36:24 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: A web application registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-4] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-5] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-6] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-7] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-8] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-9] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-10] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesStopTimerThread
SEVERE: A web application appears to have started a TimerThread named [Timer-0] via the java.util.Timer API but has failed to stop it. To prevent a memory leak, the timer (and hence the associated thread) has been forcibly cancelled.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Thread-13] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.ClassFactory$1@673c2a08]) and a value of type [java.util.WeakHashMap] (value [{class org.alfresco.repo.audit.model._3.DataGenerators=java.lang.ref.WeakReference@78d88d3e, class org.alfresco.repo.audit.model._3.Audit=java.lang.ref.WeakReference@51211f6d, class org.alfresco.repo.audit.model._3.Application=java.lang.ref.WeakReference@559656b7, class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@1173447, class org.alfresco.repo.audit.model._3.PathMappings=java.lang.ref.WeakReference@1a6921e0, class org.alfresco.repo.audit.model._3.DataExtractor=java.lang.ref.WeakReference@6c2f06ab, class org.alfresco.repo.audit.model._3.AuditPath=java.lang.ref.WeakReference@35efc0a, class org.alfresco.repo.audit.model._3.RecordValue=java.lang.ref.WeakReference@50f4f640, class java.util.ArrayList=java.lang.ref.WeakReference@2530d46, class org.alfresco.repo.audit.model._3.PathMap=java.lang.ref.WeakReference@1a8c6fdb, class org.alfresco.repo.audit.model._3.GenerateValue=java.lang.ref.WeakReference@7a03a07a, class org.alfresco.repo.audit.model._3.DataExtractors=java.lang.ref.WeakReference@41ce82b, class org.alfresco.repo.audit.model._3.DataGenerator=java.lang.ref.WeakReference@5ce6129}]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@304ccdb9]) and a value of type [com.sun.xml.bind.v2.runtime.Coordinator[]] (value [[Lcom.sun.xml.bind.v2.runtime.Coordinator;@2564575]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@6dea0585]) and a value of type [org.apache.cxf.bus.CXFBusImpl] (value [org.apache.cxf.bus.CXFBusImpl@1f109723]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 18, 2010 3:36:24 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@7a328ac3]) and a value of type [org.alfresco.util.CachingDateFormat] (value [yyyy-MM-dd]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Oct 18, 2010 3:36:26 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
15:36:32,205 INFO [extensions.webscripts.DeclarativeRegistry] Registered 301 Web Scripts (+0 failed), 309 URLs
15:36:32,207 INFO [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
15:36:32,207 INFO [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
15:36:32,637 INFO [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2269.7249ms)
15:36:32,725 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
15:36:32,795 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
15:36:32,906 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
15:36:32,910 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
15:36:33,087 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
15:36:33,092 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
Oct 18, 2010 3:36:34 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive wcmqs.war
WARN : org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'baseUrl' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.lang.String) throws java.net.URISyntaxException]: [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.net.URI)]
Oct 18, 2010 3:36:37 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive awe.war
Oct 18, 2010 3:36:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Oct 18, 2010 3:36:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
Oct 18, 2010 3:36:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
Oct 18, 2010 3:36:40 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Oct 18, 2010 3:36:40 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Oct 18, 2010 3:36:40 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/59 config=null
Oct 18, 2010 3:36:40 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 245080 ms
Exception in thread "Thread-15" org.apache.chemistry.opencmis.commons.exceptions.CmisObjectNotFoundException: Not Found
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:403)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.read(AbstractAtomPubService.java:483)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.getRepositoriesInternal(AbstractAtomPubService.java:635)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:68)
at org.apache.chemistry.opencmis.client.bindings.impl.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:85)
at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:108)
at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.getRepository(GuestSessionFactoryImpl.java:105)
at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.run(GuestSessionFactoryImpl.java:115)
at java.lang.Thread.run(Thread.java:619)
Labels:
- Labels:
-
Archive
8 REPLIES 8
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2010 04:10 PM
"org.alfresco.error.AlfrescoRuntimeException: 09180000 A previous schema upgrade failed or was not completed. Revert to the original database before attempting the upgrade again."
You are trying to upgrade from an unknown version since you carried on using Alfresco after an upgrade failed. What you should have done is rolled back your previous upgrade attempt after it failed.
It may not be as bad as that sounds but you will need to study the databases patches that have been applied to your system and in particular any failures. There's a table of patches applied in the database, take a look at that.
You are trying to upgrade from an unknown version since you carried on using Alfresco after an upgrade failed. What you should have done is rolled back your previous upgrade attempt after it failed.
It may not be as bad as that sounds but you will need to study the databases patches that have been applied to your system and in particular any failures. There's a table of patches applied in the database, take a look at that.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-22-2010 09:49 AM
Thanks mrogers.
Actually I reverted back the DB again as you suggested, but it keeps saying
I tried dropping the table
It fails saying
Has anyone had this issue with upgrade ? or have I missed out anything in the upgrade path . Any help is appreciated. Thanks
Actually I reverted back the DB again as you suggested, but it keeps saying
previous schema upgrade failed or was not completed. Revert to the original database before attempting the upgrade again.
14:29:39,810 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:34:01,789 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 09220000 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:1388)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
14:34:01,792 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 09220001 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1506)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 09220000 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:1388)
… 34 more
Oct 22, 2010 2:34:01 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Oct 22, 2010 2:34:01 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: A web application registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-4] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-5] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-6] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-7] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-8] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-9] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-10] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesStopTimerThread
SEVERE: A web application appears to have started a TimerThread named [Timer-0] via the java.util.Timer API but has failed to stop it. To prevent a memory leak, the timer (and hence the associated thread) has been forcibly cancelled.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Thread-13] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@33ef546f]) and a value of type [org.apache.cxf.bus.CXFBusImpl] (value [org.apache.cxf.bus.CXFBusImpl@25905e0c]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@290e7918]) and a value of type [org.alfresco.util.CachingDateFormat] (value [yyyy-MM-dd]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.ClassFactory$1@75302bb6]) and a value of type [java.util.WeakHashMap] (value [{class org.alfresco.repo.audit.model._3.PathMap=java.lang.ref.WeakReference@556148eb, class org.alfresco.repo.audit.model._3.GenerateValue=java.lang.ref.WeakReference@65fa6817, class org.alfresco.repo.audit.model._3.AuditPath=java.lang.ref.WeakReference@1ac7f24f, class org.alfresco.repo.audit.model._3.DataGenerator=java.lang.ref.WeakReference@3cf52e45, class org.alfresco.repo.audit.model._3.DataExtractor=java.lang.ref.WeakReference@4b0d347, class org.alfresco.repo.audit.model._3.PathMappings=java.lang.ref.WeakReference@74fedcb8, class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@84cf00a, class org.alfresco.repo.audit.model._3.Application=java.lang.ref.WeakReference@732324c7, class org.alfresco.repo.audit.model._3.Audit=java.lang.ref.WeakReference@843bfdf, class org.alfresco.repo.audit.model._3.DataGenerators=java.lang.ref.WeakReference@17e9cdb6, class java.util.ArrayList=java.lang.ref.WeakReference@76c073fd, class org.alfresco.repo.audit.model._3.DataExtractors=java.lang.ref.WeakReference@54ff23f3, class org.alfresco.repo.audit.model._3.RecordValue=java.lang.ref.WeakReference@3a91521d}]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 22, 2010 2:34:01 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@1aa60bf5]) and a value of type [com.sun.xml.bind.v2.runtime.Coordinator[]] (value [[Lcom.sun.xml.bind.v2.runtime.Coordinator;@b5b0f7e]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Oct 22, 2010 2:34:05 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
Oct 22, 2010 2:34:05 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor manager.xml
Oct 22, 2010 2:34:05 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive wcmqs.war
WARN : org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'baseUrl' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.lang.String) throws java.net.URISyntaxException]: [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.net.URI)]
WARN : net.sf.ehcache.config.ConfigurationFactory - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/opt/alfresco-3.4.a/tomcat/webapps/wcmqs/WEB-INF/lib/ehcache-core-2.0.0.jar!/ehcache-failsafe.xml
Oct 22, 2010 2:34:18 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
14:34:28,885 INFO [extensions.webscripts.DeclarativeRegistry] Registered 301 Web Scripts (+0 failed), 309 URLs
14:34:28,887 INFO [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
14:34:28,887 INFO [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
14:34:29,373 INFO [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 3725.74ms)
14:34:29,538 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:34:29,747 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
14:34:29,931 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:34:29,937 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
14:34:30,055 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:34:30,063 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
Oct 22, 2010 2:34:32 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive awe.war
Oct 22, 2010 2:34:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Oct 22, 2010 2:34:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
Oct 22, 2010 2:34:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
Oct 22, 2010 2:34:40 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Oct 22, 2010 2:34:40 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Oct 22, 2010 2:34:40 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/100 config=null
Oct 22, 2010 2:34:40 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 377420 ms
Exception in thread "Thread-15" org.apache.chemistry.opencmis.commons.exceptions.CmisObjectNotFoundException: Not Found
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:403)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.read(AbstractAtomPubService.java:483)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.getRepositoriesInternal(AbstractAtomPubService.java:635)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:68)
at org.apache.chemistry.opencmis.client.bindings.impl.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:85)
at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:108)
at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.getRepository(GuestSessionFactoryImpl.java:105)
at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.run(GuestSessionFactoryImpl.java:115)
at java.lang.Thread.run(Thread.java:619)I tried dropping the table
drop table alf_bootstrap_lock;and restarted alfresco, but now i could get to see some dbscripts getting executed, but throws some errors with dbscripts actually…
It fails saying
Table 'alf_lock_resource' already exists
14:39:22,034 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:39:27,856 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1563308858465495940.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-Person.sql).
14:46:50,179 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-3418220295187402812.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-LockTables.sql).
14:46:50,192 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
SQL: CREATE TABLE alf_lock_resource
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
qname_ns_id BIGINT NOT NULL,
qname_localname VARCHAR(255) NOT NULL,
CONSTRAINT fk_alf_lockr_ns FOREIGN KEY (qname_ns_id) REFERENCES alf_namespace (id),
PRIMARY KEY (id),
UNIQUE INDEX idx_alf_lockr_key (qname_ns_id, qname_localname)
) TYPE=InnoDB
Error: Table 'alf_lock_resource' already exists
File: /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-3418220295187402812.sql
Line: 19
14:46:50,194 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Table 'alf_lock_resource' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
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:1215)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1165)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:897)
at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:868)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:770)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1375)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
14:46:50,198 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 09220000 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1506)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.SQLException: Table 'alf_lock_resource' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
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:1215)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1165)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:897)
at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:868)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:770)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1375)
… 34 more
Oct 22, 2010 2:46:50 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Oct 22, 2010 2:46:50 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: A web application registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-4] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-5] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-6] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-7] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-8] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-9] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_Worker-10] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesStopTimerThread
SEVERE: A web application appears to have started a TimerThread named [Timer-0] via the java.util.Timer API but has failed to stop it. To prevent a memory leak, the timer (and hence the associated thread) has been forcibly cancelled.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Thread-13] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [DefaultScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@10d65c82]) and a value of type [org.apache.cxf.bus.CXFBusImpl] (value [org.apache.cxf.bus.CXFBusImpl@69536370]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@61a58415]) and a value of type [org.alfresco.util.CachingDateFormat] (value [yyyy-MM-dd]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.ClassFactory$1@3982b0c8]) and a value of type [java.util.WeakHashMap] (value [{class org.alfresco.repo.audit.model._3.AuditPath=java.lang.ref.WeakReference@7782f12f, class org.alfresco.repo.audit.model._3.PathMappings=java.lang.ref.WeakReference@35a881f5, class org.alfresco.repo.audit.model._3.Application=java.lang.ref.WeakReference@49ec1758, class org.alfresco.repo.audit.model._3.RecordValue=java.lang.ref.WeakReference@2af0b852, class org.alfresco.repo.audit.model._3.DataExtractors=java.lang.ref.WeakReference@21d52584, class org.alfresco.repo.audit.model._3.DataGenerator=java.lang.ref.WeakReference@30920e76, class org.alfresco.repo.audit.model._3.DataExtractor=java.lang.ref.WeakReference@44f37de3, class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@4dcde572, class org.alfresco.repo.audit.model._3.Audit=java.lang.ref.WeakReference@892c746, class org.alfresco.repo.audit.model._3.DataGenerators=java.lang.ref.WeakReference@5c58c90f, class org.alfresco.repo.audit.model._3.PathMap=java.lang.ref.WeakReference@48f82726, class org.alfresco.repo.audit.model._3.GenerateValue=java.lang.ref.WeakReference@1bd25537, class java.util.ArrayList=java.lang.ref.WeakReference@dd89c26}]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
Oct 22, 2010 2:46:50 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@7f389e4]) and a value of type [com.sun.xml.bind.v2.runtime.Coordinator[]] (value [[Lcom.sun.xml.bind.v2.runtime.Coordinator;@5e1dbd0]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Oct 22, 2010 2:46:52 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
Oct 22, 2010 2:46:53 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor manager.xml
Oct 22, 2010 2:46:53 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive wcmqs.war
WARN : org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'baseUrl' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.lang.String) throws java.net.URISyntaxException]: [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.net.URI)]
WARN : net.sf.ehcache.config.ConfigurationFactory - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/opt/alfresco-3.4.a/tomcat/webapps/wcmqs/WEB-INF/lib/ehcache-core-2.0.0.jar!/ehcache-failsafe.xml
Oct 22, 2010 2:47:01 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
14:47:07,993 INFO [extensions.webscripts.DeclarativeRegistry] Registered 301 Web Scripts (+0 failed), 309 URLs
14:47:07,995 INFO [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
14:47:07,996 INFO [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
14:47:08,495 INFO [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2873.7012ms)
14:47:08,582 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:47:08,692 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
14:47:08,813 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:47:08,819 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
14:47:08,942 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:47:08,978 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
Oct 22, 2010 2:47:10 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive awe.war
Oct 22, 2010 2:47:15 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Oct 22, 2010 2:47:15 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
Oct 22, 2010 2:47:15 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
Oct 22, 2010 2:47:15 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Oct 22, 2010 2:47:15 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Oct 22, 2010 2:47:15 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/35 config=null
Oct 22, 2010 2:47:15 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 525395 ms
Exception in thread "Thread-15" org.apache.chemistry.opencmis.commons.exceptions.CmisObjectNotFoundException: Not Found
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:403)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.read(AbstractAtomPubService.java:483)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.getRepositoriesInternal(AbstractAtomPubService.java:635)
at org.apache.chemistry.opencmis.client.bindings.spi.atompub.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:68)
at org.apache.chemistry.opencmis.client.bindings.impl.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:85)
at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:108)
at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.getRepository(GuestSessionFactoryImpl.java:105)
at org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl.run(GuestSessionFactoryImpl.java:115)
at java.lang.Thread.run(Thread.java:619)Has anyone had this issue with upgrade ? or have I missed out anything in the upgrade path . Any help is appreciated. Thanks
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-01-2010 11:18 AM
Has anyone faced this issue with upgrade ?
My upgrade fails throwing the following error
My upgrade fails throwing the following error
15:06:53,666 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
15:06:57,869 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2228443775384316204.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-Person.sql).
15:14:57,504 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-688607133524075911.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-LockTables.sql).
15:14:57,517 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
SQL: CREATE TABLE alf_lock_resource
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
qname_ns_id BIGINT NOT NULL,
qname_localname VARCHAR(255) NOT NULL,
CONSTRAINT fk_alf_lockr_ns FOREIGN KEY (qname_ns_id) REFERENCES alf_namespace (id),
PRIMARY KEY (id),
UNIQUE INDEX idx_alf_lockr_key (qname_ns_id, qname_localname)
) TYPE=InnoDB
Error: Table 'alf_lock_resource' already exists
File: /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-688607133524075911.sql
Line: 19
15:14:57,519 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Table 'alf_lock_resource' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
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:1215)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1165)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:897)
at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:868)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:770)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1375)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
15:14:57,522 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 10010000 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1506)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.SQLException: Table 'alf_lock_resource' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
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:1215)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1165)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:897)
at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:868)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:770)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1375)
… 34 more
Nov 1, 2010 3:14:57 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2010 12:29 PM
I'm having the same problem.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2010 07:50 AM
Lot of users are having the same issue with 3.4a CE , is it something to do with the changes in the db upgrade scripts or something missed out for the upgrade ?
@gernot - Could you please post the log
@gernot - Could you please post the log
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2010 05:51 AM
Hello
I am also experiencing this problem and can provide the logs you are requesting. Please let me know if there's more information you require. Just some background in case it helps.
Our company data in on Alfresco 3.2r on a Windows 2003 server in the cloud. I have backed the DMS solution on this server as indicated in the Aldresco WIKI article.
As a test I installed a Windows 2003 server on a Virtual Machine and installed Alfresco 3.4a and validated that it was functional before restoring my 3.2 data on it.
This upgrade failed with the details provided in the logs that are attached.
Stdout error log
stderr log
If reverted the system back to the original database and alf_data directory the system starts up successfully but then when try again to upgrade it fails.
I then tried to upgrade from 3.2r to Alfresco 3.3g as suggested by someone on the forums. This was successful as this version of Alfresco was still using Hiberate for the data layer communication.
I then tried to upgrade from 3.3g to 3.4a and again this failed with the messages displayed in the attached logs.
There are various posts about problems with the upgrade schema_database scripts and as indicated above by Mr Rogers manual intervention is required. I haven't attempted this manual intervention yet as there not much detail around how to do it.
I have looked in the database and found only these tables; I assume you are refering to the Alfresco database?
mysql> show tables;
+——————————–+
| 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_bootstrap_lock |
| alf_child_assoc |
| 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 |
+——————————–+
Thank you for your advice but could you provide us with a little more detail? Like whaty database patches and what is the name of the table you are refering to.
I have noticed that some scritps and XML files are written here; C:\WINDOWS\TEMP\Alfresco. When the failure occurs there are multiple files as the system tried to upgrade the database and can't.
I am also experiencing this problem and can provide the logs you are requesting. Please let me know if there's more information you require. Just some background in case it helps.
Our company data in on Alfresco 3.2r on a Windows 2003 server in the cloud. I have backed the DMS solution on this server as indicated in the Aldresco WIKI article.
As a test I installed a Windows 2003 server on a Virtual Machine and installed Alfresco 3.4a and validated that it was functional before restoring my 3.2 data on it.
This upgrade failed with the details provided in the logs that are attached.
Stdout error log
17:46:08,390 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
17:46:08,421 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
17:46:08,437 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [C:\Alfresco3_4\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\module\test\alfresco-global.properties]
17:46:08,437 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [C:\Alfresco3_4\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\module\tests\alfresco-global.properties]
17:46:08,437 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/C:/Alfresco3_4/tomcat/shared/classes/alfresco-global.properties]
17:46:08,515 INFO [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
17:46:34,468 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
17:46:34,468 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
17:46:43,437 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
17:49:55,593 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 10160000 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:1388)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
17:49:55,593 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 10160001 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1506)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 10160000 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:1388)
… 34 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
17:50:09,828 INFO [extensions.webscripts.DeclarativeRegistry] Registered 256 Web Scripts (+0 failed), 264 URLs
17:50:09,828 INFO [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
17:50:09,828 INFO [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
17:50:10,015 INFO [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2761.718ms)
17:50:10,125 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
17:50:10,281 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
17:50:10,468 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
17:50:10,468 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
17:50:10,640 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
17:50:10,656 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
stderr log
17:46:08,390 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
17:46:08,421 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
17:46:08,437 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [C:\Alfresco3_4\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\module\test\alfresco-global.properties]
17:46:08,437 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [C:\Alfresco3_4\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\module\tests\alfresco-global.properties]
17:46:08,437 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/C:/Alfresco3_4/tomcat/shared/classes/alfresco-global.properties]
17:46:08,515 INFO [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
17:46:34,468 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
17:46:34,468 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
17:46:43,437 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
17:49:55,593 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 10160000 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:1388)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
17:49:55,593 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 10160001 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1506)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
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:546)
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:1277)
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:785)
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:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 10160000 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:1388)
… 34 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
17:50:09,828 INFO [extensions.webscripts.DeclarativeRegistry] Registered 256 Web Scripts (+0 failed), 264 URLs
17:50:09,828 INFO [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
17:50:09,828 INFO [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
17:50:10,015 INFO [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2761.718ms)
17:50:10,125 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
17:50:10,281 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
17:50:10,468 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
17:50:10,468 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
17:50:10,640 INFO [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
17:50:10,656 INFO [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
If reverted the system back to the original database and alf_data directory the system starts up successfully but then when try again to upgrade it fails.
I then tried to upgrade from 3.2r to Alfresco 3.3g as suggested by someone on the forums. This was successful as this version of Alfresco was still using Hiberate for the data layer communication.
I then tried to upgrade from 3.3g to 3.4a and again this failed with the messages displayed in the attached logs.
There are various posts about problems with the upgrade schema_database scripts and as indicated above by Mr Rogers manual intervention is required. I haven't attempted this manual intervention yet as there not much detail around how to do it.
Advice from Mr Rogers
""org.alfresco.error.AlfrescoRuntimeException: 09180000 A previous schema upgrade failed or was not completed. Revert to the original database before attempting the upgrade again."
You are trying to upgrade from an unknown version since you carried on using Alfresco after an upgrade failed. What you should have done is rolled back your previous upgrade attempt after it failed.
It may not be as bad as that sounds but you will need to study the databases patches that have been applied to your system and in particular any failures. There's a table of patches applied in the database, take a look at that."
I have looked in the database and found only these tables; I assume you are refering to the Alfresco database?
mysql> show tables;
+——————————–+
| 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_bootstrap_lock |
| alf_child_assoc |
| 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 |
+——————————–+
Thank you for your advice but could you provide us with a little more detail? Like whaty database patches and what is the name of the table you are refering to.
I have noticed that some scritps and XML files are written here; C:\WINDOWS\TEMP\Alfresco. When the failure occurs there are multiple files as the system tried to upgrade the database and can't.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2010 06:53 AM
Hello
I found some data that my be relevant. Let me know what you think please? I suggest copy and paste the text into notepad or something like and view without wordwrap on. I didn't paste all the data from the table as it wasn't relevant.
I found some data that my be relevant. Let me know what you think please? I suggest copy and paste the text into notepad or something like and view without wordwrap on. I didn't paste all the data from the table as it wasn't relevant.
mysql> select * from [b]alf_applied_patch[/b] order by applied_on_date DESC;
+———————————————————–+—————————————————————————————————————————————————————————-+——————-+—————–+——————-+—————+———————+—————————-+————–+———–+—————————————————————————————————————————————————————————————————————————————————-+
| id | description | fixes_from_schema | fixes_to_schema | applied_to_schema | target_schema | applied_on_date | applied_to_server | was_executed | succeeded | report |
+———————————————————–+—————————————————————————————————————————————————————————-+——————-+—————–+——————-+—————+———————+—————————-+————–+———–+—————————————————————————————————————————————————————————————————————————————————-+
| patch.convertContentUrls | Converts pre-3.2 content URLs to use the alf_content_data table. The conversion work can also be done on a schedule; please contact Alfresco Support for further details. | 0 | 4007 | 2019 | 4008 | 2010-11-16 17:28:53 | 3.3.0 (g 2860) - Community | | | Content URL conversion completed. |
| patch.transferServiceFolder | Add transfer definitions folder to data dictionary. | 0 | 4008 | 2019 | 4009 | 2010-11-16 17:28:53 | 3.3.0 (g 2860) - Community | | | Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/d3235099-5900-43b5-ac7c-e78902df4374) |
| patch.personUsagePatch | Add person 'cm:sizeCurrent' property (if missing). | 0 | 3004 | 2019 | 3005 | 2010-11-16 17:28:49 | 3.3.0 (g 2860) - Community | | | No people were missing the 'cm:sizeCurrent' property. |
| patch.thumbnailsAssocQName | Update the 'cm:thumbnails' association QName to 'rn:rendition'. | 0 | 4004 | 2019 | 4005 | 2010-11-16 17:28:49 | 3.3.0 (g 2860) - Community | | | Successfully updated the '{http://www.alfresco.org/model/content/1.0}thumbnails' QName to '{http://www.alfresco.org/model/rendition/1.0}rendition'. |
| patch.rendition.rendering_actions | Creates the Rendering Actions folder. | 0 | 4003 | 2019 | 4004 | 2010-11-16 17:28:49 | 3.3.0 (g 2860) - Community | | | Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/d3235099-5900-43b5-ac7c-e78902df4374) |
| patch.emailInviteAndNotifyTemplatesFolder | Ensures the existence of the 'Email Invite Templates' and 'Email Notify Templates' folders. | 0 | 4006 | 2019 | 4007 | 2010-11-16 17:28:49 | 3.3.0 (g 2860) - Community | | | The Email Notify Templates folder was successfully created: workspace://SpacesStore/9ad0a498-33eb-451d-bf87-797cbb770e40; The Email Invite Templates folder was successfully created: workspace://SpacesStore/9ad0a498-33eb-451d-bf87-797cbb770e40 |
| patch.redeployNominatedInvitationProcessWithPropsForShare | Redeploy nominated invitation workflow | 0 | 4000 | 2019 | 4001 | 2010-11-16 17:28:49 | 3.3.0 (g 2860) - Community | | | Re-deployed 1 workflows. |
| patch.fixNameCrcValues-2 | Fixes name and qname CRC32 values to match UTF-8 encoding. | 0 | 3006 | 2019 | 3007 | 2010-11-16 17:28:48 | 3.3.0 (g 2860) - Community | | | Fixed CRC32 values for UTF-8 encoding for 1,945 node child associations. See file C:\ALFRES~2\tomcat\temp\Alfresco\longLife_patches\FixNameCrcValuesPatch.log for details. |
| patch.db-V2.2-CleanNodeStatuses | Ensures that the database upgrade script has been run. | 0 | 89 | 2019 | 90 | 2010-11-16 17:28:48 | 3.3.0 (g 2860) - Community | | | Not relevant to schema 2,019 |
| patch.db-V2.2-Person-3 | Manually executed script upgrade V2.2: Person user name also in the association qname | 0 | 3002 | -1 | 3003 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.1-Allow-IPv6 | Manually executed script upgrade V3.1: Increase the ipAddress field length | 0 | 2019 | -1 | 2020 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.2-AuditTables | Manually executed script upgrade V3.2: Audit Tables | 0 | 3001 | -1 | 3002 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.2-ContentTables2 | Manually executed script upgrade V3.2: Content Tables 2 (pre 3.2 Enterprise Final) | 0 | 3008 | -1 | 3009 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.3-Fix-Repo-Seqs_1 | Manually executed script upgrade V3.3 to create repo sequences | 0 | 4007 | -1 | 4008 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.2-PropertyValueTables | Manually executed script upgrade V3.2: PropertyValue Tables | 0 | 3000 | -1 | 3001 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.3-Remove-VersionCount | Manually executed script upgrade V3.3 to remove Version Count | 0 | 4002 | -1 | 4003 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
| patch.db-V3.2-Child-Assoc-QName-CRC | Manually executed script upgrade V3.2 to Add qname_crc column to alf_child_assoc and change indexes | 0 | 3005 | -1 | 3006 | 2010-11-16 17:28:40 | UNKOWN | | | Script completed |
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2010 09:48 AM
I did something like this inorder to get rid of this error,
before trying this backup your db and alf_data….
before trying this backup your db and alf_data….
15:06:57,869 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2228443775384316204.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-Person.sql).
15:14:57,504 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-688607133524075911.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-LockTables.sql).
15:14:57,517 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
SQL: CREATE TABLE alf_lock_resource
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
qname_ns_id BIGINT NOT NULL,
qname_localname VARCHAR(255) NOT NULL,
CONSTRAINT fk_alf_lockr_ns FOREIGN KEY (qname_ns_id) REFERENCES alf_namespace (id),
PRIMARY KEY (id),
UNIQUE INDEX idx_alf_lockr_key (qname_ns_id, qname_localname)
) TYPE=InnoDB
Error: Table 'alf_lock_resource' already exists
File: /opt/alfresco-3.4.a/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-688607133524075911.sql
Line: 19
15:14:57,519 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failedI logged into my mysql
SET foreign_key_checks = 0;
drop table alf_bootstrap_lock;
drop table alf_lock_resource;
Related Content
- Cannot access Alfresco drive after upgrading to Windows 11 in Alfresco Forum
- How do I upgrade my alfresco 7.3 to 23.6 using ansible? Any links/helps in Alfresco Forum
- TTL #172 - From CommunityLIVE to Code: Alfresco Training review in Alfresco Blog
- Important topics and useful resources in Alfresco Forum
- Alfresco Content Accelerator and Alfresco Enterprise Viewer vulnerabilities in Alfresco Blog
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
