AnsweredAssumed Answered

Community 3.4d to 4.0c Nightly

Question asked by benswitzer on Dec 13, 2011
Latest reply on Dec 14, 2011 by benswitzer
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 init
INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
Dec 12, 2011 10:23:57 PM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Dec 12, 2011 10:23:58 PM org.apache.coyote.http11.Http11AprProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Dec 12, 2011 10:23:58 PM org.apache.coyote.ajp.AjpAprProtocol init
INFO: Initializing Coyote AJP/1.3 on ajp-8009
Dec 12, 2011 10:23:59 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8443
Dec 12, 2011 10:23:59 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2201 ms
Dec 12, 2011 10:23:59 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Dec 12, 2011 10:23:59 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
Dec 12, 2011 10:23:59 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor alfresco.xml
Dec 12, 2011 10:24:01 PM org.apache.catalina.core.StandardContext addApplicationListener
INFO: 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 log
INFO: Initializing Spring root WebApplicationContext
Dec 12, 2011 10:24:28 PM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine default created
Dec 12, 2011 10:30:29 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener
org.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 more
Dec 12, 2011 10:30:29 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.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 more
Dec 12, 2011 10:30:29 PM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextInitialized
INFO: WSSERVLET12: JAX-WS context listener initializing
Dec 12, 2011 10:30:33 PM com.sun.xml.ws.transport.http.servlet.WSServletDelegate <init>
INFO: WSSERVLET14: JAX-WS servlet initializing
Dec 12, 2011 10:30:33 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Dec 12, 2011 10:30:33 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Dec 12, 2011 10:30:33 PM com.sun.xml.ws.transport.http.servlet.WSServletDelegate destroy
INFO: WSSERVLET15: JAX-WS servlet destroyed
Dec 12, 2011 10:30:33 PM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextDestroyed
INFO: WSSERVLET13: JAX-WS context listener destroyed
Dec 12, 2011 10:30:33 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Dec 12, 2011 10:30:33 PM org.apache.catalina.core.ApplicationContext log
INFO: Shutting down log4j
Dec 12, 2011 10:30:33 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearReferencesThreads
SEVERE: 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 clearThreadLocalMap
SEVERE: 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 clearThreadLocalMap
SEVERE: 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 clearThreadLocalMap
SEVERE: 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 clearThreadLocalMap
SEVERE: 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.

