cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johann Hoehn <johann.ho...@ecommerce.com>
Subject Re: Exception in CS4 usage server
Date Thu, 29 Nov 2012 16:13:46 GMT
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

Mime
View raw message