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 DCFFF9EF8 for ; Tue, 14 May 2013 05:11:18 +0000 (UTC) Received: (qmail 14161 invoked by uid 500); 14 May 2013 05:11:18 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 14038 invoked by uid 500); 14 May 2013 05:11:18 -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 13973 invoked by uid 500); 14 May 2013 05:11:17 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 13952 invoked by uid 99); 14 May 2013 05:11:16 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 May 2013 05:11:16 +0000 Date: Tue, 14 May 2013 05:11:16 +0000 (UTC) From: "Min Chen (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-2470) Object_Store_Refactor - Not able to list volumes - DB exception when selecting from volume_view 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-2470?page=3Dcom.atla= ssian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= =3D13656750#comment-13656750 ]=20 Min Chen commented on CLOUDSTACK-2470: -------------------------------------- Fixed in feature branch object_store with commit bbdab9806d55b1fe04a34de189= 6cd7dd6f6b883e =20 > Object_Store_Refactor - Not able to list volumes - DB exception when sele= cting from volume_view > -------------------------------------------------------------------------= ---------------------- > > Key: CLOUDSTACK-2470 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-247= 0 > 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.2.0 > Environment: Build from object_store > Reporter: Sangeetha Hariharan > Assignee: Min Chen > Priority: Critical > Fix For: 4.2.0 > > > Object_Store_Refactor - Not able to list volumes - DB exception when sele= cting from volume_view > Steps to reproduce the problem: > Set up - Advanced Zone with Xenserver 6.1 host. > Deploy few user Vms. > From volumes tab , list all the volumes. > API call fails:=20 > 2013-05-13 17:34:43,736 INFO [cloud.api.ApiServer] (catalina-exec-18:nul= l) (userId=3D2 accountId=3D2 sessionId=3DAB8FB9C63498F505DAF5E214 > EEEA3D88) 10.217.252.128 -- GET command=3DlistVolumes&response=3Djson&ses= sionkey=3DWQ3bR3%2Fa6UDdygOkukpnugfHMuE%3D&listAll=3Dtrue&page=3D1&pa > gesize=3D20&_=3D1368495102545 530 DB Exception on: com.mysql.jdbc.JDBC4Pr= eparedStatement@78782188: SELECT volume_view.id, volume_view.uu > id, volume_view.name, volume_view.device_id, volume_view.volume_type, vol= ume_view.size, volume_view.state, volume_view.created, volu > me_view.attached, volume_view.removed, volume_view.account_id, volume_vie= w.account_uuid, volume_view.account_name, volume_view.accou > nt_type, volume_view.domain_id, volume_view.domain_uuid, volume_view.doma= in_name, volume_view.domain_path, volume_view.project_id, v > olume_view.project_uuid, volume_view.project_name, volume_view.pod_id, vo= lume_view.data_center_id, volume_view.data_center_uuid, vol > ume_view.data_center_name, volume_view.data_center_type, volume_view.vm_i= d, volume_view.vm_uuid, volume_view.vm_name, volume_view.vm > _display_name, volume_view.vm_state, volume_view.vm_type, volume_view.vol= ume_host_size, volume_view.volume_host_created, volume_view > .format, volume_view.download_pct, volume_view.download_state, volume_vie= w.error_str, volume_view.hypervisor_type, volume_view.disk_ > offering_id, volume_view.disk_offering_uuid, volume_view.disk_offering_na= me, volume_view.disk_offering_display_text, volume_view.sys > tem_use, volume_view.use_local_storage, volume_view.pool_id, volume_view.= pool_uuid, volume_view.pool_name, volume_view.template_id, > volume_view.template_uuid, volume_view.extractable, volume_view.template_= type, volume_view.job_id, volume_view.job_uuid, volume_view > .job_status, volume_view.tag_id, volume_view.tag_uuid, volume_view.tag_ke= y, volume_view.tag_value, volume_view.tag_domain_id, volume > _view.tag_account_id, volume_view.tag_resource_id, volume_view.tag_resour= ce_uuid, volume_view.tag_resource_type, volume_view.tag_cus > tomer FROM volume_view WHERE volume_view.id IN (5,3) > Following exception seen in management server logs: > 2013-05-13 17:32:27,379 DEBUG [cloud.api.ApiServlet] (catalina-exec-16:nu= ll) =3D=3D=3DSTART=3D=3D=3D 10.217.252.128 -- GET command=3DlistVolumes&r= esponse=3Djson&sessionkey=3DWQ3bR3%2Fa6UDdygOkukpnugfHMuE%3D&listAll=3Dtrue= &page=3D1&pagesize=3D20&_=3D1368494966167 > 2013-05-13 17:32:27,383 DEBUG [agent.manager.AgentManagerImpl] (AgentMana= ger-Handler-14:null) Ping from 3 > 2013-05-13 17:32:27,392 ERROR [cloud.api.ApiServer] (catalina-exec-16:nul= l) unhandled exception executing api command: listVolumes > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mys= ql.jdbc.JDBC4PreparedStatement@441bf055: SELECT volume_view.id, volume_view= .uuid, volume_view.name, volume_view.device_id, volume_view.volume_type, vo= lume_view.size, volume_view.state, volume_view.created, volume_view.attache= d, volume_view.removed, volume_view.account_id, volume_view.account_uuid, v= olume_view.account_name, volume_view.account_type, volume_view.domain_id, v= olume_view.domain_uuid, volume_view.domain_name, volume_view.domain_path, v= olume_view.project_id, volume_view.project_uuid, volume_view.project_name, = volume_view.pod_id, volume_view.data_center_id, volume_view.data_center_uui= d, volume_view.data_center_name, volume_view.data_center_type, volume_view.= vm_id, volume_view.vm_uuid, volume_view.vm_name, volume_view.vm_display_nam= e, volume_view.vm_state, volume_view.vm_type, volume_view.volume_host_size,= volume_view.volume_host_created, volume_view.format, volume_view.download_= pct, volume_view.download_state, volume_view.error_str, volume_view.hypervi= sor_type, volume_view.disk_offering_id, volume_view.disk_offering_uuid, vol= ume_view.disk_offering_name, volume_view.disk_offering_display_text, volume= _view.system_use, volume_view.use_local_storage, volume_view.pool_id, volum= e_view.pool_uuid, volume_view.pool_name, volume_view.template_id, volume_vi= ew.template_uuid, volume_view.extractable, volume_view.template_type, volum= e_view.job_id, volume_view.job_uuid, volume_view.job_status, volume_view.ta= g_id, volume_view.tag_uuid, volume_view.tag_key, volume_view.tag_value, vol= ume_view.tag_domain_id, volume_view.tag_account_id, volume_view.tag_resourc= e_id, volume_view.tag_resource_uuid, volume_view.tag_resource_type, volume_= view.tag_customer FROM volume_view WHERE volume_view.id IN (5,3) > at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(Gener= icDaoBase.java:415) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$= InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:12= 5) > at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(Gener= icDaoBase.java:350) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$= InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:12= 5) > at com.cloud.api.query.dao.VolumeJoinDaoImpl.searchByIds(VolumeJo= inDaoImpl.java:272) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$= InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:12= 5) > at com.cloud.api.query.QueryManagerImpl.searchForVolumesInternal(= QueryManagerImpl.java:1686) > at com.cloud.api.query.QueryManagerImpl.searchForVolumes(QueryMan= agerImpl.java:1550) > at org.apache.cloudstack.api.command.user.volume.ListVolumesCmd.e= xecute(ListVolumesCmd.java:126) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:155) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:519) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:369) > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:304) > 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.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:2268) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolEx= ecutor.java:1110) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolE= xecutor.java:603) > at java.lang.Thread.run(Thread.java:679) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unk= nown column 'volume_view.data_center_type' in 'field list' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native = Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCo= nstructorAccessorImpl.java:57) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Dele= gatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:532= ) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719= ) > at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedState= ment.java:2155) > at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatemen= t.java:2318) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQue= ry(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQue= ry(DelegatingPreparedStatement.java:96) > at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(Gener= icDaoBase.java:409) > ... 42 more > 2013-05-13 17:32:27,395 DEBUG [cloud.api.ApiServlet] (catalina-exec-16:nu= ll) =3D=3D=3DEND=3D=3D=3D 10.217.252.128 -- GET command=3DlistVolumes&res= ponse=3Djson&sessionkey=3DWQ3bR3%2Fa6UDdygOkukpnugfHMuE%3D&listAll=3Dtrue&p= age=3D1&pagesize=3D20&_=3D1368494966167 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrato= rs For more information on JIRA, see: http://www.atlassian.com/software/jira