Github user nvazquez commented on the issue:
https://github.com/apache/cloudstack/pull/1584
Thanks @rhtyd for this fix!
Just for the record, this was error before this fix:
````
2016-06-07 11:04:51,233 ERROR [cloud.usage.UsageManagerImpl]
(Usage-Job-1:null) (logid:) Exception in usage manager
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
com.mysql.jdbc.JDBC4PreparedStatement@3202d58a: SELECT account.id,
account.account_name, account.type, account.role_id, 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
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'account.role_id' in 'field list'
````
And now I can see usage jobs work properly:
````
2016-06-09 00:00:52,561 DEBUG [cloud.usage.UsageManagerImpl]
(Usage-HB-1:null) (logid:) Scheduling Usage job...
2016-06-09 00:00:52,561 INFO [cloud.usage.UsageManagerImpl]
(Usage-Job-1:null) (logid:) starting usage job...
2016-06-09 00:00:52,568 INFO [cloud.usage.UsageManagerImpl]
(Usage-Job-1:null) (logid:) Parsing usage records between Wed Jun 08 00:00:00
PDT 2016 and Wed Jun 08 23:59:59 PDT 2016
....
2016-06-09 00:00:53,436 INFO [cloud.usage.UsageManagerImpl]
(Usage-Job-1:null) (logid:) usage job complete
````
LGTM
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
