cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nvazquez <>
Subject [GitHub] cloudstack issue #1584: [BLOCKER][FIX] CLOUDSTACK-9409: Add role_id to cloud...
Date Thu, 09 Jun 2016 15:25:42 GMT
Github user nvazquez commented on the issue:
    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 DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@3202d58a:
SELECT, 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 = 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

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 or file a JIRA ticket
with INFRA.

View raw message