OpenStack: How to fix a drive stuck on deleting.

If you get a drive that won't delete and gets stuck on Error Deleting while blocking all other scheduling. You can fix it by doing the following:

1. Grab the name/uuid of the disk with the issue: ( in this case I have fixed the issue so the error is gone)
   

2 .ssh into your host or controller.

3 .Log into your root account for most people sudo su stack

4. Log into mysql:

$mysql

5. Run the following, where id=<uuid/name from step 1>

mysql> update volumes set 
deleted=1,status='deleted',deleted_at=now(),updated_at=now() where 
deleted=0 and id='c99bd261-c679-4fd3-b26b-6cc943415e54';

You should get an output as follows:

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0