Unable to delete zone , using 4.19.1.

[jack99trade]

delete everything inside zone but still when i try to delete a zone it says

Request failed. (530)
The zone cannot be deleted because there are storage volumes in this zone.

not sure if i am missing something

[DaanHoogland]

I think you must disable the zone and destroy the SVMs (ssvm/cpvm). Then you can destroy the storage for the zone and the zone itself.

[jack99trade]

@rajujith

This is what i see :-

[rajujith]

@jack99trade Could you find the active volumes? If the primary storage host is removed, you may have to undo those changes, but it will be a risky database modification. Otherwise, you can update these volumes as removed, not recommended for production.

mysql> select pool_id,state,count(*) from volumes where removed is null group by pool_id,state;
+---------+-----------+----------+
| pool_id | state     | count(*) |
+---------+-----------+----------+
|       1 | Ready     |        6 |
|       2 | Ready     |        6 |
|    NULL | Allocated |        1 |
+---------+-----------+----------+


mysql> select id,name,state,instance_id,pool_id from volumes where removed is null;
+----+---------+-----------+-------------+---------+
| id | name    | state     | instance_id | pool_id |
+----+---------+-----------+-------------+---------+
|  1 | ROOT-1  | Ready     |           1 |       1 |
|  2 | ROOT-2  | Ready     |           2 |       1 |
|  4 | ROOT-4  | Ready     |           4 |       2 |
|  6 | ROOT-6  | Ready     |           6 |       2 |
|  7 | ROOT-7  | Ready     |           7 |       2 |
|  8 | ROOT-8  | Ready     |           8 |       2 |
|  9 | DATA    | Allocated |        NULL |    NULL |
| 11 | ROOT-10 | Ready     |          10 |       1 |
| 19 | ROOT-18 | Ready     |          18 |       2 |
| 20 | ROOT-19 | Ready     |          19 |       2 |
| 21 | ROOT-21 | Ready     |          21 |       1 |
| 22 | ROOT-23 | Ready     |          23 |       1 |
| 23 | ROOT-25 | Ready     |          25 |       1 |
+----+---------+-----------+-------------+---------+

[jack99trade]

Hi @rajujith . yes primary storage was removed. but its its available for use , i can re-add it

below is the result both both commands:-

mysql> select pool_id,state,count() from volumes where removed is null group by pool_id,state;
+---------+---------+----------+
| pool_id | state | count() |
+---------+---------+----------+
| 1 | Ready | 33 |
| 2 | Destroy | 2 |
| 8 | Ready | 30 |
+---------+---------+----------+
3 rows in set (0.00 sec)

