[
https://issues.apache.org/jira/browse/CLOUDSTACK-3904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13722977#comment-13722977
]
ASF subversion and git services commented on CLOUDSTACK-3904:
-------------------------------------------------------------
Commit 57099c8f8fb0bbd808c91c40ae44bef593aafae2 in branch refs/heads/4.2 from
[~prachidamle]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=57099c8 ]
CLOUDSTACK-3904 listHosts API fails in VMware setup when virtualmachineid
parameter is passed
Changes:
- Pod and Cluster can be null, modified the query to append these only if
non-null
> listHosts API fails in VMware setup when virtualmachineid parameter is passed
> -----------------------------------------------------------------------------
>
> Key: CLOUDSTACK-3904
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3904
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Automation, VMware
> Affects Versions: 4.2.0
> Environment: VMware setup
> Reporter: Gaurav Aradhye
> Assignee: Prachi Damle
> Priority: Critical
>
> listHosts API failing in VMware setup (observed through test cases and also
> manually hitting the API through URL) when virtualmachineid parameter is
> passed.
> ErrorText: SELECT pod.id, SUM(IF(vm.state='Running' AND vm.account_id = ?, 1,
> 0)) FROM `cloud`.`host_pod_ref` pod LEFT JOIN `cloud`.`vm_instance` vm ON
> pod.id = vm.pod_id WHERE pod.data_center_id = ? GROUP BY pod.id ORDER BY 2
> ASC
> Steps to reproduce:
> Hit listHosts URL throgh url. Suppose setup is hosted at ip x and port y.
> Create an instance. suppose virtualmachineid of instance is z.
> Hit URL:
> http://x:y/client/api?command=listHosts&&virtualmachineid=z
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
