cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-2664) Upgrade failure while removing Firewall service for SG shared network offering
Date Fri, 24 May 2013 07:09:20 GMT

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

ASF subversion and git services commented on CLOUDSTACK-2664:
-------------------------------------------------------------

Commit 3b48299a0395916ad3dc8a95b6d98afd96ecf251 in branch refs/heads/master from [~kishan]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=3b48299 ]

CLOUDSTACK-2664: Fixed delete query. Added log message when CloudRuntimeException is thrown
during upgrade

                
> Upgrade failure while removing Firewall service for SG shared network offering
> ------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-2664
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2664
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>            Reporter: Kishan Kavala
>            Assignee: Kishan Kavala
>             Fix For: 4.2.0
>
>
> Incorrect SQL is causing below exception during 41 to 42 upgrade :
> com.cloud.utils.exception.CloudRuntimeException: Unable to remove Firewall service for
SG shared network offering.
> 	at com.cloud.upgrade.dao.Upgrade410to420.removeFirewallServiceFromSharedNetworkOfferingWithSGService(Upgrade410to420.java:767)
> 	at com.cloud.upgrade.dao.Upgrade410to420.performDataMigration(Upgrade410to420.java:78)
> 	at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:239)
> 	at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:364)
> 	at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
> 	at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
> 	at java.util.TimerThread.mainLoop(Timer.java:555)
> 	at java.util.TimerThread.run(Timer.java:505)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'where network_offering_id=5 and service='Firewall'' at line 1
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:386)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
> 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
> 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
> 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> 	at com.cloud.upgrade.dao.Upgrade410to420.removeFirewallServiceFromSharedNetworkOfferingWithSGService(Upgrade410to420.java:764)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message