[jira] [Created] (CLOUDSTACK-3904) listHosts API fails in VMware setup when virtualmachineid parameter is passed

["Gaurav Aradhye (JIRA)" <ji...@apache.org>]

Gaurav Aradhye created CLOUDSTACK-3904:
------------------------------------------

             Summary: 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
    Affects Versions: 4.2.0
         Environment: VMware setup
            Reporter: Gaurav Aradhye


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