Prasanna Santhanam created CLOUDSTACK-1123:
----------------------------------------------
Summary: ListStoragePools API broken by refactor
Key: CLOUDSTACK-1123
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1123
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: API
Affects Versions: 4.1.0
Reporter: Prasanna Santhanam
Assignee: Min Chen
Fix For: 4.1.0
From: Devdeep Singh <devdeep.si...@citrix.com>
To: "cloudstack-dev@incubator.apache.org"
<cloudstack-dev@incubator.apache.org>
Date: Thu, 31 Jan 2013 21:43:47 +0530
I observed that the lisStoragePools api is broken if it is called with a
parameter. E.g if called with the zoneid parameter it fails with the following
exception
ERROR [cloud.api.ApiServer] (ApiServer-4:) unhandled exception executing api
command: listStoragePools
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
com.mysql.jdbc.JDBC4PreparedStatement@3f135a: SELECT
DISTINCT(storage_pool_view.id) FROM storage_pool_view WHERE
storage_pool_view.cluster_id = ** STREAM DATA ** AND storage_pool_view.removed
IS NULL ORDER BY storage_pool_view.id ASC LIMIT 0, 500
at
com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:410)
at
com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34)
at
com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:345)
--
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
