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 E256411CA1 for ; Tue, 24 Jun 2014 09:04:25 +0000 (UTC) Received: (qmail 66407 invoked by uid 500); 24 Jun 2014 09:04:25 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 66384 invoked by uid 500); 24 Jun 2014 09:04:25 -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 66249 invoked by uid 500); 24 Jun 2014 09:04:25 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 66213 invoked by uid 99); 24 Jun 2014 09:04:25 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jun 2014 09:04:25 +0000 Date: Tue, 24 Jun 2014 09:04:25 +0000 (UTC) From: "Rajani Karuturi (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CLOUDSTACK-6986) unable to list volumes due to a mysql exception MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Rajani Karuturi created CLOUDSTACK-6986: ------------------------------------------- Summary: unable to list volumes due to a mysql exception Key: CLOUDSTACK-6986 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6986 Project: CloudStack Issue Type: Bug Security Level: Public (Anyone can view this level - this is the defa= ult.) Affects Versions: 4.5.0 Reporter: Rajani Karuturi Priority: Blocker It is on the current master which is 4.5.0 stack trace: ERROR [c.c.a.ApiServer] (1529851223@qtp-2083826009-12:ctx-d13811d7 ctx-82c7= 5a55) unhandled exception executing api command: [Ljava.lang.String;@754ce4= 7d com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql= .jdbc.JDBC4PreparedStatement@3c0ee2d0: SELECT volume_view.id, volume_view.u= uid, volume_view.name, volume_view.device_id, volume_view.volume_type, volu= me_view.provisioning_type, volume_view.size, volume_view.min_iops, volume_v= iew.max_iops, volume_view.state, volume_view.created, volume_view.attached,= volume_view.removed, volume_view.account_id, volume_view.account_uuid, vol= ume_view.account_name, volume_view.account_type, volume_view.domain_id, vol= ume_view.domain_uuid, volume_view.domain_name, volume_view.domain_path, vol= ume_view.project_id, volume_view.project_uuid, volume_view.project_name, vo= lume_view.pod_id, volume_view.data_center_id, volume_view.data_center_uuid,= volume_view.data_center_name, volume_view.vm_id, volume_view.vm_uuid, volu= me_view.vm_name, volume_view.vm_display_name, volume_view.vm_state, volume_= view.vm_type, volume_view.volume_store_size, volume_view.created_on_store, = volume_view.format, volume_view.download_pct, volume_view.download_state, v= olume_view.error_str, volume_view.hypervisor_type, volume_view.disk_offerin= g_id, volume_view.disk_offering_uuid, volume_view.disk_offering_name, volum= e_view.disk_offering_display_text, volume_view.system_use, volume_view.use_= local_storage, volume_view.bytes_read_rate, volume_view.bytes_write_rate, v= olume_view.iops_read_rate, volume_view.iops_write_rate, volume_view.pool_id= , volume_view.pool_uuid, volume_view.pool_name, volume_view.template_id, vo= lume_view.template_uuid, volume_view.template_name, volume_view.template_di= splay_text, volume_view.extractable, volume_view.template_type, volume_view= .iso_id, volume_view.iso_uuid, volume_view.iso_name, volume_view.iso_displa= y_text, volume_view.job_id, volume_view.job_uuid, volume_view.job_status, v= olume_view.tag_id, volume_view.tag_uuid, volume_view.tag_key, volume_view.t= ag_value, volume_view.tag_domain_id, volume_view.tag_account_id, volume_vie= w.tag_resource_id, volume_view.tag_resource_uuid, volume_view.tag_resource_= type, volume_view.tag_customer, volume_view.display_volume, volume_view.pat= h, volume_view.chain_info FROM volume_view WHERE volume_view.id=3D6 =09at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBa= se.java:425) =09at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBa= se.java:361) =09at com.cloud.api.query.dao.VolumeJoinDaoImpl.searchByIds(VolumeJoinDaoIm= pl.java:301) =09at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) =09at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.= java:57) =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces= sorImpl.java:43) =09at java.lang.reflect.Method.invoke(Method.java:606) =09at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti= on(AopUtils.java:317) =09at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo= inpoint(ReflectiveMethodInvocation.java:183) =09at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(= ReflectiveMethodInvocation.java:150) =09at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionCo= ntextInterceptor.java:34) =09at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(= ReflectiveMethodInvocation.java:161) =09at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok= e(ExposeInvocationInterceptor.java:91) =09at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(= ReflectiveMethodInvocation.java:172) =09at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami= cAopProxy.java:204) =09at com.sun.proxy.$Proxy267.searchByIds(Unknown Source) =09at com.cloud.api.query.QueryManagerImpl.searchForVolumesInternal(QueryMa= nagerImpl.java:1804) =09at com.cloud.api.query.QueryManagerImpl.searchForVolumes(QueryManagerImp= l.java:1626) =09at org.apache.cloudstack.api.command.user.volume.ListVolumesCmd.execute(= ListVolumesCmd.java:152) =09at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:141) =09at com.cloud.api.ApiServer.queueCommand(ApiServer.java:689) =09at com.cloud.api.ApiServer.handleRequest(ApiServer.java:512) =09at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:317) =09at com.cloud.api.ApiServlet$1.run(ApiServlet.java:118) =09at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.ca= ll(DefaultManagedContext.java:56) =09at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.call= WithContext(DefaultManagedContext.java:103) =09at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runW= ithContext(DefaultManagedContext.java:53) =09at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:115) =09at com.cloud.api.ApiServlet.doGet(ApiServlet.java:77) =09at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) =09at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) =09at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511= ) =09at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:4= 01) =09at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav= a:216) =09at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1= 82) =09at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7= 66) =09at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) =09at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand= lerCollection.java:230) =09at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.= java:114) =09at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1= 52) =09at org.mortbay.jetty.Server.handle(Server.java:326) =09at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54= 2) =09at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo= nnection.java:928) =09at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) =09at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) =09at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) =09at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja= va:410) =09at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j= ava:582) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unkno= wn column 'volume_view.template_name' in 'field list' =09at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) =09at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct= orAccessorImpl.java:57) =09at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC= onstructorAccessorImpl.java:45) =09at java.lang.reflect.Constructor.newInstance(Constructor.java:526) =09at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) =09at com.mysql.jdbc.Util.getInstance(Util.java:386) =09at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) =09at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) =09at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) =09at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) =09at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) =09at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) =09at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja= va:2155) =09at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:= 2318) =09at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele= gatingPreparedStatement.java:96) =09at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele= gatingPreparedStatement.java:96) =09at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBa= se.java:419) =09... 47 more api response" -- This message was sent by Atlassian JIRA (v6.2#6252)