[
https://issues.apache.org/jira/browse/CLOUDSTACK-9459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15430329#comment-15430329
]
ASF GitHub Bot commented on CLOUDSTACK-9459:
--------------------------------------------
Github user PaulAngus commented on the issue:
https://github.com/apache/cloudstack/pull/1641
LGTM - tested against a client db which initially failed.
> 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)
