Troubleshooting: Volumes stuck at deleting

If a volume is stuck at a deleting state, we can manually delete is from the mariadb database with the following query:

MariaDB [cinder]> update volumes set deleted=1,status='deleted',deleted_at=now(),updated_at=now() where deleted=0 and id='$volume_uuid'