incubator-cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Min Chen <min.c...@citrix.com>
Subject Re: ListStoragePools api is broken
Date Thu, 31 Jan 2013 19:57:47 GMT
Fixed in master, commit 6a6d93c3094a55c38f2bdcc736d179ce1e595093

Thanks
-min

On 1/31/13 9:19 AM, "Min Chen" <min.chen@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.singh@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
>>
>>
>


Mime
View raw message