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