Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-dev@incubator.apache.org
Date: Mon, 10 Dec 2012 14:15:22 +0000 (UTC)
From: "Kishan Kavala (JIRA)" <jira@apache.org>
To: cloudstack-dev@incubator.apache.org
Message-ID: <JIRA.12618175.1354206589595.11761.1355148922864@arcas>
In-Reply-To: <JIRA.12618175.1354206589595@arcas>
References: <JIRA.12618175.1354206589595@arcas>
Subject: [jira] [Commented] (CLOUDSTACK-560) Usage server doesn't work in
 4.0.0 due to missing db changes
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Kishan Kavala commented on CLOUDSTACK-560:
------------------------------------------


Branch 4.0
commit 91a9cce35a67350c856bb10e5fe36f4bf5bac029
Author: Kishan Kavala <kishan@cloud.com>
Date:   Mon Dec 10 19:37:57 2012 +0530

Branch master
commit 199806c1be28c9706090d55c63ffb814c3cb80be
Author: Kishan Kavala <kishan@cloud.com>
Date:   Mon Dec 10 19:37:57 2012 +0530


> Usage server doesn't work in 4.0.0 due to missing db changes
> ------------------------------------------------------------
>
>                 Key: CLOUDSTACK-560
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-560
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Usage
>    Affects Versions: 4.0.0
>            Reporter: David Nalley
>            Assignee: Kishan Kavala
>            Priority: Blocker
>              Labels: database, upgrade
>             Fix For: 4.0.1, 4.1.0
>
>
> [Alerts]
> Usage job failed. Job id: 1 25 Nov 2012 03:13:00
> [usage.log]
> 2012-11-25 03:13:00,154 ERROR [cloud.usage.UsageManagerImpl]
> (Usage-Job-1:null) Exception in usage manager
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> org.apache.commons.dbcp.DelegatingPreparedStatement@5b5a5cf
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'account.default_zone_id' in 'field list'
> The usage server tried to get "account.default_zone_id" from "cloud_usage"
> database, but the "account" table doesn't have "default_zone_id" column.
> Kishan: This is the same bug as http://bugs.cloudstack.org/browse/CS-15170 - which apparently didn't make it into master or 4.0 branch. 

--
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