Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7834C11BA6 for ; Thu, 5 Jun 2014 08:28:02 +0000 (UTC) Received: (qmail 24376 invoked by uid 500); 5 Jun 2014 08:28:02 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 24352 invoked by uid 500); 5 Jun 2014 08:28:02 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 24345 invoked by uid 500); 5 Jun 2014 08:28:02 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 24342 invoked by uid 99); 5 Jun 2014 08:28:02 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jun 2014 08:28:02 +0000 Date: Thu, 5 Jun 2014 08:28:02 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-6843) [Automation] List listServiceOfferings api fails with NPE MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-6843?page=3Dcom.atla= ssian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= =3D14018577#comment-14018577 ]=20 ASF subversion and git services commented on CLOUDSTACK-6843: ------------------------------------------------------------- Commit 025c143ac7929055577911114751118cf5319592 in cloudstack's branch refs= /heads/4.4-forward from [~koushikd] [ https://git-wip-us.apache.org/repos/asf?p=3Dcloudstack.git;h=3D025c143 ] CLOUDSTACK-6843: [Automation] List listServiceOfferings api fails with NPE Incorrect parameter name used in query building resulted in a bad sql query= . > [Automation] List listServiceOfferings api fails with NPE > --------------------------------------------------------- > > Key: CLOUDSTACK-6843 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-684= 3 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the defa= ult.)=20 > Components: Management Server > Affects Versions: 4.4.0 > Environment: KVM - RHEL 6.3 > 4.4-forward brach > Reporter: Rayees Namathponnan > Assignee: Koushik Das > Fix For: 4.4.0 > > Attachments: management-server.rar > > > Create advanced zone in KVM, and execute below api=20 > http://10.223.49.195:8096/?command=3DlistServiceOfferings&issystem=3Dtrue= &systemvmtype=3Dsecondarystoragevm > API failes with below NPE > 2014-06-04 09:22:12,874 DEBUG [c.c.a.ApiServlet] (catalina-exec-3:ctx-bbf= c4fe7) =3D=3D=3DSTART=3D=3D=3D 10.223.240.194 -- GET jobid=3D6ad437e8-e8a= 5-43f0-9836-9a971895f2ff&apiKey=3DfRS2dHRVFlXSTC9bs2rBKXwD0FNnpHk-Dz_2XI8fg= FZii_P6Tx5eLyzluOx8lvuonsbqknPHnIFYT5xNhEvUEA&command=3DqueryAsyncJobResult= &response=3Djson&signature=3DvWt6TJzRGujyODUGV4qlWRw2PnU%3D > 2014-06-04 09:22:12,889 DEBUG [c.c.a.ApiServlet] (catalina-exec-3:ctx-bbf= c4fe7 ctx-6459f16c ctx-ee0f0e0d) =3D=3D=3DEND=3D=3D=3D 10.223.240.194 -- G= ET jobid=3D6ad437e8-e8a5-43f0-9836-9a971895f2ff&apiKey=3DfRS2dHRVFlXSTC9bs= 2rBKXwD0FNnpHk-Dz_2XI8fgFZii_P6Tx5eLyzluOx8lvuonsbqknPHnIFYT5xNhEvUEA&comma= nd=3DqueryAsyncJobResult&response=3Djson&signature=3DvWt6TJzRGujyODUGV4qlWR= w2PnU%3D > 2014-06-04 09:22:15,343 ERROR [c.c.a.ApiServer] (ApiServer-2:ctx-b32fc69a= ctx-2409f636) unhandled exception executing api command: [Ljava.lang.Strin= g;@3e2251cf > com.cloud.utils.exception.CloudRuntimeException: Caught: com.mysql.jdbc.J= DBC4PreparedStatement@5998caad: SELECT service_offering_view.id, service_of= fering_view.uuid, service_offering_view.name, service_offering_view.display= _text, service_offering_view.tags, service_offering_view.use_local_storage,= service_offering_view.system_use, service_offering_view.cpu, service_offer= ing_view.speed, service_offering_view.ram_size, service_offering_view.nw_ra= te, service_offering_view.mc_rate, service_offering_view.ha_enabled, servic= e_offering_view.limit_cpu_use, service_offering_view.is_volatile, service_o= ffering_view.host_tag, service_offering_view.default_use, service_offering_= view.vm_type, service_offering_view.customized_iops, service_offering_view.= min_iops, service_offering_view.max_iops, service_offering_view.hv_ss_reser= ve, service_offering_view.sort_key, service_offering_view.bytes_read_rate, = service_offering_view.bytes_write_rate, service_offering_view.iops_read_rat= e, service_offering_view.iops_write_rate, service_offering_view.created, se= rvice_offering_view.removed, service_offering_view.domain_id, service_offer= ing_view.domain_uuid, service_offering_view.domain_name, service_offering_v= iew.domain_path, service_offering_view.deployment_planner FROM service_offe= ring_view WHERE service_offering_view.system_use =3D 1 AND AND service_of= fering_view.removed IS NULL ORDER BY service_offering_view.sort_key DESC = LIMIT 0, 500 > at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(Gener= icDaoBase.java:427) > at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(Gener= icDaoBase.java:361) > at com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:3= 45) > at com.cloud.utils.db.GenericDaoBase.searchAndCount(GenericDaoBas= e.java:1296) > at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth= odAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.springframework.aop.support.AopUtils.invokeJoinpointUsingR= eflection(AopUtils.java:317) > at org.springframework.aop.framework.ReflectiveMethodInvocation.i= nvokeJoinpoint(ReflectiveMethodInvocation.java:183) > at org.springframework.aop.framework.ReflectiveMethodInvocation.p= roceed(ReflectiveMethodInvocation.java:150) > at com.cloud.utils.db.TransactionContextInterceptor.invoke(Transa= ctionContextInterceptor.java:34) > at org.springframework.aop.framework.ReflectiveMethodInvocation.p= roceed(ReflectiveMethodInvocation.java:161) > at org.springframework.aop.interceptor.ExposeInvocationIntercepto= r.invoke(ExposeInvocationInterceptor.java:91) > at org.springframework.aop.framework.ReflectiveMethodInvocation.p= roceed(ReflectiveMethodInvocation.java:172) > at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Jd= kDynamicAopProxy.java:204) > at com.sun.proxy.$Proxy277.searchAndCount(Unknown Source) > at com.cloud.api.query.QueryManagerImpl.searchForServiceOfferings= Internal(QueryManagerImpl.java:2552) > at com.cloud.api.query.QueryManagerImpl.searchForServiceOfferings= (QueryManagerImpl.java:2413) > at org.apache.cloudstack.api.command.user.offering.ListServiceOff= eringsCmd.execute(ListServiceOfferingsCmd.java:106) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:141) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:683) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:506) > at com.cloud.api.ApiServer.handle(ApiServer.java:416) > at org.apache.http.protocol.HttpService.doService(HttpService.jav= a:375) > at org.apache.http.protocol.HttpService.handleRequest(HttpService= .java:290) > at com.cloud.api.ApiServer$WorkerTask.runInContext(ApiServer.java= :1169) > at org.apache.cloudstack.managed.context.ManagedContextRunnable$1= .run(ManagedContextRunnable.java:49) > at org.apache.cloudstack.managed.context.impl.DefaultManagedConte= xt$1.call(DefaultManagedContext.java:56) > at org.apache.cloudstack.managed.context.impl.DefaultManagedConte= xt.callWithContext(DefaultManagedContext.java:103) > at org.apache.cloudstack.managed.context.impl.DefaultManagedConte= xt.runWithContext(DefaultManagedContext.java:53) > at org.apache.cloudstack.managed.context.ManagedContextRunnable.r= un(ManagedContextRunnable.java:46) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolEx= ecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolE= xecutor.java:615) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.NullPointerException > ... 33 more > 2014-06-04 09:22:15,465 ERROR [c.c.a.ApiServer] (ApiServer-4:ctx-28f055e8= ctx-29e0d36a) invalid request, no command sent > 2014-06-04 09:22 -- This message was sent by Atlassian JIRA (v6.2#6252)