[jira] [Updated] (CLOUDSTACK-7968) [Automation] ListVirtualMachines failed due to NPE
[ https://issues.apache.org/jira/browse/CLOUDSTACK-7968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Animesh Chaturvedi updated CLOUDSTACK-7968: --- Assignee: Min Chen > [Automation] ListVirtualMachines failed due to NPE > -- > > Key: CLOUDSTACK-7968 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7968 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Automation >Affects Versions: 4.5.0 >Reporter: Chandan Purushothama >Assignee: Min Chen >Priority: Critical > Fix For: 4.5.0 > > > == > NullPointer Exception: > == > {noformat} > 2014-11-25 07:02:04,577 DEBUG [c.c.a.ApiServlet] > (catalina-exec-22:ctx-3c4583df) ===START=== 10.220.135.158 -- GET > apiKey=cZnc5GpyJx80LGvhVhQMwdCSfoIyzyVRq1F4lRjI00w1xrAgCOTAZWpxgtARH_JNID8RSYjGnJalpQcy5u1Xfg&command=listVirtualMachines&signature=5T4zh0Tv4tnLOFRwNn8DRghnJkA%3D&tags%5B0%5D.key=region111&response=json&listall=True&tags%5B0%5D.value=India > 2014-11-25 07:02:04,600 ERROR [c.c.a.ApiServer] > (catalina-exec-22:ctx-3c4583df ctx-8f125542 ctx-2cc1f4d0) unhandled exception > executing api command: [Ljava.lang.String;@7bf2b28 > com.cloud.utils.exception.CloudRuntimeException: Caught: > com.mysql.jdbc.JDBC4PreparedStatement@235185cf: SELECT > DISTINCT(user_vm_view.id) FROM user_vm_view WHERE user_vm_view.account_type > != 5 AND user_vm_view.display_vm = 1 AND ( ( AND ) ) AND > user_vm_view.removed IS NULL ORDER BY user_vm_view.id ASC LIMIT 0, 1 > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:427) > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:361) > at com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:345) > at > com.cloud.utils.db.GenericDaoBase.searchAndCount(GenericDaoBase.java:1296) > at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) > at > com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > at $Proxy175.searchAndCount(Unknown Source) > at > com.cloud.api.query.QueryManagerImpl.searchForUserVMsInternal(QueryManagerImpl.java:996) > at > com.cloud.api.query.QueryManagerImpl.searchForUserVMs(QueryManagerImpl.java:756) > at > org.apache.cloudstack.api.command.user.vm.ListVMsCmd.execute(ListVMsCmd.java:227) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:141) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:691) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:514) > at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:276) > at com.cloud.api.ApiServlet$1.run(ApiServlet.java:120) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:117) > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:79) > 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.
[jira] [Updated] (CLOUDSTACK-7968) [Automation] ListVirtualMachines failed due to NPE
[ https://issues.apache.org/jira/browse/CLOUDSTACK-7968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Min Chen updated CLOUDSTACK-7968: - Description: == NullPointer Exception: == {noformat} 2014-11-25 07:02:04,577 DEBUG [c.c.a.ApiServlet] (catalina-exec-22:ctx-3c4583df) ===START=== 10.220.135.158 -- GET apiKey=cZnc5GpyJx80LGvhVhQMwdCSfoIyzyVRq1F4lRjI00w1xrAgCOTAZWpxgtARH_JNID8RSYjGnJalpQcy5u1Xfg&command=listVirtualMachines&signature=5T4zh0Tv4tnLOFRwNn8DRghnJkA%3D&tags%5B0%5D.key=region111&response=json&listall=True&tags%5B0%5D.value=India 2014-11-25 07:02:04,600 ERROR [c.c.a.ApiServer] (catalina-exec-22:ctx-3c4583df ctx-8f125542 ctx-2cc1f4d0) unhandled exception executing api command: [Ljava.lang.String;@7bf2b28 com.cloud.utils.exception.CloudRuntimeException: Caught: com.mysql.jdbc.JDBC4PreparedStatement@235185cf: SELECT DISTINCT(user_vm_view.id) FROM user_vm_view WHERE user_vm_view.account_type != 5 AND user_vm_view.display_vm = 1 AND ( ( AND ) ) AND user_vm_view.removed IS NULL ORDER BY user_vm_view.id ASC LIMIT 0, 1 at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:427) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:361) at com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:345) at com.cloud.utils.db.GenericDaoBase.searchAndCount(GenericDaoBase.java:1296) at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy175.searchAndCount(Unknown Source) at com.cloud.api.query.QueryManagerImpl.searchForUserVMsInternal(QueryManagerImpl.java:996) at com.cloud.api.query.QueryManagerImpl.searchForUserVMs(QueryManagerImpl.java:756) at org.apache.cloudstack.api.command.user.vm.ListVMsCmd.execute(ListVMsCmd.java:227) at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:141) at com.cloud.api.ApiServer.queueCommand(ApiServer.java:691) at com.cloud.api.ApiServer.handleRequest(ApiServer.java:514) at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:276) at com.cloud.api.ApiServlet$1.run(ApiServlet.java:120) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:117) at com.cloud.api.ApiServlet.doGet(ApiServlet.java:79) 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$Http11Connect