First of all, if you don’t have support for CCP you need to strongly consider
migrating to ACP. This community doesn’t have access to CCP code so we have
very limited way to assist you.
In any case looking at the log you provided it seems you have 2 cluster: one
(cluster id =5) that crossed your allocation threshold for capacity CPU. The
other cluster (id=1) simply has no host matching host tag of your service
offering (“WinL”) so that cluster can’t be allocated either.
Can you execute this SQL query and post results back:
SELECT
`c`.`uuid` AS `cluster_uuid`,
`c`.`id` AS `cluster_id`,
`c`.`name` AS `cluster_name`,
`d`.`uuid` AS `zone_uuid`,
`d`.`name` AS `zone_name`,
IF((`capacity`.`capacity_type` = 1),
'cpu',
'ram') AS `type`,
((SUM(`capacity`.`used_capacity`) +
SUM(`capacity`.`reserved_capacity`)) + 0) AS `used_capacity`,
SUM((`capacity`.`total_capacity` * `overcommit`.`value`)) AS
`total_capacity`,
FORMAT((((SUM(`capacity`.`used_capacity`) +
SUM(`capacity`.`reserved_capacity`)) + 0) / SUM((`capacity`.`total_capacity` *
`overcommit`.`value`))),
2) AS `utilization`,
(CASE (SELECT
COUNT(0)
FROM
`cluster_details` `details`
WHERE
((`details`.`cluster_id` = `capacity`.`cluster_id`)
AND (`details`.`name` =
'cluster.cpu.allocated.capacity.disablethreshold')))
WHEN
1
THEN
(CASE
WHEN
ISNULL((SELECT
`details`.`value`
FROM
`cluster_details` `details`
WHERE
((`details`.`cluster_id` =
`capacity`.`cluster_id`)
AND (`details`.`name` =
'cluster.cpu.allocated.capacity.disablethreshold'))))
THEN
(SELECT
`config`.`value`
FROM
`configuration` `config`
WHERE
(`config`.`name` =
'cluster.cpu.allocated.capacity.disablethreshold'))
ELSE (SELECT
`details`.`value`
FROM
`cluster_details` `details`
WHERE
((`details`.`cluster_id` = `capacity`.`cluster_id`)
AND (`details`.`name` =
'cluster.cpu.allocated.capacity.disablethreshold')))
END)
ELSE (SELECT
`config`.`value`
FROM
`configuration` `config`
WHERE
(`config`.`name` =
'cluster.cpu.allocated.capacity.disablethreshold'))
END) AS `threshold`,
(CASE (SELECT
COUNT(0)
FROM
`cluster_details` `details`
WHERE
((`details`.`cluster_id` = `capacity`.`cluster_id`)
AND (`details`.`name` = 'cpuOvercommitRatio')))
WHEN
1
THEN
(CASE
WHEN
ISNULL((SELECT
`details`.`value`
FROM
`cluster_details` `details`
WHERE
((`details`.`cluster_id` =
`capacity`.`cluster_id`)
AND (`details`.`name` =
'cpuOvercommitRatio'))))
THEN
(SELECT
`config`.`value`
FROM
`configuration` `config`
WHERE
(`config`.`name` = 'cpuOvercommitRatio'))
ELSE (SELECT
`details`.`value`
FROM
`cluster_details` `details`
WHERE
((`details`.`cluster_id` = `capacity`.`cluster_id`)
AND (`details`.`name` = 'cpuOvercommitRatio')))
END)
ELSE (SELECT
`config`.`value`
FROM
`configuration` `config`
WHERE
(`config`.`name` = 'cpuOvercommitRatio'))
END) AS `overprovisioning`
FROM
((((`op_host_capacity` `capacity`
JOIN `cluster_details` `overcommit` ON ((`overcommit`.`cluster_id` =
`capacity`.`cluster_id`)))
JOIN `cluster` `c` ON ((`c`.`id` = `overcommit`.`cluster_id`)))
JOIN `host` `h` ON (((`h`.`id` = `capacity`.`host_id`)
AND ISNULL(`h`.`removed`))))
JOIN `data_center` `d` ON ((`c`.`data_center_id` = `d`.`id`)))
WHERE
((`capacity`.`capacity_type` = 1)
AND (`capacity`.`total_capacity` > 0)
AND (`capacity`.`capacity_state` = 'Enabled')
AND (`overcommit`.`name` = 'cpuOvercommitRatio'))
GROUP BY `c`.`id`
