use cinder;
update volumes set deleted=1,status='deleted', deleted_at=now(), updated_at=now() where id='763e8a16-8b4b-4114-811c-d244a08ac44a';
use nova;
select * from block_device_mapping where volume_id='763e8a16-8b4b-4114-811c-d244a08ac44a';
update block_device_mapping set deleted_at=now(), updated_at=now(),deleted='1' where volume_id='763e8a16-8b4b-4114-811c-d244a08ac44a';
