Ask Your Question
1

Is it possible to list deleted volumes?

asked 2015-09-16 13:13:20 -0600

Jeff Jing gravatar image

I would like to list the deleted volumes, and it seems "status=deleted" not working in query parameter. APIs list only active volumes. Is there a way to do so? the deleted volumes are recorded in db.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
4

answered 2015-09-18 03:01:51 -0600

nd gravatar image

Hi Jeff,

You can find it in database. If you have either database admin (root user) access you can do the following:

  1. Login to database on your database server

    mysql -u root -p password:

  2. connect to cinder database

    mysql> use cinder;

  3. Run the below query which shows status of all volumes with info whether they are deleted

    mysql> select display_name,deleted,deleted_at from volumes;

  4. Or run below query to display only deleted volumes

    mysql> select display_name,deleted,deleted_at from volumes where deleted='1' ;

  5. If you want to also see other fields - you can check the column names for volumes table with

    mysql> desc volumes;

  6. Logout from database login

    mysql> quit

HTH.

edit flag offensive delete link more

Comments

1

I know how to get deleted volumes from db, and I asked how to get them from APIs. I can get the deleted VMs via APIs.

Thanks for your reply.

Jeff Jing gravatar imageJeff Jing ( 2015-09-18 09:20:16 -0600 )edit

Hi Jeff,

Did you manage to get the list of deleted volumes? I'm coding an openstack dashboard and that is one of the things I would need.

Cheers, David

docana gravatar imagedocana ( 2015-12-07 10:16:39 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

2 followers

Stats

Asked: 2015-09-16 13:13:20 -0600

Seen: 433 times

Last updated: Sep 18 '15