Dear Osay, I had the similar issue during the upgrade from 4.5.0 to 4.5.1 The new template name for 4.5.1 was looked for. My fix was to update the template name as required. Please look into whether the same template name in vm_template table exists
James On Fri, Sep 4, 2015 at 7:10 PM, Osay Osman Yuuni <oyu...@gmail.com> wrote: > Hi friends, > I'm having a very strange upgrade issue which I was wondering if anyone has > encountered and whether someone can catch what is wrong. Basically I > follow the steps outlined in the docs to the letter. When I restart the MS > service it gets stuck at running the DB upgrade scripts. I checked > catalina.out and noticed that the schema-430to440.sql script is trying to > create tables that already exist or insert columns that already exit. > > I commented out all the lines causing the issue and then restart the MS > service but then I get a new error about the Listener. After Googling this > error the only hints I got were about system templates but I made sure the > new system template was installed before attempting the upgrade. I've > repeated this no less than five time with the very same results. I'm > miffed. > > Below is a snippet of the catalina.out log with the error. Can anyone spot > the issue? > > TIA > Osay > > ====== SNIP==== > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-core-4.5.2.jar!/META-INF/cloudstack/system/spring-core-syst > em-context.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-engine-schema-4.5.2.jar!/META-INF/cloudstack/system/spring- > engine-schema-system-checkers-context.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-framework-config-4.5.2.jar!/META-INF/cloudstack/system/spri > ng-framework-config-system-context.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-framework-db-4.5.2.jar!/META-INF/cloudstack/system/spring-f > ramework-db-system-context.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-server-4.5.2.jar!/META-INF/cloudstack/system/spring-server- > system-context.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-core-4.5.2.jar!/META-INF/cloudstack/system/spring-core-syst > em-context-inheritable.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-framework-config-4.5.2.jar!/META-INF/cloudstack/system/spri > ng-framework-config-system-context-inheritable.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-plugin-network-contrail-4.5.2.jar!/META-INF/cloudstack/syst > em/spring-contrail-system-context-inheritable.xml] > INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:null) Loading module > context [system] from URL > > [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-core-4.5.2.jar!/META-INF/cloudstack/bootstrap/spring-bootst > rap-context-inheritable.xml] > INFO [c.c.u.d.T.Transaction] (main:null) Is Data Base High Availiability > enabled? Ans : false > INFO [c.c.u.d.Merovingian2] (main:null) Cleaning up locks for > 7063056740127 > INFO [c.c.u.d.Merovingian2] (main:null) Released 0 locks for 7063056740127 > INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) Running system > integrity checker com.cloud.upgrade.DatabaseUpgradeChecker@7fa02e81 > INFO [c.c.u.DatabaseUpgradeChecker] (main:null) Grabbing lock to check for > database upgrade. > INFO [c.c.u.DatabaseUpgradeChecker] (main:null) DB version = 4.3.0 Code > Version = 4.5.2 > INFO [c.c.u.DatabaseUpgradeChecker] (main:null) Database upgrade must be > performed from 4.3.0 to 4.5.2 > Sep 04, 2015 11:58:32 AM org.apache.catalina.core.StandardContext start > SEVERE: Error listenerStart > Sep 04, 2015 11:58:32 AM org.apache.catalina.core.StandardContext start > SEVERE: Context [/client] startup failed due to previous errors > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearReferencesThreads > SEVERE: A web application appears to have started a thread named > [FileWatchdog] but has failed to stop it. This is very likely to create a > memory leak. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearReferencesThreads > SEVERE: A web application appears to have started a thread named [Timer-0] > but has failed to stop it. This is very likely to create a memory leak. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearReferencesThreads > SEVERE: A web application appears to have started a thread named > [ConnectionConcierge-1] but has failed to stop it. This is very likely to > create a memory leak. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearThreadLocalMap > SEVERE: A web application created a ThreadLocal with key of type > [org.springframework.core.NamedThreadLocal] (value [Prototype beans > currently in creation]) and a value of type [null] (value [null]) but > failed to remove it when the web a > pplication was stopped. To prevent a memory leak, the ThreadLocal has been > forcibly removed. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearThreadLocalMap > SEVERE: A web application created a ThreadLocal with key of type > [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@63ba710]) and a > value > of type [com.cloud.utils.db.TransactionLegacy] (value [ : ]) but failed to > remove it when the we > b application was stopped. To prevent a memory leak, the ThreadLocal has > been forcibly removed. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearThreadLocalMap > SEVERE: A web application created a ThreadLocal with key of type > [org.springframework.core.NamedThreadLocal] (value [Prototype beans > currently in creation]) and a value of type [null] (value [null]) but > failed to remove it when the web a > pplication was stopped. To prevent a memory leak, the ThreadLocal has been > forcibly removed. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearThreadLocalMap > SEVERE: A web application created a ThreadLocal with key of type > [org.springframework.core.NamedThreadLocal] (value [Current AOP method > invocation]) and a value of type [null] (value [null]) but failed to remove > it when the web applicati > on was stopped. To prevent a memory leak, the ThreadLocal has been forcibly > removed. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearThreadLocalMap > SEVERE: A web application created a ThreadLocal with key of type > [org.springframework.core.NamedThreadLocal] (value [Prototype beans > currently in creation]) and a value of type [null] (value [null]) but > failed to remove it when the web a > pplication was stopped. To prevent a memory leak, the ThreadLocal has been > forcibly removed. > Sep 04, 2015 11:58:32 AM org.apache.catalina.loader.WebappClassLoader > clearThreadLocalMap > SEVERE: A web application created a ThreadLocal with key of type > [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@63ba710]) and a > value > of type [com.cloud.utils.db.TransactionLegacy] (value [ : ]) but failed to > remove it when the we > b application was stopped. To prevent a memory leak, the ThreadLocal has > been forcibly removed. > Sep 04, 2015 11:58:33 AM org.apache.coyote.http11.Http11NioProtocol start > INFO: Starting Coyote HTTP/1.1 on http-8080 > Sep 04, 2015 11:58:33 AM org.apache.jk.common.ChannelSocket init > INFO: JK: ajp13 listening on /0.0.0.0:20400 > Sep 04, 2015 11:58:33 AM org.apache.jk.server.JkMain start > INFO: Jk running ID=0 time=0/42 config=null > Sep 04, 2015 11:58:33 AM org.apache.catalina.core.StandardService start > INFO: Starting service Catalina7080 > Sep 04, 2015 11:58:33 AM org.apache.catalina.core.StandardEngine start > INFO: Starting Servlet Engine: Apache Tomcat/6.0.24 > Sep 04, 2015 11:58:33 AM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory webapps > Sep 04, 2015 11:58:33 AM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory awsapi > Sep 04, 2015 11:58:33 AM org.apache.catalina.loader.WebappClassLoader > validateJarFile > INFO: > > validateJarFile(/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/lib/geronimo-servlet_3.0_spec-1.0.jar) > - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: > javax/servlet/Servlet.class > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > > [jar:file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/slf4j-jdk14-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > > [jar:file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory] > Sep 04, 2015 11:58:34 AM org.apache.catalina.core.ApplicationContext log > INFO: Initializing Spring root WebApplicationContext > Sep 04, 2015 11:58:34 AM org.springframework.web.context.ContextLoader > initWebApplicationContext >