Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 129B710CBF for ; Mon, 19 Aug 2013 06:16:51 +0000 (UTC) Received: (qmail 31037 invoked by uid 500); 19 Aug 2013 06:16:50 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 30865 invoked by uid 500); 19 Aug 2013 06:16:49 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 30850 invoked by uid 500); 19 Aug 2013 06:16:49 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 30839 invoked by uid 99); 19 Aug 2013 06:16:48 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Aug 2013 06:16:48 +0000 Date: Mon, 19 Aug 2013 06:16:48 +0000 (UTC) From: "Sowmya Krishnan (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (CLOUDSTACK-4384) [Simulator] Trying to refer to tables in simulator DB instead of cloud DB after using configureSimulator for delay MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-4384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sowmya Krishnan closed CLOUDSTACK-4384. --------------------------------------- Verified > [Simulator] Trying to refer to tables in simulator DB instead of cloud DB after using configureSimulator for delay > ------------------------------------------------------------------------------------------------------------------ > > Key: CLOUDSTACK-4384 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4384 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: API, Management Server > Affects Versions: 4.2.0 > Environment: latest 4.2, Build with simulator > Reporter: Sowmya Krishnan > Assignee: Prasanna Santhanam > Fix For: 4.2.0 > > > While creating accounts and deploying simulator VMs, MS is trying to access tables in simulator table which don't exist instead of cloud DB. Noticed this after using configureSimulator to induce delay for few commands > Steps > ===== > Build with simulator: > mvn -Pdeveloper -pl developer -Ddeploydb-simulator > mvn -Pdeveloper -pl developer -Ddeploydb > mvn -Pdeveloper -pl developer -Ddeploydb-simulator > Deploy zone, cluster, pod, host, secondary storage. > Use configureSimulator to induce delay for some commands: > ex:http://localhost:8096/client/api?command=configureSimulator&zoneid=1&name=CreateCommand&value=wait:10000 > Create user account and deploy simulator VMs as user/admin > Finding the following exception while deploying simulator VM: > 2013-08-19 09:42:25,937 DEBUG [allocator.impl.FirstFitAllocator] (Job-Executor-22:job-22 = [ 69f175f0-bd75-42d8-9205-a2e5927c1506 ] FirstFitRoutingAllocator) > Found a suitable host, adding to list: 28 > 2013-08-19 09:42:25,943 ERROR [cloud.api.ApiServer] (ApiServer-1:null) unhandled exception executing api command: listNetworks > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@15ebcb3: SELECT account.id, account.account_name, account.type, account.domain_id, account.state, account.removed, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default FROM account WHERE account.id = 0 AND account.removed IS NULL > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:985) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:962) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:923) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.user.AccountManagerImpl.getActiveAccountById(AccountManagerImpl.java:1655) > at com.cloud.api.ApiDispatcher.doAccessChecks(ApiDispatcher.java:110) > at com.cloud.api.ApiDispatcher.processParameters(ApiDispatcher.java:313) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:132) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:514) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:372) > at com.cloud.api.ApiServer.handle(ApiServer.java:303) > 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:978) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:679) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'simulator.account' doesn't exist > 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: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.executeQuery(PreparedStatement.java:2318) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:982) > ... 30 more > 2013-08-19 09:42:25,955 DEBUG [cloud.capacity.CapacityManagerImpl] (Job-Executor-22:job-22 = [ 69f175f0-bd75-42d8-9205-a2e5927c1506 ] FirstFitRoutingAllocator) Checking if host: 31 has enough capacity for requested CPU: 100 and requested RAM: 125829120 , cpuOverprovisioningFactor: 1.0 > Finding this exception while creating account: > 2013-08-19 10:13:26,475 DEBUG [cloud.network.NetworkManagerImpl] (ApiServer-10:null) Releasing lock for Acct[24aebc27-b60c-4bd8-b152-06d816f29e5a-test4] > 2013-08-19 10:13:26,537 ERROR [cloud.api.ApiServer] (ApiServer-1:null) unhandled exception executing api command: createAccount > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@1dd7b11: SELECT account.id, account.account_name, acc > ount.type, account.domain_id, account.state, account.removed, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account. > default FROM account WHERE account.id = 1 AND account.removed IS NULL > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:985) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:962) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:923) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.user.AccountManagerImpl.getActiveAccountById(AccountManagerImpl.java:1655) > at com.cloud.api.ApiDispatcher.doAccessChecks(ApiDispatcher.java:110) > at com.cloud.api.ApiDispatcher.processParameters(ApiDispatcher.java:313) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:132) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:514) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:372) > at com.cloud.api.ApiServer.handle(ApiServer.java:303) > 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:978) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:679) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'simulator.account' doesn't exist > 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: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.executeQuery(PreparedStatement.java:2318) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:982) > ... 30 more > 2013-08-19 10:13:26,547 ERROR [cloud.api.ApiDispatcher] (ApiServer-2:null) CloudRuntimeException -- 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