Skip to content

Instantly share code, notes, and snippets.

@stuszynski
Last active August 29, 2015 14:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stuszynski/f90a5317492ef9a85fda to your computer and use it in GitHub Desktop.
Save stuszynski/f90a5317492ef9a85fda to your computer and use it in GitHub Desktop.
Missed volume DB records
Postgresql record [missed volume cinder cant see it]:
-[ RECORD 1 ]-------+-------------------------------------
created_at | 2013-10-07 17:04:56.476738
updated_at | 2014-07-18 14:19:07.103334
deleted_at |
deleted | f
id | eba4458f-46ab-496e-a8f2-fef82a903637
ec2_id |
user_id | 11d2446eddfd497fa7e03a75cc9a8d73
project_id | 45e74f11629f4db4a5812a02b1f9967a
host | cc3@cinder_databases
size | 5
availability_zone | nova
instance_uuid |
mountpoint |
attach_time |
status | available
attach_status | detached
scheduled_at | 2013-10-07 17:04:56.512335
launched_at | 2013-10-07 17:04:56.640635
terminated_at |
display_name | xyz
display_description | xyz
provider_location |
provider_auth |
snapshot_id | 4c547a1f-ab0d-439c-92f6-0b365efc4132
volume_type_id | 514485ae-d5a0-4d39-abb6-e7d51c357be0
source_volid |
bootable | f
attached_host |
provider_geometry |
_name_id |
encryption_key_id |
migration_status |
Postgresql record [working one]:
-[ RECORD 1 ]-------+-------------------------------------
created_at | 2014-07-18 14:19:50.785094
updated_at | 2014-07-18 14:19:55.599956
deleted_at |
deleted | f
id | 5bbffc11-fec2-4e66-bb7c-b9d94ac7eb25
ec2_id |
user_id | 11d2446eddfd497fa7e03a75cc9a8d73
project_id | 45e74f11629f4db4a5812a02b1f9967a
host | cc3@cinder_databases
size | 5
availability_zone | nova
instance_uuid | d770511e-a4fc-4ca2-be3a-7237662fac75
mountpoint | /dev/vdc
attach_time | 2014-07-18T14:19:55.214813
status | in-use
attach_status | attached
scheduled_at | 2014-07-18 14:19:51.105193
launched_at | 2014-07-18 14:19:52.004066
terminated_at |
display_name | xyz
display_description | xyz
provider_location |
provider_auth |
snapshot_id | c6bf515a-b9ad-4fdb-8e39-5c7f775a40a7
volume_type_id | 514485ae-d5a0-4d39-abb6-e7d51c357be0
source_volid |
bootable | f
attached_host |
provider_geometry |
_name_id |
encryption_key_id |
migration_status |
History for missed one:
cinder=# select * from volume_admin_metadata where volume_id = 'eba4458f-46ab-496e-a8f2-fef82a903637';
created_at | updated_at | deleted_at | deleted | id | volume_id | key | value
----------------------------+------------+----------------------------+---------+-------+--------------------------------------+---------------+-------
2013-11-04 21:45:48.867427 | | | f | 682 | eba4458f-46ab-496e-a8f2-fef82a903637 | readonly | False
2013-11-04 21:45:48.99072 | | 2013-11-06 15:48:26.345809 | t | 683 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2013-11-06 15:48:57.729621 | | 2013-11-23 18:17:07.999148 | t | 1095 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2013-11-23 18:17:55.61185 | | 2014-03-05 22:19:53.564335 | t | 2026 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2014-03-05 22:20:26.883166 | | 2014-04-11 13:59:56.651075 | t | 6852 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2014-04-11 14:02:25.113262 | | 2014-04-11 14:06:28.746357 | t | 9078 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2014-04-11 14:07:02.616593 | | 2014-06-03 23:38:24.424961 | t | 9123 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2014-06-03 23:44:42.133859 | | 2014-07-13 10:59:58.91951 | t | 12274 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
2014-07-13 11:01:24.997472 | | 2014-07-18 14:19:07.63327 | t | 14115 | eba4458f-46ab-496e-a8f2-fef82a903637 | attached_mode | rw
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment