GitHub user jack99trade added a comment to the discussion: Unable to delete zone , using 4.19.1.
Hi @rajujith . 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) GitHub link: https://github.com/apache/cloudstack/discussions/10958#discussioncomment-13386213 ---- This is an automatically sent email for users@cloudstack.apache.org. To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
