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


Reply via email to