[
https://issues.apache.org/jira/browse/CLOUDSTACK-3904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13722359#comment-13722359
]
Gaurav Aradhye commented on CLOUDSTACK-3904:
--------------------------------------------
Here's the log. I guess its same as the error-text. Hope it helps.
2013-07-29 01:51:06,399 ERROR [cloud.api.ApiServer] (catalina-exec-24:null)
unhandled exception executing api command: listHosts
com.cloud.utils.exception.CloudRuntimeException: Caught: 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
at
com.cloud.vm.dao.VMInstanceDaoImpl.listHostIdsByVmCount(VMInstanceDaoImpl.java:578)
at
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
at
com.cloud.agent.manager.allocator.impl.FirstFitAllocator.reorderHostsByNumberOfVms(FirstFitAllocator.java:314)
at
com.cloud.agent.manager.allocator.impl.FirstFitAllocator.allocateTo(FirstFitAllocator.java:234)
at
com.cloud.agent.manager.allocator.impl.FirstFitAllocator.allocateTo(FirstFitAllocator.java:222)
at
com.cloud.server.ManagementServerImpl.listHostsForMigrationOfVM(ManagementServerImpl.java:1132)
at
org.apache.cloudstack.api.command.admin.host.ListHostsCmd.execute(ListHostsCmd.java:174)
at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:158)
at com.cloud.api.ApiServer.queueCommand(ApiServer.java:514)
at com.cloud.api.ApiServer.handleRequest(ApiServer.java:372)
at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:305)
at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889)
at
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2268)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.NullPointerException
at
com.cloud.vm.dao.VMInstanceDaoImpl.listHostIdsByVmCount(VMInstanceDaoImpl.java:567)
... 32 more
> 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
