cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-9459) Database upgrade from 3.0.7 to 4.9.0 fails with a ResultSet closed exception
Date Mon, 22 Aug 2016 08:44:20 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-9459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15430322#comment-15430322
] 

ASF GitHub Bot commented on CLOUDSTACK-9459:
--------------------------------------------

Github user rhtyd commented on the issue:

    https://github.com/apache/cloudstack/pull/1641
  
    Ran tests, failure before the fix:
    
    2016-08-22 14:11:09,496 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) UPDATE `cloud`.`ntwk_offering_service_map`
SET Provider='VpcVirtualRouter' WHERE network_offering_id IN (SELECT id from `cloud`.`network_offerings`
WHERE name IN ('DefaultIsolatedNetworkOfferingForVpcNetworks', 'DefaultIsolatedNetworkOfferingForVpcNetworksNoLB'))

    2016-08-22 14:11:09,526 ERROR [c.c.u.d.Upgrade410to420] (main:null) (logid:) Unable to
discover legacy zones.Operation not allowed after ResultSet closed
    java.sql.SQLException: Operation not allowed after ResultSet closed
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
    	at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:734)
    	at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6313)
    	at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
    	at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
    	at com.cloud.upgrade.dao.Upgrade410to420.persistLegacyZones(Upgrade410to420.java:725)
    	at com.cloud.upgrade.dao.Upgrade410to420.performDataMigration(Upgrade410to420.java:79)
    	at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:367)
    	at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:490)
    	at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
    	at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55)
    	at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:167)
    	at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:51)
    	at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:339)
    	at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:143)
    	at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:108)
    	at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:951)
    	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
    	at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
    	at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
    	at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
    	at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
    	at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
    	at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
    	at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)
    	at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)
    	at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791)
    	at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)
    	at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1349)
    	at org.eclipse.jetty.maven.plugin.JettyWebAppContext.startWebapp(JettyWebAppContext.java:297)
    	at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1342)
    	at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
    	at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:505)
    	at org.eclipse.jetty.maven.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:366)
    	at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    	at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)
    	at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    	at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61)
    	at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:163)
    	at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    	at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)
    	at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    	at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61)
    	at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    	at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)
    	at org.eclipse.jetty.server.Server.start(Server.java:387)
    	at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    	at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61)
    	at org.eclipse.jetty.server.Server.doStart(Server.java:354)
    	at org.eclipse.jetty.maven.plugin.JettyServer.doStart(JettyServer.java:73)
    	at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    	at org.eclipse.jetty.maven.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:535)
    	at org.eclipse.jetty.maven.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:358)
    	at org.eclipse.jetty.maven.plugin.JettyRunMojo.execute(JettyRunMojo.java:167)
    	at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
    	at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
    	at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
    	at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
    	at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
    	at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
    	at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
    	at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
    	at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
    	at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
    	at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
    	at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
    	at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
    	at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:606)
    	at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
    	at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
    	at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
    	at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
    2016-08-22 14:11:09,534 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable
to upgrade the database
    com.cloud.utils.exception.CloudRuntimeException: Unable to discover legacy zones.Operation
not allowed after ResultSet closed
    	at com.cloud.upgrade.dao.Upgrade410to420.persistLegacyZones(Upgrade410to420.java:799)
    	at com.cloud.upgrade.dao.Upgrade410to420.performDataMigration(Upgrade410to420.java:79)
    
    This error did not reproduce after this fix. LGTM on the test.


> Database upgrade from 3.0.7 to 4.9.0 fails with a ResultSet closed exception
> ----------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-9459
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9459
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Upgrade
>            Reporter: Abhinandan Prateek
>            Assignee: Abhinandan Prateek
>            Priority: Critical
>
> 3735628
> INFO  [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Running system integrity
checker com.cloud.upgrade.DatabaseUpgradeChecker@2c79821b
> INFO  [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Grabbing lock to check for
database upgrade.
> INFO  [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 3.0.7 Code Version
= 4.9.0
> INFO  [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed
from 3.0.7 to 4.9.0
> ERROR [c.c.u.d.Upgrade410to420] (main:null) (logid:) Unable to discover legacy zones.Operation
not allowed after ResultSet closed
> java.sql.SQLException: Operation not allowed after ResultSet closed
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
> 	at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:734)
> 	at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6313)
> 	at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
> 	at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
> 	at com.cloud.upgrade.dao.Upgrade410to420.persistLegacyZones(Upgrade410to420.java:725)
> 	at com.cloud.upgrade.dao.Upgrade410to420.performDataMigration(Upgrade410to420.java:79)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message