And this in strout:
2011-12-12 22:24:18,972  INFO  [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
2011-12-12 22:24:19,082  INFO  [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2011-12-12 22:24:30,097  WARN  [alfresco.util.AbstractTriggerBean] [Thread-1] Job ehCacheTracerJob is not active/enabled
2011-12-12 22:24:35,847  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor Repository Template Processor for extension ftl
2011-12-12 22:24:35,863  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor Repository Script Processor for extension js
2011-12-12 22:24:45,582  INFO  [domain.schema.SchemaBootstrap] [Thread-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
2011-12-12 22:24:51,035  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2144210607733624583.txt
2011-12-12 22:25:06,316  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3575427951357051498.txt
2011-12-12 22:25:21,222  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-848977026631835486.txt
2011-12-12 22:25:35,972  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5077702226349974625.txt
2011-12-12 22:25:50,425  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-92803175354449635.txt
2011-12-12 22:26:04,644  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-6418601019635107849.txt
2011-12-12 22:26:19,128  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-949256340903209787.txt
2011-12-12 22:26:33,550  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-868800586691494096.txt
2011-12-12 22:26:47,691  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1031746130884814182.txt
2011-12-12 22:27:01,785  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8505688935395230135.txt
2011-12-12 22:27:16,144  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3374838137395380769.txt
2011-12-12 22:27:30,269  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1808078169958910105.txt
2011-12-12 22:27:44,238  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5623357967680886862.txt
2011-12-12 22:27:58,285  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-498596516946867344.txt
2011-12-12 22:28:12,660  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3777431954294619059.txt
2011-12-12 22:28:27,128  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7409502099906440765.txt
2011-12-12 22:28:41,363  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1204640228339005571.txt
2011-12-12 22:28:55,378  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5396759245370826309.txt
2011-12-12 22:29:09,566  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7625361689450897375.txt
2011-12-12 22:29:23,894  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8000242876621081188.txt
2011-12-12 22:29:37,941  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1366433902557457485.txt
2011-12-12 22:29:51,878  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-659350264360731486.txt
2011-12-12 22:30:05,863  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-1635529952066320443.txt
2011-12-12 22:30:19,988  WARN  [domain.schema.SchemaBootstrap] [Thread-1] Schema validation found 60 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-6151654265221731845.txt
2011-12-12 22:30:29,691  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Schema auto-update failed
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)
   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)
2011-12-12 22:30:29,691  ERROR [web.context.ContextLoader] [Thread-1] Context initialization failed
org.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 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
2011-12-12 22:30:46,738  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2011-12-12 22:30:46,863  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2011-12-12 22:30:46,863  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2011-12-12 22:30:46,878  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2011-12-12 22:30:50,878  INFO  [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 312 Web Scripts (+0 failed), 322 URLs
2011-12-12 22:30:50,878  INFO  [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 8 Package Description Documents (+0 failed)
2011-12-12 22:30:50,878  INFO  [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 0 Schema Description Documents (+0 failed)
2011-12-12 22:30:51,128  INFO  [extensions.webscripts.AbstractRuntimeContainer] [Thread-1] Initialised Spring Surf Container Web Script Container (in 4243.111ms)
2011-12-12 22:30:51,128  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2011-12-12 22:30:51,144  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
log4j:WARN No appenders could be found for logger (org.quartz.core.QuartzSchedulerThread).
log4j:WARN Please initialize the log4j system properly.

The files that contain the schema validation issues are being successfully created.  Here is one titled Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-92803175354449635.txt:
Difference: expected index .alf_acl_member.aclm_acl_id.name="aclm_acl_id", but was .alf_acl_member.acl_id.name="acl_id"
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_an
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_mod
Difference: missing foreign key from database, expected at path: .alf_audit_app.fk_alf_aud_app_dis
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_app
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_dis
Difference: unexpected foreign key found in database with path: .alf_audit_app.fk_alf_audit_app_model
Difference: expected index .alf_audit_app.idx_alf_aud_app_an.name="idx_alf_aud_app_an", but was .alf_audit_app.idx_alf_audit_app_app.name="idx_alf_audit_app_app"
Difference: expected index .alf_audit_app.fk_alf_aud_app_mod.name="fk_alf_aud_app_mod", but was .alf_audit_app.fk_alf_audit_app_model.name="fk_alf_audit_app_model"
Difference: expected index .alf_audit_app.fk_alf_aud_app_dis.name="fk_alf_aud_app_dis", but was .alf_audit_app.fk_alf_audit_app_dis.name="fk_alf_audit_app_dis"
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_app
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_use
Difference: missing foreign key from database, expected at path: .alf_audit_entry.fk_alf_aud_ent_pro
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_app
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_prop
Difference: unexpected foreign key found in database with path: .alf_audit_entry.fk_alf_audit_ent_user
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_app.name="fk_alf_aud_ent_app", but was .alf_audit_entry.fk_alf_audit_ent_app.name="fk_alf_audit_ent_app"
Difference: expected index .alf_audit_entry.idx_alf_aud_ent_tm.name="idx_alf_aud_ent_tm", but was .alf_audit_entry.idx_alf_audit_ent_time.name="idx_alf_audit_ent_time"
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_use.name="fk_alf_aud_ent_use", but was .alf_audit_entry.fk_alf_audit_ent_user.name="fk_alf_audit_ent_user"
Difference: expected index .alf_audit_entry.fk_alf_aud_ent_pro.name="fk_alf_aud_ent_pro", but was .alf_audit_entry.fk_alf_audit_ent_prop.name="fk_alf_audit_ent_prop"
Difference: missing foreign key from database, expected at path: .alf_audit_model.fk_alf_aud_mod_cd
Difference: unexpected foreign key found in database with path: .alf_audit_model.fk_alf_audit_model_cd
Difference: expected index .alf_audit_model.idx_alf_aud_mod_cr.name="idx_alf_aud_mod_cr", but was .alf_audit_model.idx_alf_audit_cfg_crc.name="idx_alf_audit_cfg_crc"
Difference: expected index .alf_audit_model.fk_alf_aud_mod_cd.name="fk_alf_aud_mod_cd", but was .alf_audit_model.fk_alf_audit_model_cd.name="fk_alf_audit_model_cd"
Difference: missing index from database, expected at path: .alf_node.idx_alf_node_txn_del
Difference: expected index .alf_prop_class.idx_alf_propc_crc.name="idx_alf_propc_crc", but was .alf_prop_class.idx_alf_prop_class_crc.name="idx_alf_prop_class_crc"
Difference: expected index .alf_prop_class.idx_alf_propc_clas.name="idx_alf_propc_clas", but was .alf_prop_class.idx_alf_prop_class_class.name="idx_alf_prop_class_class"
Difference: expected index .alf_prop_date_value.idx_alf_propdt_dt.name="idx_alf_propdt_dt", but was .alf_prop_date_value.idx_alf_prop_date_units.name="idx_alf_prop_date_units"
Difference: expected index .alf_prop_double_value.idx_alf_propd_val.name="idx_alf_propd_val", but was .alf_prop_double_value.idx_alf_prop_dbl_val.name="idx_alf_prop_dbl_val"
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_root
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_key
Difference: missing foreign key from database, expected at path: .alf_prop_link.fk_alf_propln_val
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_key
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_root
Difference: unexpected foreign key found in database with path: .alf_prop_link.fk_alf_prop_link_val
Difference: expected index .alf_prop_link.fk_alf_propln_key.name="fk_alf_propln_key", but was .alf_prop_link.fk_alf_prop_link_key.name="fk_alf_prop_link_key"
Difference: expected index .alf_prop_link.fk_alf_propln_val.name="fk_alf_propln_val", but was .alf_prop_link.fk_alf_prop_link_val.name="fk_alf_prop_link_val"
Difference: expected index .alf_prop_link.idx_alf_propln_for.name="idx_alf_propln_for", but was .alf_prop_link.idx_alf_prop_link_for.name="idx_alf_prop_link_for"
Difference: expected index .alf_prop_string_value.idx_alf_props_crc.name="idx_alf_props_crc", but was .alf_prop_string_value.idx_alf_prop_crc.name="idx_alf_prop_crc"
Difference: expected index .alf_prop_string_value.idx_alf_props_str.name="idx_alf_props_str", but was .alf_prop_string_value.idx_alf_prop_str.name="idx_alf_prop_str"
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v1
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v2
Difference: missing foreign key from database, expected at path: .alf_prop_unique_ctx.fk_alf_propuctx_v3
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_1
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_2
Difference: unexpected foreign key found in database with path: .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_3
Difference: expected index .alf_prop_unique_ctx.idx_alf_propuctx.name="idx_alf_propuctx", but was .alf_prop_unique_ctx.idx_alf_prop_unique_ctx.name="idx_alf_prop_unique_ctx"
Difference: expected index .alf_prop_unique_ctx.fk_alf_propuctx_v2.name="fk_alf_propuctx_v2", but was .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_2.name="fk_alf_prop_unique_ctx_2"
Difference: expected index .alf_prop_unique_ctx.fk_alf_propuctx_v3.name="fk_alf_propuctx_v3", but was .alf_prop_unique_ctx.fk_alf_prop_unique_ctx_3.name="fk_alf_prop_unique_ctx_3"
Difference: expected index .alf_prop_value.idx_alf_propv_act.name="idx_alf_propv_act", but was .alf_prop_value.idx_alf_prop_act.name="idx_alf_prop_act"
Difference: expected index .alf_prop_value.idx_alf_propv_per.name="idx_alf_propv_per", but was .alf_prop_value.idx_alf_prop_per.name="idx_alf_prop_per"
Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_audit_config
Difference: unexpected table found in database with path: .alf_audit_date
Difference: unexpected table found in database with path: .alf_audit_fact
Difference: unexpected table found in database with path: .alf_audit_source
Difference: unexpected table found in database with path: .alf_bootstrap_lock
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries

And another called AlfrescoSchema-MySQLInnoDBDialect-788864408851048362-Startup.xml.  Here's part of that file:
<?xml version="1.0" encoding="UTF-8"?>
<schema>
  <table name="ACT_GE_BYTEARRAY">
    <columns>
      <column name="BYTES_">
        <seq>5</seq>
        <type>VARBINARY</type>
        <nullable>YES</nullable>
      </column>
      <column name="DEPLOYMENT_ID_">
        <seq>4</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="ID_">
        <seq>1</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="NAME_">
        <seq>3</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
      <column name="REV_">
        <seq>2</seq>
        <type>INTEGER</type>
        <nullable>YES</nullable>
      </column>
    </columns>
    <primarykey>
      <column name="ID_">
        <seq>1</seq>
      </column>
    </primarykey>
    <indexes>
      <index name="ACT_FK_BYTEARR_DEPL">
        <unique>false</unique>
        <columns>
          <column name="DEPLOYMENT_ID_"/>
        </columns>
      </index>
    </indexes>
    <foreignkeys>
      <key name="ACT_FK_BYTEARR_DEPL">
        <columns>
          <column name="DEPLOYMENT_ID_">
            <table>ACT_RE_DEPLOYMENT</table>
            <column>ID_</column>
          </column>
        </columns>
      </key>
    </foreignkeys>
  </table>
  <table name="ACT_GE_PROPERTY">
    <columns>
      <column name="NAME_">
        <seq>1</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="REV_">
        <seq>3</seq>
        <type>INTEGER</type>
        <nullable>YES</nullable>
      </column>
      <column name="VALUE_">
        <seq>2</seq>
        <type>VARCHAR(300)</type>
        <nullable>YES</nullable>
      </column>
    </columns>
    <primarykey>
      <column name="NAME_">
        <seq>1</seq>
      </column>
    </primarykey>
    <indexes/>
    <foreignkeys/>
  </table>
  <table name="ACT_HI_ACTINST">
    <columns>
      <column name="ACT_ID_">
        <seq>5</seq>
        <type>VARCHAR(255)</type>
        <nullable>NO</nullable>
      </column>
      <column name="ACT_NAME_">
        <seq>6</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
      <column name="ACT_TYPE_">
        <seq>7</seq>
        <type>VARCHAR(255)</type>
        <nullable>NO</nullable>
      </column>
      <column name="ASSIGNEE_">
        <seq>8</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="DURATION_">
        <seq>11</seq>
        <type>BIGINT</type>
        <nullable>YES</nullable>
      </column>
      <column name="END_TIME_">
        <seq>10</seq>
        <type>TIMESTAMP</type>
        <nullable>YES</nullable>
      </column>
      <column name="EXECUTION_ID_">
        <seq>4</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="ID_">
        <seq>1</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="PROC_DEF_ID_">
        <seq>2</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="PROC_INST_ID_">
        <seq>3</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="START_TIME_">
        <seq>9</seq>
        <type>TIMESTAMP</type>
        <nullable>NO</nullable>
      </column>
    </columns>
    <primarykey>
      <column name="ID_">
        <seq>1</seq>
      </column>
    </primarykey>
    <indexes>
      <index name="ACT_IDX_HI_ACT_INST_END">
        <unique>false</unique>
        <columns>
          <column name="END_TIME_"/>
        </columns>
      </index>
      <index name="ACT_IDX_HI_ACT_INST_START">
        <unique>false</unique>
        <columns>
          <column name="START_TIME_"/>
        </columns>
      </index>
    </indexes>
    <foreignkeys/>
  </table>
  <table name="ACT_HI_ATTACHMENT">
    <columns>
      <column name="CONTENT_ID_">
        <seq>10</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="DESCRIPTION_">
        <seq>5</seq>
        <type>VARCHAR(4000)</type>
        <nullable>YES</nullable>
      </column>
      <column name="ID_">
        <seq>1</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="NAME_">
        <seq>4</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
      <column name="PROC_INST_ID_">
        <seq>8</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="REV_">
        <seq>2</seq>
        <type>INTEGER</type>
        <nullable>YES</nullable>
      </column>
      <column name="TASK_ID_">
        <seq>7</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="TYPE_">
        <seq>6</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
      <column name="URL_">
        <seq>9</seq>
        <type>VARCHAR(4000)</type>
        <nullable>YES</nullable>
      </column>
      <column name="USER_ID_">
        <seq>3</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
    </columns>
    <primarykey>
      <column name="ID_">
        <seq>1</seq>
      </column>
    </primarykey>
    <indexes/>
    <foreignkeys/>
  </table>
  <table name="ACT_HI_COMMENT">
    <columns>
      <column name="ACTION_">
        <seq>7</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
      <column name="FULL_MSG_">
        <seq>9</seq>
        <type>VARBINARY</type>
        <nullable>YES</nullable>
      </column>
      <column name="ID_">
        <seq>1</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="MESSAGE_">
        <seq>8</seq>
        <type>VARCHAR(4000)</type>
        <nullable>YES</nullable>
      </column>
      <column name="PROC_INST_ID_">
        <seq>6</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="TASK_ID_">
        <seq>5</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="TIME_">
        <seq>3</seq>
        <type>TIMESTAMP</type>
        <nullable>NO</nullable>
      </column>
      <column name="TYPE_">
        <seq>2</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
      <column name="USER_ID_">
        <seq>4</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
    </columns>
    <primarykey>
      <column name="ID_">
        <seq>1</seq>
      </column>
    </primarykey>
    <indexes/>
    <foreignkeys/>
  </table>
  <table name="ACT_HI_DETAIL">
    <columns>
      <column name="ACT_INST_ID_">
        <seq>6</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="BYTEARRAY_ID_">
        <seq>11</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="DOUBLE_">
        <seq>12</seq>
        <type>DOUBLE(22)</type>
        <nullable>YES</nullable>
      </column>
      <column name="EXECUTION_ID_">
        <seq>4</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="ID_">
        <seq>1</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="LONG_">
        <seq>13</seq>
        <type>BIGINT</type>
        <nullable>YES</nullable>
      </column>
      <column name="NAME_">
        <seq>7</seq>
        <type>VARCHAR(255)</type>
        <nullable>NO</nullable>
      </column>
      <column name="PROC_INST_ID_">
        <seq>3</seq>
        <type>VARCHAR(64)</type>
        <nullable>NO</nullable>
      </column>
      <column name="REV_">
        <seq>9</seq>
        <type>INTEGER</type>
        <nullable>YES</nullable>
      </column>
      <column name="TASK_ID_">
        <seq>5</seq>
        <type>VARCHAR(64)</type>
        <nullable>YES</nullable>
      </column>
      <column name="TEXT2_">
        <seq>15</seq>
        <type>VARCHAR(4000)</type>
        <nullable>YES</nullable>
      </column>
      <column name="TEXT_">
        <seq>14</seq>
        <type>VARCHAR(4000)</type>
        <nullable>YES</nullable>
      </column>
      <column name="TIME_">
        <seq>10</seq>
        <type>TIMESTAMP</type>
        <nullable>NO</nullable>
      </column>
      <column name="TYPE_">
        <seq>2</seq>
        <type>VARCHAR(255)</type>
        <nullable>NO</nullable>
      </column>
      <column name="VAR_TYPE_">
        <seq>8</seq>
        <type>VARCHAR(255)</type>
        <nullable>YES</nullable>
      </column>
    </columns>
    <primarykey>
      <column name="ID_">
        <seq>1</seq>
      </column>
    </primarykey>
    <indexes>
      <index name="ACT_IDX_HI_DETAIL_ACT_INST">
        <unique>false</unique>
        <columns>
          <column name="ACT_INST_ID_"/>
        </columns>
      </index>
      <index name="ACT_IDX_HI_DETAIL_NAME">
        <unique>false</unique>
        <columns>
          <column name="NAME_"/>
        </columns>
      </index>
      <index name="ACT_IDX_HI_DETAIL_PROC_INST">
        <unique>false</unique>
        <columns>
          <column name="PROC_INST_ID_"/>
        </columns>
      </index>
      <index name="ACT_IDX_HI_DETAIL_TIME">
        <unique>false</unique>
        <columns>
          <column name="TIME_"/>
        </columns>
      </index>
    </indexes>
    <foreignkeys/>
  </table>


I'm run up against this wall with previous community builds of 4.

Any insight would be much appreciated.

Ben

Outcomes