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.java:410)
at
com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34)
at
com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:345)
Is it a known issue?
Regards,
Devdeep