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 C833BD1E7 for ; Fri, 24 May 2013 10:32:25 +0000 (UTC) Received: (qmail 13892 invoked by uid 500); 24 May 2013 10:32:25 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 13807 invoked by uid 500); 24 May 2013 10:32:24 -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 13781 invoked by uid 500); 24 May 2013 10:32:24 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 13752 invoked by uid 99); 24 May 2013 10:32:23 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 May 2013 10:32:23 +0000 Date: Fri, 24 May 2013 10:32:23 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field "account.default" (cloud_usage.account.default field is missing) 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-2452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13666184#comment-13666184 ] ASF subversion and git services commented on CLOUDSTACK-2452: ------------------------------------------------------------- Commit ba67e5d56ed9e960e947925f82d2dda2204389ce in branch refs/heads/master from [~kishan] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=ba67e5d ] CLOUDSTACK-2452: Fixed account upgrade for usage. Added cloumn default. Updated usage response for PF , LB and VPN to return UUID instead of Id > Usage:F5:SRX:usage manager failed with db exception due to undefiled field "account.default" (cloud_usage.account.default field is missing) > ------------------------------------------------------------------------------------------------------------------------------------------- > > Key: CLOUDSTACK-2452 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2452 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: Usage > Affects Versions: 4.2.0 > Reporter: sadhu suresh > Priority: Critical > > Noticed usage manager failed with runtime exception: a undefined filed "account.default" exits in the request sql query by the usage manager , due to this usage statistics job fail with > i.e account.default field is missing in the cloud_usage.account table. > 1.install the usage server > 2.configure the usage serve to query the usage statistics for every 10 min > 3.configure the lb and generate the load form VM > 4.observe the usage statistics. > actual results: > usage job failed with runtime exception > 013-05-13 10:45:09,191 ERROR [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Exception in usage manager > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@5508e44d: 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 = 2 > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:979) > at com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findById$35() > at com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.invoke() > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findById() > at com.cloud.utils.db.GenericDaoBase.findByIdIncludingRemoved(GenericDaoBase.java:939) > at com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findByIdIncludingRemoved$36() > at com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.invoke() > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findByIdIncludingRemoved() > at com.cloud.usage.UsageManagerImpl.createVolumeHelperEvent(UsageManagerImpl.java:1075) > at com.cloud.usage.UsageManagerImpl.createHelperRecord(UsageManagerImpl.java:764) > at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:509) > at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:323) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351) > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178) > at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165) > at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267) > 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: Unknown column 'account.default' in 'field list' > 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) > "usage.log" 432L, 51892C > use cloud_usage > mysql> 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 = 2; > ERROR 1054 (42S22): Unknown column 'account.default' in 'field list' > [root@centos63 ~]# mysql cloud_usage; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1137 > Server version: 5.1.69 Source distribution > Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. > mysql> desc account; > +-----------------+---------------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-----------------+---------------------+------+-----+---------+-------+ > | id | bigint(20) unsigned | NO | PRI | NULL | | > | account_name | varchar(100) | YES | | NULL | | > | uuid | varchar(40) | YES | UNI | NULL | | > | type | int(1) unsigned | NO | | NULL | | > | domain_id | bigint(20) unsigned | YES | | NULL | | > | state | varchar(10) | NO | | enabled | | > | removed | datetime | YES | MUL | NULL | | > | cleanup_needed | tinyint(1) | NO | | 0 | | > | network_domain | varchar(100) | YES | | NULL | | > | default_zone_id | bigint(20) unsigned | YES | | NULL | | > +-----------------+---------------------+------+-----+---------+-------+ > 10 rows in set (0.00 sec) > mysql> use cloud; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > Database changed > mysql> desc account; > +-----------------+---------------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-----------------+---------------------+------+-----+---------+----------------+ > | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | > | account_name | varchar(100) | YES | MUL | NULL | | > | uuid | varchar(40) | YES | UNI | NULL | | > | type | int(1) unsigned | NO | | NULL | | > | domain_id | bigint(20) unsigned | YES | MUL | NULL | | > | state | varchar(10) | NO | | enabled | | > | removed | datetime | YES | MUL | NULL | | > | cleanup_needed | tinyint(1) | NO | MUL | 0 | | > | network_domain | varchar(255) | YES | | NULL | | > | default_zone_id | bigint(20) unsigned | YES | MUL | NULL | | > | default | int(1) unsigned | NO | | 0 | | > +-----------------+---------------------+------+-----+---------+----------------+ > 11 rows in set (0.01 sec) -- 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