mysql> select id,name,state,instance_id,pool_id from volumes where removed is null;
+------+-----------+---------+-------------+---------+
| id | name | state | instance_id | pool_id |
+------+-----------+---------+-------------+---------+
| 1914 | ROOT-1874 | Ready | 1874 | 8 |
| 1930 | ROOT-1891 | Ready | 1891 | 8 |
| 1937 | ROOT-1898 | Ready | 1898 | 8 |
| 1938 | ROOT-1899 | Ready | 1899 | 8 |
| 1939 | ROOT-1900 | Ready | 1900 | 8 |
| 1940 | ROOT-1901 | Ready | 1901 | 8 |
| 1942 | ROOT-1903 | Ready | 1903 | 8 |
| 1944 | ROOT-1905 | Ready | 1905 | 8 |
| 1945 | ROOT-1906 | Ready | 1906 | 8 |
| 1959 | ROOT-1919 | Ready | 1919 | 8 |
| 1975 | ROOT-1902 | Ready | 1902 | 8 |
| 1976 | ROOT-1904 | Ready | 1904 | 8 |
| 1979 | DATA-1935 | Ready | NULL | 8 |
| 1983 | ROOT-1945 | Ready | 1945 | 8 |
| 1984 | ROOT-1946 | Ready | 1946 | 8 |
| 1985 | ROOT-1947 | Ready | 1947 | 8 |
| 1986 | ROOT-1948 | Ready | 1948 | 8 |
| 1987 | ROOT-1949 | Ready | 1949 | 8 |
| 1988 | ROOT-1950 | Ready | 1950 | 8 |
| 1989 | ROOT-1951 | Ready | 1951 | 8 |
| 1990 | ROOT-1952 | Ready | 1952 | 8 |
| 2001 | DATA-1962 | Ready | NULL | 8 |
| 2002 | ROOT-1963 | Ready | 1963 | 8 |
| 2003 | ROOT-1964 | Ready | 1964 | 8 |
| 2004 | DATA-1964 | Ready | 1964 | 8 |
| 2009 | DATA-1968 | Ready | NULL | 8 |
| 2015 | DATA-1971 | Ready | NULL | 8 |
| 2017 | DATA-1972 | Ready | NULL | 8 |
| 2018 | ROOT-1973 | Ready | 1973 | 8 |
| 2019 | DATA-1973 | Ready | 1973 | 8 |
| 2025 | DATA-1976 | Ready | NULL | 1 |
| 2077 | ROOT-2014 | Ready | 2014 | 1 |
| 2137 | ROOT-2055 | Ready | 2055 | 1 |
| 2140 | ROOT-2058 | Ready | 2058 | 1 |
| 2141 | ROOT-2059 | Ready | 2059 | 1 |
| 2142 | ROOT-2060 | Ready | 2060 | 1 |
| 2150 | ROOT-2068 | Ready | 2068 | 1 |
| 2151 | DATA-2068 | Ready | 2068 | 1 |
| 2153 | ROOT-2045 | Ready | 2045 | 1 |
| 2154 | ROOT-2070 | Ready | 2070 | 1 |
| 2157 | ROOT-2072 | Ready | 2072 | 1 |
| 2158 | DATA-2072 | Ready | 2072 | 1 |
| 2159 | ROOT-2073 | Ready | 2073 | 1 |
| 2160 | DATA-2073 | Ready | 2073 | 1 |
| 2161 | ROOT-2074 | Ready | 2074 | 1 |
| 2162 | ROOT-2075 | Ready | 2075 | 1 |
| 2163 | ROOT-2076 | Ready | 2076 | 1 |
| 2164 | DATA-2076 | Ready | 2076 | 1 |
| 2168 | ROOT-2082 | Ready | 2082 | 1 |
| 2174 | ROOT-2088 | Destroy | 2088 | 2 |
| 2175 | ROOT-2089 | Destroy | 2089 | 2 |
| 2177 | ROOT-2094 | Ready | 2094 | 1 |
| 2180 | ROOT-2096 | Ready | 2096 | 1 |
| 2181 | DATA-2096 | Ready | 2096 | 1 |
| 2183 | ROOT-2098 | Ready | 2098 | 1 |
| 2185 | ROOT-2100 | Ready | 2100 | 1 |
| 2190 | ROOT-2105 | Ready | 2105 | 1 |
| 2195 | ROOT-2108 | Ready | 2108 | 1 |
| 2200 | ROOT-2114 | Ready | 2114 | 1 |
| 2201 | DATA-2114 | Ready | 2114 | 1 |
| 2204 | ROOT-2117 | Ready | 2117 | 1 |
| 2216 | ROOT-2129 | Ready | 2129 | 1 |
| 2217 | ROOT-2130 | Ready | 2130 | 1 |
| 2221 | ROOT-2134 | Ready | 2134 | 1 |
| 2222 | ROOT-2135 | Ready | 2135 | 1 |
+------+-----------+---------+-------------+---------+
65 rows in set (0.00 sec)

[jack99trade]

Hi @rajujith , I have deleted the zone now: by modifying below entries :-

+------+-----------+----------+---------------------+
| id | name | state | removed |
+------+-----------+----------+---------------------+
| 2174 | ROOT-2088 | Expunged | 2025-06-06 11:21:30 |
| 2175 | ROOT-2089 | Expunged | 2025-06-06 11:21:30 |
+------+-----------+----------+---------------------+