Community 3.4d to 4.0c Nightly

I've decided to start a new topic on upgrading from 3.4 to 4.0 as the issue for me appears to be altogether different than what I've seen other people reporting.

After having successfully setup a Community 4.0c Nightly build (12-Dec-2011 23:28) I attempted to upgrade a previous installation.

Using the newly install instance, I changed the following in alfresco-global.properties:

pointed dir.root to cold backup of 3.4 alf_data

modifyied index.subsystem.name to use lucene as opposed to solr

added my authentication chain

Copied over the various extension files for authentication, file servers, and synchronization.

Also restored a copy of the database from 3.4.

This is all running on Windows 2008 R2 using MySQL v5.1.50.

Fire up Tomcat and monitor logs.

I get the following in strerr:

Dec 12, 2011 10:23:57 PM org.apache.catalina.core.AprLifecycleListener initINFO: Loaded APR based Apache Tomcat Native library 1.1.20.Dec 12, 2011 10:23:57 PM org.apache.catalina.core.AprLifecycleListener initINFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].Dec 12, 2011 10:23:58 PM org.apache.coyote.http11.Http11AprProtocol initINFO: Initializing Coyote HTTP/1.1 on http-8080Dec 12, 2011 10:23:58 PM org.apache.coyote.ajp.AjpAprProtocol initINFO: Initializing Coyote AJP/1.3 on ajp-8009Dec 12, 2011 10:23:59 PM org.apache.coyote.http11.Http11Protocol initINFO: Initializing Coyote HTTP/1.1 on http-8443Dec 12, 2011 10:23:59 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 2201 msDec 12, 2011 10:23:59 PM org.apache.catalina.core.StandardService startINFO: Starting service CatalinaDec 12, 2011 10:23:59 PM org.apache.catalina.core.StandardEngine startINFO: Starting Servlet Engine: Apache Tomcat/6.0.29Dec 12, 2011 10:23:59 PM org.apache.catalina.startup.HostConfig deployDescriptorINFO: Deploying configuration descriptor alfresco.xmlDec 12, 2011 10:24:01 PM org.apache.catalina.core.StandardContext addApplicationListenerINFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.Dec 12, 2011 10:24:03 PM org.apache.catalina.core.ApplicationContext logINFO: Initializing Spring root WebApplicationContextDec 12, 2011 10:24:28 PM org.activiti.engine.impl.ProcessEngineImpl <init>INFO: ProcessEngine default createdDec 12, 2011 10:30:29 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListenerorg.alfresco.error.AlfrescoRuntimeException: 11120001 Schema auto-update failed at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612) at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) 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:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) 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:445) 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: 11120000 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:1492) … 34 moreDec 12, 2011 10:30:29 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListenerorg.alfresco.error.AlfrescoRuntimeException: 11120001 Schema auto-update failed at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612) at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) 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:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) 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:445) 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: 11120000 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:1492) … 34 moreDec 12, 2011 10:30:29 PM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextInitializedINFO: WSSERVLET12: JAX-WS context listener initializingDec 12, 2011 10:30:33 PM com.sun.xml.ws.transport.http.servlet.WSServletDelegate <init>INFO: WSSERVLET14: JAX-WS servlet initializingDec 12, 2011 10:30:33 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartDec 12, 2011 10:30:33 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/alfresco] startup failed due to previous errorsDec 12, 2011 10:30:33 PM com.sun.xml.ws.transport.http.servlet.WSServletDelegate destroyINFO: WSSERVLET15: JAX-WS servlet destroyedDec 12, 2011 10:30:33 PM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextDestroyedINFO: WSSERVLET13: JAX-WS context listener destroyedDec 12, 2011 10:30:33 PM org.apache.catalina.core.ApplicationContext logINFO: Closing Spring root WebApplicationContextDec 12, 2011 10:30:33 PM org.apache.catalina.core.ApplicationContext logINFO: Shutting down log4jDec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] 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.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [Thread-4] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [MultiThreadedHttpConnectionManager cleanup] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMapSEVERE: The web application [/alfresco] created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@8e0a961]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@559023d4]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMapSEVERE: The web application [/alfresco] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@6a205f2e]) and a value of type [org.apache.cxf.bus.CXFBusImpl] (value [org.apache.cxf.bus.CXFBusImpl@7348fb70]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMapSEVERE: The web application [/alfresco] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@3c73b131]) and a value of type [org.alfresco.util.CachingDateFormat] (value [yyyy-MM-dd]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMapSEVERE: The web application [/alfresco] created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.ClassFactory$1@4f7626f8]) and a value of type [java.util.WeakHashMap] (value [{class org.alfresco.repo.audit.model._3.GenerateValue=java.lang.ref.WeakReference@74fff2f8, class org.alfresco.repo.audit.model._3.PathMap=java.lang.ref.WeakReference@4fa8b3ca, class org.alfresco.repo.audit.model._3.RecordValue=java.lang.ref.WeakReference@4cb3bba1, class org.alfresco.repo.audit.model._3.Audit=java.lang.ref.WeakReference@2be36e5e, class org.alfresco.repo.audit.model._3.DataGenerators=java.lang.ref.WeakReference@6062f3d4, class org.alfresco.repo.audit.model._3.DataExtractors=java.lang.ref.WeakReference@7614bc, class org.alfresco.repo.audit.model._3.Application=java.lang.ref.WeakReference@484b42e0, class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@4513a534, class java.util.ArrayList=java.lang.ref.WeakReference@cc31c5a, class org.alfresco.repo.audit.model._3.AuditPath=java.lang.ref.WeakReference@5d7a5f41, class org.alfresco.repo.audit.model._3.PathMappings=java.lang.ref.WeakReference@d03d459, class org.alfresco.repo.audit.model._3.DataGenerator=java.lang.ref.WeakReference@766a25bb, class org.alfresco.repo.audit.model._3.DataExtractor=java.lang.ref.WeakReference@32d354b9}]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

Not sure why I can boot 3.4d and the patch PatchExecuter doesn't pick up on the fact that I'm missing patches. The log file reports that I'm running schema 4113.

mrogers, can you provide some insight on where to start with this problem. I'm looking at the dbscripts under create and update folders (that are part of my 3.4d install) and attempting to determine if each one has been applied. Is this a good approach? Is there anywhere else I should be looking?

Looking at the patch-services-context.xml file, there is a long list of 'dead patches'. Should I be using this file as a guild to work backwards and determine if each one has been applied?

What a mess. Tempted to just export what we have and import into 4.0 install.

If you go to Alfresco Explorer as admin, the look at the Adminstrator Console, Repository Properties and you should have all listed patches there. See if you find any that have failed.

The schema comparator is a new functionality, as it looks it just reports any diffs compared to expected, but still continues to do the upgrade. If it succeeds it again reports remaining diffs. So my understanding is that it doesn't stop the upgrade, it is more a tool to diagnose what might be causing the errors. At least so is my understanding of the schema comparator. I upgraded a library to 4.0c nightly this weekend, and it reported errors about missing indexes. The upgrade patches ran as expected, and I just added the missing indexes afterwards.In your case it seem much worse…

Then maybe if you are lucky (if you can call it that) it is just you db dump and import that doesn't bring along all the data. Try to redo that part of the process, and compare your production db to your test db and see if all (or a sample of to shorten what you have to check) the mentioned missing tables and indexes actually now exist.

Grabbed a dump of the DB and have compared it to what was loaded in test system. Identical. :(

What I have noticed is that of the 24 pre-upgrade files (Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-….txt), they're all identical. In the file, there are 60 lines. It appears to me that are three types of differences in the file: expected, missing, and unexpected.

I'm going to plug through each line and script the appropriate changes.

Ok, so I've gone through the process of manually scripting a file to change the database based on the differences identified Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade file.

The majority of the changes had to do with renaming indexes and keys. All very straight forward.

There was two lines in the file that I could not determine what to do. They are:

Difference: expected index .alf_node.idx_alf_node_del.name="idx_alf_node_del", but was .alf_node.idx_alf_node_txn_del.name="idx_alf_node_txn_del"Difference: expected index .alf_node.idx_alf_node_txn_del.columnNames[0]="transaction_id", but was .alf_node.idx_alf_node_txn_del.columnNames="[node_deleted]"

Can someone provide the details for those two indexes?

The other hurdle that I've not been able to get around is a situation where the pre-upgrade file listed the following tables:

Difference: unexpected table found in database with path: .alf_attributesDifference: unexpected table found in database with path: .alf_audit_configDifference: unexpected table found in database with path: .alf_audit_dateDifference: unexpected table found in database with path: .alf_audit_factDifference: unexpected table found in database with path: .alf_audit_sourceDifference: unexpected table found in database with path: .alf_bootstrap_lockDifference: unexpected table found in database with path: .alf_global_attributesDifference: unexpected table found in database with path: .alf_list_attribute_entriesDifference: unexpected table found in database with path: .alf_map_attribute_entries

From this I gather that the tables shouldn't be present, so I removed them. The trouble arises when I start Tomcat and patches are applied. Here is the relevant log file:

===================================== 2011-12-13 22:21:59,863 INFO [admin.patch.PatchExecuter] [Thread-1] === Applied patch === ID: patch.db-V4.0-SubscriptionTablesRESULT: Script completed===================================== 2011-12-13 22:21:59,863 INFO [admin.patch.PatchExecuter] [Thread-1] === Applied patch === ID: patch.db-V4.0-SolrTrackingRESULT: Script completed===================================== 2011-12-13 22:21:59,863 ERROR [web.context.ContextLoader] [Thread-1] Context initialization failed org.alfresco.error.AlfrescoRuntimeException: 11130001 Not all patches could be applied at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:111) at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124) at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:120) at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519) at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128) at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209) at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) 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:4135) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630) 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:445) 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)

As you can see, its complain that the alf_list_attribute_entries table is missing. Restoring the table, I still get the same error. Help!