I think this is a bug when apply.allocation.algorithm.to.pods is to true. As a workaround set apply.allocation.algorithm.to.pods to false and restart the management servers. After that you should be able to create instances.
-Prashanth -----Original Message----- From: Gaspare A. Silvestri [mailto:[email protected]] Sent: Friday, October 25, 2013 2:09 PM To: [email protected] Subject: CS 4.2 -- DB problems after params update Hello everybody, after I've updated the max size global settings in the Cloudstack UI, I receive the following error when I try to create an instance: " DB Exception on: SELECT DISTINCT capacity.pod_id FROM `cloud`.`op_host_capacity` capacity INNER JOIN `cloud`.`host_pod_ref` pod ON (pod.id = capacity.pod_id AND pod.removed is NULL) INNER JOIN `cloud`.`cluster_details` cluster ON (capacity.cluster_id = cluster.cluster_id ) WHERE capacity.data_center_id = ? AND capacity_type = ? AND cluster_details.name= ? ((total_capacity * cluster.value ) - used_capacity + reserved_capacity) >= ? AND capacity.pod_id IN (SELECT DISTINCT capacity.pod_id FROM `cloud`.`op_host_capacity` capacity INNER JOIN `cloud`.`host_pod_ref` pod ON (pod.id = capacity.pod_id AND pod.removed is NULL) INNER JOIN `cloud`.`cluster_details` cluster ON (capacity.cluster_id = cluster.cluster_id ) WHERE capacity.data_center_id = ? AND capacity_type = ? AND cluster_details.name= ? ((total_capacity * cluster.value ) - used_capacity + reserved_capacity) >= ? )" I'm using the 4.2 version. Could you please help me? Thanks in advance Gaspare
