You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/08/16 08:54:21 UTC
[jira] [Commented] (CLOUDSTACK-9459) Database upgrade from 3.0.7 to
4.9.0 fails with a ResultSet closed exception
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15422446#comment-15422446 ]
ASF GitHub Bot commented on CLOUDSTACK-9459:
--------------------------------------------
GitHub user abhinandanprateek opened a pull request:
https://github.com/apache/cloudstack/pull/1641
CLOUDSTACK-9459: the try's catch blick was shortening the preparedstatement life
the try's catch blick was shortening the preparedstatement's life resulting in bad resultset when used outside of try catch.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/shapeblue/cloudstack upgrade_fix
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/cloudstack/pull/1641.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1641
----
commit a2fcc65d9050b9cd6915e36e5274379aa3298957
Author: Abhinandan Prateek <ab...@shapeblue.com>
Date: 2016-08-16T08:34:43Z
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)