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 2F1AA11BD3 for ; Mon, 12 May 2014 17:23:16 +0000 (UTC) Received: (qmail 61370 invoked by uid 500); 10 May 2014 22:02:20 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 40868 invoked by uid 500); 10 May 2014 22:00:58 -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 16301 invoked by uid 500); 10 May 2014 21:59:09 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 90592 invoked by uid 99); 10 May 2014 21:57:44 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 10 May 2014 21:57:44 +0000 Date: Sat, 10 May 2014 21:57:44 +0000 (UTC) From: "Animesh Chaturvedi (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CLOUDSTACK-6591) AddNetworkOffering Page gives DB Exception while executing listServiceOfferings command 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-6591?page=3Dcom.atl= assian.jira.plugin.system.issuetabpanels:all-tabpanel ] Animesh Chaturvedi updated CLOUDSTACK-6591: ------------------------------------------- Assignee: Jessica Wang > AddNetworkOffering Page gives DB Exception while executing listServiceOff= erings command > -------------------------------------------------------------------------= -------------- > > Key: CLOUDSTACK-6591 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-659= 1 > 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: Latest build from 4.4 with commit ed088c72c461c08a06= 1881f78cceae7f74794b9c > Reporter: Sanjeev N > Assignee: Jessica Wang > Fix For: 4.4.0 > > Attachments: management-server.rar > > > AddNetworkOffering Page gives DB Exception while executing listServiceOff= erings command > Steps to Reproduce: > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > 1.Bring up CS with latest build from 4.4 > 2.In UI navigate to Offerings->Netowrk Offerings and click on AddNetworkO= ffering tab > Response: > =3D=3D=3D=3D=3D=3D=3D=3D=3D > Observed following response: > 2014-05-07 07:20:41,417 DEBUG [c.c.a.ApiServlet] (catalina-exec-11:ctx-ed= 1b87b3) =3D=3D=3DSTART=3D=3D=3D 10.252.193.8 -- GET command=3DlistSupport= edNetworkServices&response=3Djson&sessionkey=3DLMlB0FWN3VMYRejtxTxvcPpm7AM%= 3D&_=3D1399461637529 > 2014-05-07 07:20:41,440 DEBUG [c.c.u.AccountManagerImpl] (catalina-exec-1= 1:ctx-ed1b87b3 ctx-04a81b66) Root Access granted to Acct[da4e2c1c-d5b5-11e3= -99fa-06ab4600005f-admin] by RoleBasedEntityAccessChecker > 2014-05-07 07:20:41,456 DEBUG [c.c.a.ApiServlet] (catalina-exec-15:ctx-58= c99dc4) =3D=3D=3DSTART=3D=3D=3D 10.252.193.8 -- GET command=3DlistService= Offerings&issystem=3Dtrue&systemvmtype=3Ddomainrouter&response=3Djson&sessi= onkey=3DLMlB0FWN3VMYRejtxTxvcPpm7AM%3D&_=3D1399461637538 > 2014-05-07 07:20:41,457 DEBUG [c.c.a.ApiServlet] (catalina-exec-18:ctx-43= 5b5a6a) =3D=3D=3DSTART=3D=3D=3D 10.252.193.8 -- GET command=3DlistZones&r= esponse=3Djson&sessionkey=3DLMlB0FWN3VMYRejtxTxvcPpm7AM%3D&listAll=3Dtrue&_= =3D1399461637612 > 2014-05-07 07:20:41,487 DEBUG [c.c.a.ApiServlet] (catalina-exec-11:ctx-ed= 1b87b3 ctx-04a81b66) =3D=3D=3DEND=3D=3D=3D 10.252.193.8 -- GET command=3D= listSupportedNetworkServices&response=3Djson&sessionkey=3DLMlB0FWN3VMYRejtx= TxvcPpm7AM%3D&_=3D1399461637529 > 2014-05-07 07:20:41,502 DEBUG [c.c.u.AccountManagerImpl] (catalina-exec-1= 8:ctx-435b5a6a ctx-a35400ec) Root Access granted to Acct[da4e2c1c-d5b5-11e3= -99fa-06ab4600005f-admin] by RoleBasedEntityAccessChecker > 2014-05-07 07:20:41,510 WARN [c.c.a.d.ParamGenericValidationWorker] (cat= alina-exec-18:ctx-435b5a6a ctx-a35400ec) Received unknown parameters for co= mmand listZones. Unknown parameters : listall > 2014-05-07 07:20:41,511 DEBUG [c.c.u.AccountManagerImpl] (catalina-exec-1= 5:ctx-58c99dc4 ctx-b4f9b830) Root Access granted to Acct[da4e2c1c-d5b5-11e3= -99fa-06ab4600005f-admin] by RoleBasedEntityAccessChecker > 2014-05-07 07:20:41,532 ERROR [c.c.a.ApiServer] (catalina-exec-15:ctx-58c= 99dc4 ctx-b4f9b830) unhandled exception executing api command: [Ljava.lang.= String;@142734ad > com.cloud.utils.exception.CloudRuntimeException: Caught: com.mysql.jdbc.J= DBC4PreparedStatement@4cccb78f: 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.GeneratedMethodAccessor135.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.$Proxy278.searchAndCount(Unknown Source) > at com.cloud.api.query.QueryManagerImpl.searchForServiceOfferings= Internal(QueryManagerImpl.java:2553) > at com.cloud.api.query.QueryManagerImpl.searchForServiceOfferings= (QueryManagerImpl.java:2414) > at org.apache.cloudstack.api.command.user.offering.ListServiceOff= eringsCmd.execute(ListServiceOfferingsCmd.java:106) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:119) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:679) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:502) > at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.ja= va:330) > at com.cloud.api.ApiServlet.access$000(ApiServlet.java:54) > at com.cloud.api.ApiServlet$1.run(ApiServlet.java:118) > 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 com.cloud.api.ApiServlet.processRequest(ApiServlet.java:115) > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:77) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilt= er(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli= cationFilterChain.java:206) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardW= rapperValve.java:233) > at org.apache.catalina.core.StandardContextValve.invoke(StandardC= ontextValve.java:191) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHost= Valve.java:127) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport= Valve.java:102) > at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv= e.java:555) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEn= gineValve.java:109) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap= ter.java:298) > at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioP= rocessor.java:889) > at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHan= dler.process(Http11NioProtocol.java:721) > at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(Nio= Endpoint.java:2274) > 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 > ... 46 more > 2014-05-07 07:20:41,552 DEBUG [c.c.u.AccountManagerImpl] (catalina-exec-1= 8:ctx-435b5a6a ctx-a35400ec) Root Access granted to Acct[da4e2c1c-d5b5-11e3= -99fa-06ab4600005f-admin] by RoleBasedEntityAccessChecker > 2014-05-07 07:20:41,555 DEBUG [c.c.u.AccountManagerImpl] (catalina-exec-1= 5:ctx-58c99dc4 ctx-b4f9b830) Root Access granted to Acct[da4e2c1c-d5b5-11e3= -99fa-06ab4600005f-admin] by RoleBasedEntityAccessChecker > 2014-05-07 07:20:41,557 DEBUG [c.c.a.ApiServlet] (catalina-exec-15:ctx-58= c99dc4 ctx-b4f9b830) =3D=3D=3DEND=3D=3D=3D 10.252.193.8 -- GET command=3D= listServiceOfferings&issystem=3Dtrue&systemvmtype=3Ddomainrouter&response= =3Djson&sessionkey=3DLMlB0FWN3VMYRejtxTxvcPpm7AM%3D&_=3D1399461637538 > 2014-05-07 07:20:41,559 DEBUG [c.c.a.ApiServlet] (catalina-exec-18:ctx-43= 5b5a6a ctx-a35400ec) =3D=3D=3DEND=3D=3D=3D 10.252.193.8 -- GET command=3D= listZones&response=3Djson&sessionkey=3DLMlB0FWN3VMYRejtxTxvcPpm7AM%3D&listA= ll=3Dtrue&_=3D1399461637612 -- This message was sent by Atlassian JIRA (v6.2#6252)