cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nvazquez <...@git.apache.org>
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:

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

Mime
View raw message