cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Levitskiy <Sergey.Levits...@autodesk.com>
Subject Re: Fault percentage value of CPU usage in Cloud Platform
Date Sun, 27 Nov 2016 16:16:54 GMT
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` 


Mime
View raw message