Fixed in master, commit 6a6d93c3094a55c38f2bdcc736d179ce1e595093 Thanks -min
On 1/31/13 9:19 AM, "Min Chen" <min.c...@citrix.com> wrote: >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" <devdeep.si...@citrix.com> 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.j >>a >>va:410) >> at >>com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34) >> at >>com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.j >>a >>va:345) >> >>Is it a known issue? >> >>Regards, >>Devdeep >> >> >
