[ https://issues.apache.org/jira/browse/CLOUDSTACK-9459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15430330#comment-15430330 ]
ASF subversion and git services commented on CLOUDSTACK-9459: ------------------------------------------------------------- Commit a2fcc65d9050b9cd6915e36e5274379aa3298957 in cloudstack's branch refs/heads/4.9 from [~abhi_shapeblue] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=a2fcc65 ] CLOUDSTACK-9459: the try's catch block was shortening the preparedstatement life resulting in bad resultset when used outside of try catch. > 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)