Skip to content

Instantly share code, notes, and snippets.

@delfer

delfer/detach_cinder_mysql.sql

Created October 9, 2017 12:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save delfer/17fb019625408300bc34f8e6a595f0c3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save delfer/17fb019625408300bc34f8e6a595f0c3 to your computer and use it in GitHub Desktop.
Download ZIP
Set a volume as detached in Cinder
Raw
detach_cinder_mysql.sql
-- https://raymii.org/s/articles/Fix_inconsistent_Openstack_volumes_and_instances_from_Cinder_and_Nova_via_the_database.html#Set_a_volume_as_detached_in_Cinder
-- $ mysql cinder_db
update cinder.volumes set attach_status='detached',status='available' where id ='$volume_uuid';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment