This may be related to my change to use DB view for improving the performance of this api. I will take a look at it today. You can file a bug and assign it to me.
Thanks -min On 1/31/13 8:13 AM, "Devdeep Singh" <[email protected]> wrote: >Hi, > >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.ja >va:410) > at >com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34) > at >com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.ja >va:345) > >Is it a known issue? > >Regards, >Devdeep > >
