cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sangeetha Hariharan (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (CLOUDSTACK-2470) Object_Store_Refactor - Not able to list volumes - DB exception when selecting from volume_view
Date Fri, 12 Jul 2013 18:07:49 GMT

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sangeetha Hariharan closed CLOUDSTACK-2470.
-------------------------------------------


Tested with latest build from 4.2.

listVolume() doees not result in any DB errors.
                
> Object_Store_Refactor - Not able to list volumes - DB exception when selecting from volume_view
> -----------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-2470
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2470
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          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 selecting 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: 
> 2013-05-13 17:34:43,736 INFO  [cloud.api.ApiServer] (catalina-exec-18:null) (userId=2
accountId=2 sessionId=AB8FB9C63498F505DAF5E214
> EEEA3D88) 10.217.252.128 -- GET command=listVolumes&response=json&sessionkey=WQ3bR3%2Fa6UDdygOkukpnugfHMuE%3D&listAll=true&page=1&pa
> gesize=20&_=1368495102545 530 DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@78782188:
SELECT volume_view.id, volume_view.uu
> id, volume_view.name, volume_view.device_id, volume_view.volume_type, volume_view.size,
volume_view.state, volume_view.created, volu
> me_view.attached, volume_view.removed, volume_view.account_id, volume_view.account_uuid,
volume_view.account_name, volume_view.accou
> nt_type, volume_view.domain_id, volume_view.domain_uuid, volume_view.domain_name, volume_view.domain_path,
volume_view.project_id, v
> olume_view.project_uuid, volume_view.project_name, volume_view.pod_id, volume_view.data_center_id,
volume_view.data_center_uuid, vol
> ume_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_name, 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.hypervisor_type, volume_view.disk_
> offering_id, volume_view.disk_offering_uuid, volume_view.disk_offering_name, 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_key, volume_view.tag_value,
volume_view.tag_domain_id, volume
> _view.tag_account_id, volume_view.tag_resource_id, volume_view.tag_resource_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:null) ===START===
 10.217.252.128 -- GET  command=listVolumes&response=json&sessionkey=WQ3bR3%2Fa6UDdygOkukpnugfHMuE%3D&listAll=true&page=1&pagesize=20&_=1368494966167
> 2013-05-13 17:32:27,383 DEBUG [agent.manager.AgentManagerImpl] (AgentManager-Handler-14:null)
Ping from 3
> 2013-05-13 17:32:27,392 ERROR [cloud.api.ApiServer] (catalina-exec-16:null) unhandled
exception executing api command: listVolumes
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@441bf055:
SELECT volume_view.id, volume_view.uuid, volume_view.name, volume_view.device_id, volume_view.volume_type,
volume_view.size, volume_view.state, volume_view.created, volume_view.attached, volume_view.removed,
volume_view.account_id, volume_view.account_uuid, volume_view.account_name, volume_view.account_type,
volume_view.domain_id, volume_view.domain_uuid, volume_view.domain_name, volume_view.domain_path,
volume_view.project_id, volume_view.project_uuid, volume_view.project_name, volume_view.pod_id,
volume_view.data_center_id, volume_view.data_center_uuid, 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_name,
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.hypervisor_type, volume_view.disk_offering_id, volume_view.disk_offering_uuid,
volume_view.disk_offering_name, volume_view.disk_offering_display_text, volume_view.system_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_key, volume_view.tag_value, volume_view.tag_domain_id, volume_view.tag_account_id,
volume_view.tag_resource_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(GenericDaoBase.java:415)
>         at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
>         at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:350)
>         at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
>         at com.cloud.api.query.dao.VolumeJoinDaoImpl.searchByIds(VolumeJoinDaoImpl.java:272)
>         at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
>         at com.cloud.api.query.QueryManagerImpl.searchForVolumesInternal(QueryManagerImpl.java:1686)
>         at com.cloud.api.query.QueryManagerImpl.searchForVolumes(QueryManagerImpl.java:1550)
>         at org.apache.cloudstack.api.command.user.volume.ListVolumesCmd.execute(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.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:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'volume_view.data_center_type' in 'field list'
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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(PreparedStatement.java:2155)
>         at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
>         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>         at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>         at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:409)
>         ... 42 more
> 2013-05-13 17:32:27,395 DEBUG [cloud.api.ApiServlet] (catalina-exec-16:null) ===END===
 10.217.252.128 -- GET  command=listVolumes&response=json&sessionkey=WQ3bR3%2Fa6UDdygOkukpnugfHMuE%3D&listAll=true&page=1&pagesize=20&_=1368494966167

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message