<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Schema upgrade failing (4.2.f-&amp;gt;5.0.a) in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283762#M236892</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;The content is 1.5TB and the database files on disk (mysql) are around 17GB (the database dump is around 5GB).&amp;nbsp; alfresco and /share are both fine in 4.2.f.&amp;nbsp; When I upgrade to 5.0.a though:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In catalina.out, everything is fine until the log fragment below.&amp;nbsp; How would I go about figuring out what is breaking the upgrade?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;2015-06-08 17:14:23,907&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-7347609668881407787.xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:23,907&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-8693489867129267228.xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:34,071&amp;nbsp; WARN&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 11 potential problems, results written to: /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-3924253480265907687.txt&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:34,137&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Compared database schema with reference schema (all OK): class path resource [alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/Schema-Reference-AVM.xml]&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:34,337&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Compared database schema with reference schema (all OK): class path resource [alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/Schema-Reference-JBPM.xml]&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:34,603&amp;nbsp; WARN&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 16 potential problems, results written to: /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-2214938116786478717.txt&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:41,315&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-alf_-6051651724617343060.xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:41,316&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-avm_-5344869175157373630.xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:41,316&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-7459549657158174894.xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:41,316&amp;nbsp; INFO&amp;nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/alf_data/alf_intermediate/alfresco-5.0.a/tomcat/temp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-9178924772918145188.xml.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; 2015-06-08 17:14:46,319&amp;nbsp; ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; org.alfresco.error.AlfrescoRuntimeException: 05080000 A previous schema upgrade failed or was not completed.&amp;nbsp; Revert to the original database before attempting the upgrade again.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1702)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.FutureTask.run(FutureTask.java:262)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.Thread.run(Thread.java:745)&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 08 Jun 2015 22:55:29 GMT</pubDate>
    <dc:creator>bopolissimus</dc:creator>
    <dc:date>2015-06-08T22:55:29Z</dc:date>
    <item>
      <title>Schema upgrade failing (4.2.f-&gt;5.0.a)</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283762#M236892</link>
      <description>The content is 1.5TB and the database files on disk (mysql) are around 17GB (the database dump is around 5GB).&amp;nbsp; alfresco and /share are both fine in 4.2.f.&amp;nbsp; When I upgrade to 5.0.a though:In catalina.out, everything is fine until the log fragment below.&amp;nbsp; How would I go about figuring out what is bre</description>
      <pubDate>Mon, 08 Jun 2015 22:55:29 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283762#M236892</guid>
      <dc:creator>bopolissimus</dc:creator>
      <dc:date>2015-06-08T22:55:29Z</dc:date>
    </item>
    <item>
      <title>Re: Schema upgrade failing (4.2.f-&gt;5.0.a)</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283763#M236893</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;bumping up log4.logger.org.alfresco.repo.domain.schema in */alfresco/extension/custom-log4j.properties didn't do anything but that might be pilot error.&amp;nbsp; Just while debugging I'll update the log4j.properties from webapps (and remove the war file so it doesn't get redeployed).&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'm also now looking at the generated &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-[0-9]+.txt file and fixing issues I see.&amp;nbsp; I don't think I should be having any schema issues at all, but somehow I *am* having them, so will work through those.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 09 Jun 2015 23:33:45 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283763#M236893</guid>
      <dc:creator>bopolissimus</dc:creator>
      <dc:date>2015-06-09T23:33:45Z</dc:date>
    </item>
    <item>
      <title>Re: Schema upgrade failing (4.2.f-&gt;5.0.a)</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283764#M236894</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Ah, it looks like it wasn't looking where I thought it was for the custom-log4.properties file.&amp;nbsp; logging is better now.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 09 Jun 2015 23:47:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/schema-upgrade-failing-4-2-f-gt-5-0-a/m-p/283764#M236894</guid>
      <dc:creator>bopolissimus</dc:creator>
      <dc:date>2015-06-09T23:47:50Z</dc:date>
    </item>
  </channel>
</rss>

