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
