[ https://issues.apache.org/jira/browse/CLOUDSTACK-7968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14230796#comment-14230796 ]
Min Chen commented on CLOUDSTACK-7968: -------------------------------------- Please attach the db dump for investigation. > [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, 10000 > 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$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.utils.db.GenericDaoBase.prepareAttribute(GenericDaoBase.java:1469) > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:402) > ... 45 more > 2014-11-25 07:02:04,606 DEBUG [c.c.a.ApiServlet] > (catalina-exec-22:ctx-3c4583df ctx-8f125542 ctx-2cc1f4d0) ===END=== > 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 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)