[
https://issues.apache.org/jira/browse/CLOUDSTACK-9409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15319870#comment-15319870
]
ASF GitHub Bot commented on CLOUDSTACK-9409:
--------------------------------------------
GitHub user rhtyd opened a pull request:
https://github.com/apache/cloudstack/pull/1584
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.
This fixes a *blocker* for 4.9.0 reported by @nvazquez (thanks!)
/cc @swill @nvazquez for review and merge thanks.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/shapeblue/cloudstack usage-roleid-dbfix
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/cloudstack/pull/1584.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1584
----
commit fd67871a27dcb2b2a67e36e4f96ea1b0f07f0ede
Author: Rohit Yadav <rohit.ya...@shapeblue.com>
Date: 2016-06-08T02:20:46Z
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)
