[jira] [Updated] (CLOUDSTACK-9409) Usage server fails to work with 4.9 due to missing role_id column

["Rohit Yadav (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-9409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rohit Yadav updated CLOUDSTACK-9409:
------------------------------------
    Status: Reviewable  (was: In Progress)

> 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)