Thanks James. I've checked the table and the template exists. I'm still investigating though.
Cheers, Osay On 4 September 2015 at 12:28, giljae o <ogil...@gmail.com> wrote: > 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 > > >