On Thu, Nov 29, 2012 at 11:13 AM, Johann Hoehn <johann.ho...@ecommerce.com> wrote: > On 11/24/2012 10:53 PM, Junpei Tsutsui wrote: >> >> Hi, >> >> I installed CloudStack 4.0.0 following the installation guide and >> instances >> are running well on it. >> I 'm using CentOS 6.3 for management server and XenServer 6.0.2 for >> compute >> nodes. >> >> Then, I installed usage server on the management server by "yum install >> cloud-usage" and run it. >> But the usage job failed due to a SQL error. >> >> >> [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. >> >> >> I found a same issue for CloudStack 3.0.3 in bug tracker but it's already >> closed. >> http://bugs.cloudstack.org/browse/CS-15170 >> >> Anyone could run usage server well on 4.0.0? >> >> Thanks, >> Junpei >> > Hi, > > I also have a fresh install of 4.0.0 and the bug was still there. I added > the table and now waiting for usage parser to rerun to verify it is fully > fixed. > > > --johann
The workaround for this is executing the following on the cloud_usage database: ALTER TABLE `cloud_usage`.`account` ADD COLUMN `default_zone_id` bigint unsigned; I've filed a blocker bug for 4.0.1 to fix this issue: https://issues.apache.org/jira/browse/CLOUDSTACK-560
