[CLOUDSTACK-1123] ListStoragePools API broken by refactor

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0
• Fix Version/s: 4.1.0
• Component/s: API
• Security Level: Public (Anyone can view this level - this is the default.)
• Labels: integration-test
• Assignee: Prasanna
• Reporter: Prasanna
• Created: 01/Feb/13 06:00
• Updated: 04/Jun/13 18:49
• Resolved: 01/Feb/13 06:00

Description

From: Devdeep Singh <[e-mail]>
To: "[e-mail]"
<[e-mail]>
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)