You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Harikrishna Patnala (JIRA)" <ji...@apache.org> on 2013/05/01 08:38:15 UTC
[jira] [Resolved] (CLOUDSTACK-2198) Blacklisted Routes should be
allowed to be updated to NULL at Zone level scope
[ https://issues.apache.org/jira/browse/CLOUDSTACK-2198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Harikrishna Patnala resolved CLOUDSTACK-2198.
---------------------------------------------
Resolution: Fixed
commit deaf9106ca557a938edf25bee65cf6b4eb3ac03f
Fix is to alter details table with value column that accepts null
> Blacklisted Routes should be allowed to be updated to NULL at Zone level scope
> ------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-2198
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2198
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Management Server
> Affects Versions: 4.2.0
> Reporter: Chandan Purushothama
> Assignee: Harikrishna Patnala
> Priority: Critical
> Fix For: 4.2.0
>
>
> =================
> Command Execution:
> =================
> http://10.223.131.170:8096/?command=updateConfiguration&name=blacklisted.routes&id=1&value=&scope=zone
> <updateconfigurationresponse cloud-stack-version="4.2.0-SNAPSHOT"><errorcode>530</errorcode><cserrorcode>4250</cserrorcode><errortext>DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@62f3f7c2: INSERT INTO data_center_details (data_center_details.dc_id, data_center_details.name, data_center_details.value) VALUES (1, _binary'blacklisted.routes', null)</errortext></updateconfigurationresponse>
> ===========================
> Management Server Log Information:
> ===========================
> 2013-04-25 15:07:20,843 INFO [cloud.api.ApiServer] (ApiServer-1:null) Invalid value for blacklisted route: NULL. Valid format is list of cidrs separated by coma. Example: 10.1.1.0/24,192.168.0.0/24
> 2013-04-25 15:07:28,538 DEBUG [db.Transaction.Transaction] (ApiServer-2:null) Rolling back the transaction: Time = 1 Name = updateConfiguration; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-ConfigurationManagerImpl.updateConfiguration:346-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-ConfigurationManagerImpl.updateConfiguration:479-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-UpdateCfgCmd.execute:88-ApiDispatcher.dispatch:155-ApiServer.queueCommand:512
> 2013-04-25 15:07:28,546 ERROR [cloud.api.ApiServer] (ApiServer-2:null) unhandled exception executing api command: updateConfiguration
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@62f3f7c2: INSERT INTO data_center_details (data_center_details.dc_id, data_center_details.name, data_center_details.value) VALUES (1, _binary'blacklisted.routes', null)
> at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1342)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at com.cloud.configuration.ConfigurationManagerImpl.updateConfiguration(ConfigurationManagerImpl.java:346)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at com.cloud.configuration.ConfigurationManagerImpl.updateConfiguration(ConfigurationManagerImpl.java:479)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at org.apache.cloudstack.api.command.admin.config.UpdateCfgCmd.execute(UpdateCfgCmd.java:88)
> at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:155)
> at com.cloud.api.ApiServer.queueCommand(ApiServer.java:512)
> at com.cloud.api.ApiServer.handleRequest(ApiServer.java:362)
> at com.cloud.api.ApiServer.handle(ApiServer.java:293)
> at org.apache.http.protocol.HttpService.doService(HttpService.java:375)
> at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:290)
> at com.cloud.api.ApiServer$WorkerTask.run(ApiServer.java:975)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'value' cannot be null
> 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:532)
> 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:1040)
> 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.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1305)
> ... 28 more
> 2013-04-25 15:07:31,561 DEBUG [cloud.server.StatsCollector] (StatsCollector-2:null) StorageCollector is running...
> 2013-04-25 15:07:34,179 DEBUG [agent.transport.Request] (StatsCollector-2:null) Seq 7-850460688: Received: { Ans: , MgmtId: 7200344900649, via: 7, Ver: v1, Flags: 10, { GetStorageStatsAnswer } }
> 2013-04-25 15:07:34,853 DEBUG [cloud.server.StatsCollector] (StatsCollector-1:null) HostStatsCollector is running...
> 2013-04-25 15:07:35,485 DEBUG [agent.transport.Request] (StatsCollector-1:null) Seq 1-1278672924: Received: { Ans: , MgmtId: 7200344900649, via: 1, Ver: v1, Flags: 10, { GetHostStatsAnswer } }
> 2013-04-25 15:07:35,952 DEBUG [cloud.server.StatsCollector] (StatsCollector-2:null) VmStatsCollector is running...
> 2013-04-25 15:07:36,678 DEBUG [agent.transport.Request] (StatsCollector-2:null) Seq 1-1278672925: Received: { Ans: , MgmtId: 7200344900649, via: 1, Ver: v1, Flags: 10, { GetVmStatsAnswer } }
> 2013-04-25 15:07:38,425 DEBUG [storage.secondary.SecondaryStorageManagerImpl] (secstorage-1:null) Zone 1 is ready to launch secondary storage VM
> 2013-04-25 15:07:38,799 DEBUG [cloud.consoleproxy.ConsoleProxyManagerImpl] (consoleproxy-1:null) Zone 1 is ready to launch console proxy
--
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