[CLOUDSTACK-9701] When host is disabled/removed, capacity_state for local storage in op_host_capacity is still enabled

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.9.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Sudhansu Sahu
• Reporter: Sudhansu Sahu
• Created: 23/Dec/16 08:04
• Updated: 01/Aug/17 18:40

Description

Setup: Advanced zone with local storage enabled

Description
=========
When a host is disabled or removed, local storage related capacity data for the corresponding local storage of the host is still in enabled state.
This may not directly impact deploy VM functionality (for example) but it does show incorrect capacity calculations.

Steps
=====

1. Enable local storage for zone
2. Disable host or remove host (after adding it to maintenance mode)
3. Check op_host_capacity (capacity_state=9)

In either of the cases, the local storage related capacity is still enabled for the host.

mysql> select id, name, uuid, status,resource_state, type, removed from host where type = 'Routing';
+----+--------------------+--------------------------------------+--------+----------------+---------+---------+
| id | name               | uuid                                 | status | resource_state | type    | removed |
+----+--------------------+--------------------------------------+--------+----------------+---------+---------+
|  1 | xenserver-nvjxksqs | 16a922d0-7b4c-4c84-baad-5bd91542181c | Up     | Disabled       | Routing | NULL    |
|  4 | xenserver-hnkwhblp | 0e0f161a-7cf5-4e44-8bcc-a25ba7d798e5 | Up     | Enabled        | Routing | NULL    |
+----+--------------------+--------------------------------------+--------+----------------+---------+---------+
2 rows in set (0.00 sec)

mysql> select host_id, used_capacity, reserved_capacity, total_capacity, capacity_type, capacity_state from op_host_capacity where capacity_type=9;
+---------+---------------+-------------------+----------------+---------------+----------------+
| host_id | used_capacity | reserved_capacity | total_capacity | capacity_type | capacity_state |
+---------+---------------+-------------------+----------------+---------------+----------------+
|       3 |       4194304 |                 0 |   491505319936 |             9 | Enabled        |
|       4 |       4194304 |                 0 |   491505319936 |             9 | Enabled        |
+---------+---------------+-------------------+----------------+---------------+----------------+
2 rows in set (0.00 sec)

mysql> select id, name, removed, pool_type, capacity_bytes from storage_pool where id in (3,4);
+----+----------------------------------+---------+-----------+----------------+
| id | name                             | removed | pool_type | capacity_bytes |
+----+----------------------------------+---------+-----------+----------------+
|  3 | xenserver-nvjxksqs Local Storage | NULL    | LVM       |   491505319936 |
|  4 | xenserver-hnkwhblp Local Storage | NULL    | LVM       |   491505319936 |
+----+----------------------------------+---------+-----------+----------------+

Issue Links

• links to: GitHub Pull Request #1869