[
https://issues.apache.org/jira/browse/CLOUDSTACK-3904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alena Prokharchyk reassigned CLOUDSTACK-3904:
---------------------------------------------
Assignee: (was: Alena Prokharchyk)
> 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
> 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
