[
https://issues.apache.org/jira/browse/CLOUDSTACK-9409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15327414#comment-15327414
]
ASF subversion and git services commented on CLOUDSTACK-9409:
-------------------------------------------------------------
Commit fd67871a27dcb2b2a67e36e4f96ea1b0f07f0ede in cloudstack's branch
refs/heads/master from [~rohit.ya...@shapeblue.com]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=fd67871 ]
CLOUDSTACK-9409: Add role_id to cloud_usage.account
Adds role_id column to cloud_usage.account, fixes UsageDaoImpl to insert
Accounts with role_id from account table.
Signed-off-by: Rohit Yadav <rohit.ya...@shapeblue.com>
> 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)
