[
https://issues.apache.org/jira/browse/CLOUDSTACK-9409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15321477#comment-15321477
]
ASF GitHub Bot commented on CLOUDSTACK-9409:
--------------------------------------------
Github user swill commented on the issue:
https://github.com/apache/cloudstack/pull/1584
### CI RESULTS
```
Tests Run: 103
Skipped: 0
Failed: 1
Errors: 2
Duration: 4h 39m 38s
```
**Summary of the problem(s):**
```
FAIL: test_02_vpc_privategw_static_routes
(integration.smoke.test_privategw_acl.TestPrivateGwACL)
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/data/git/cs2/cloudstack/test/integration/smoke/test_privategw_acl.py", line
262, in test_02_vpc_privategw_static_routes
self.performVPCTests(vpc_off)
File
"/data/git/cs2/cloudstack/test/integration/smoke/test_privategw_acl.py", line
325, in performVPCTests
privateGw_1 = self.createPvtGw(vpc_1, "10.0.3.100", "10.0.3.101",
acl1.id, vlan_1)
File
"/data/git/cs2/cloudstack/test/integration/smoke/test_privategw_acl.py", line
595, in createPvtGw
self.fail("Failed to create Private Gateway ==> %s" % e)
AssertionError: Failed to create Private Gateway ==> Execute cmd:
createprivategateway failed, due to: errorCode: 431, errorText:Network with
vlan vlan://100 already exists in zone 1
----------------------------------------------------------------------
Additional details in: /tmp/MarvinLogs/test_network_AVQEMB/results.txt
```
```
ERROR: Test Create/Delete a manual snap shot and verify
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/data/git/cs2/cloudstack/test/integration/component/test_project_usage.py",
line 1376, in test_01_snapshot_usage
snapshot = Snapshot.create(self.apiclient, volumes[0].id)
File "/usr/lib/python2.7/site-packages/marvin/lib/base.py", line 1106, in
create
return Snapshot(apiclient.createSnapshot(cmd).__dict__)
File
"/usr/lib/python2.7/site-packages/marvin/cloudstackAPI/cloudstackAPIClient.py",
line 2857, in createSnapshot
response = self.connection.marvinRequest(command,
response_type=response, method=method)
File "/usr/lib/python2.7/site-packages/marvin/cloudstackConnection.py",
line 379, in marvinRequest
raise e
CloudstackAPIException: Execute cmd: createsnapshot failed, due to:
errorCode: 530, errorText:KVM Snapshot is not supported: 1
----------------------------------------------------------------------
Additional details in: /tmp/MarvinLogs/test_usage_AUEI82/results.txt
```
```
ERROR: Test Create/Delete a manual snap shot and verify
----------------------------------------------------------------------
Traceback (most recent call last):
File "/data/git/cs2/cloudstack/test/integration/component/test_usage.py",
line 1300, in test_01_snapshot_usage
snapshot = Snapshot.create(self.apiclient, volumes[0].id)
File "/usr/lib/python2.7/site-packages/marvin/lib/base.py", line 1106, in
create
return Snapshot(apiclient.createSnapshot(cmd).__dict__)
File
"/usr/lib/python2.7/site-packages/marvin/cloudstackAPI/cloudstackAPIClient.py",
line 2857, in createSnapshot
response = self.connection.marvinRequest(command,
response_type=response, method=method)
File "/usr/lib/python2.7/site-packages/marvin/cloudstackConnection.py",
line 379, in marvinRequest
raise e
CloudstackAPIException: Execute cmd: createsnapshot failed, due to:
errorCode: 530, errorText:KVM Snapshot is not supported: 1
----------------------------------------------------------------------
Additional details in: /tmp/MarvinLogs/test_usage_AUEI82/results.txt
```
**Associated Uploads**
**`/tmp/MarvinLogs/DeployDataCenter__Jun_08_2016_18_27_57_AIBI32:`**
*
[dc_entries.obj](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/DeployDataCenter__Jun_08_2016_18_27_57_AIBI32/dc_entries.obj)
*
[failed_plus_exceptions.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/DeployDataCenter__Jun_08_2016_18_27_57_AIBI32/failed_plus_exceptions.txt)
*
[runinfo.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/DeployDataCenter__Jun_08_2016_18_27_57_AIBI32/runinfo.txt)
**`/tmp/MarvinLogs/test_network_AVQEMB:`**
*
[failed_plus_exceptions.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_network_AVQEMB/failed_plus_exceptions.txt)
*
[results.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_network_AVQEMB/results.txt)
*
[runinfo.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_network_AVQEMB/runinfo.txt)
**`/tmp/MarvinLogs/test_usage_AUEI82:`**
*
[failed_plus_exceptions.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_usage_AUEI82/failed_plus_exceptions.txt)
*
[results.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_usage_AUEI82/results.txt)
*
[runinfo.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_usage_AUEI82/runinfo.txt)
**`/tmp/MarvinLogs/test_vpc_routers_TN1YTG:`**
*
[failed_plus_exceptions.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_vpc_routers_TN1YTG/failed_plus_exceptions.txt)
*
[results.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_vpc_routers_TN1YTG/results.txt)
*
[runinfo.txt](https://objects-east.cloud.ca/v1/e465abe2f9ae4478b9fff416eab61bd9/PR1584/tmp/MarvinLogs/test_vpc_routers_TN1YTG/runinfo.txt)
Uploads will be available until `2016-08-08 02:00:00 +0200 CEST`
*Comment created by [`upr comment`](https://github.com/cloudops/upr).*
> 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)
