Kiran Koneti created CLOUDSTACK-3073: ----------------------------------------
Summary: op_host_planner_reservation table shows host as shared whose Zone is dedicated to an Account. Key: CLOUDSTACK-3073 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3073 Project: CloudStack Issue Type: Bug Security Level: Public (Anyone can view this level - this is the default.) Components: Install and Setup Affects Versions: 4.2.0 Reporter: Kiran Koneti Priority: Critical Fix For: 4.2.0 Followed the Below steps: 1)Created a advanced zone setup. 2)dedicated the Zone to an account(say kiran1 from domain Kiran). 3)Then created service offerings for strict implicit dedication and preferred implicit dedication. 4)Now from the account kiran2 in the same domain I tried to create VM using the strict implicit and preferred implicit dedication. 5)VM creation with the strict implicit failed but the creation with Preferred got succeeded. 6)When dug into deeper investigation observed that the host which is dedicated to the account (actually dedicated the Zone) is not updated as dedicated host in the "op_host_planner_reservation" table. The DB tables are as below: mysql> select * from op_host_planner_reservation; +----+----------------+--------+------------+---------+----------------+ | id | data_center_id | pod_id | cluster_id | host_id | resource_usage | +----+----------------+--------+------------+---------+----------------+ | 1 | 1 | 1 | 1 | 1 | Shared | +----+----------------+--------+------------+---------+----------------+ 1 row in set (0.00 sec) mysql> select * from dedicated_resources; +----+--------------------------------------+----------------+--------+------------+---------+-----------+------------+ | id | uuid | data_center_id | pod_id | cluster_id | host_id | domain_id | account_id | +----+--------------------------------------+----------------+--------+------------+---------+-----------+------------+ | 6 | 73cfd7c6-3653-4960-89ca-50ee3b7e47ee | 1 | NULL | NULL | NULL | 2 | 3 | +----+--------------------------------------+----------------+--------+------------+---------+-----------+------------+ 1 row in set (0.00 sec) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira