[
https://issues.apache.org/jira/browse/CLOUDSTACK-9409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15322694#comment-15322694
]
ASF GitHub Bot commented on CLOUDSTACK-9409:
--------------------------------------------
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
> Usage server fails to work with 4.9 due to missing role_id column
> -----------------------------------------------------------------
>
> Key: CLOUDSTACK-9409
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9409
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.9.0
> Reporter: Rohit Yadav
> Assignee: Rohit Yadav
> Priority: Blocker
>
> Thanks to Nicolas for reporting. The usage server fails to work due to
> missing role_id column;
> 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'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
