[ https://issues.apache.org/jira/browse/CLOUDSTACK-9459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Burwell resolved CLOUDSTACK-9459. -------------------------------------- Resolution: Fixed The fix for this defect has been merged into the 4.9 and master branches. > 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 > Fix For: 4.10.0.0, 4.9.1.0 > > > 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)