I have a volume that I discovered is no long taking snapshots. It appears that
there are a lot of snapshots in the vdi tree for this vm that have not been
cleaned up. The CS database says that there should only be 1 snapshot for the
volume, but XenServer tells a much different story. How can I get rid of these
snapshots without damaging the VDI tree?
I apologize for the heavy text that follows.
mysql> select * from volumes where id = 4128;
+------+------------+-----------+---------+-------------+-----------+-----------+--------------+-----------------------------------------------------------------+--------------------------------------+--------+----------------+------------+---------+-------------+-----------+------------------+-------------+----------------------------+-------------+---------------------+---------+---------+----------+------------+-------+------+--------------+--------------+
| id | account_id | domain_id | pool_id | instance_id | device_id | name
| size | folder
| path | pod_id | data_center_id | iscsi_name
| host_ip | volume_type | pool_type | disk_offering_id | template_id |
first_snapshot_backup_uuid | recreatable | created | updated |
removed | attached | chain_info | state | uuid | last_pool_id | update_count |
+------+------------+-----------+---------+-------------+-----------+-----------+--------------+-----------------------------------------------------------------+--------------------------------------+--------+----------------+------------+---------+-------------+-----------+------------------+-------------+----------------------------+-------------+---------------------+---------+---------+----------+------------+-------+------+--------------+--------------+
| 4128 | 53 | 1 | 281 | 3818 | 1 | DATA-3818
| 107374182400 |
/iqn.1986-03.com.sun:02:dee7a788-1e36-42a4-f045-e84f5290263f/21 |
606b1bfe-e884-4a60-ac9b-abf2066fcafe | 2 | 2 | NULL |
NULL | DATADISK | IscsiLUN | 74 | NULL | NULL
| 0 | 2012-02-24 17:08:33 | NULL | NULL | NULL
| NULL | Ready | NULL | 281 | 0 |
+------+------------+-----------+---------+-------------+-----------+-----------+--------------+-----------------------------------------------------------------+--------------------------------------+--------+----------------+------------+---------+-------------+-----------+------------------+-------------+----------------------------+-------------+---------------------+---------+---------+----------+------------+-------+------+--------------+--------------+
1 row in set (0.00 sec)
mysql> select * from snapshots where volume_id = 4128 and removed is null;
+-------+------------+-----------+----------+--------------------------------------+---------------------------------------+---------------+------------------+---------------------+---------+--------------------------------------+--------------+----------------+-----------+------------------+--------------+---------+-----------------+----------+------------+------+
| id | account_id | volume_id | status | path
| name | snapshot_type | type_description |
created | removed | backup_snap_id |
prev_snap_id | data_center_id | domain_id | disk_offering_id | size |
version | hypervisor_type | swift_id | sechost_id | uuid |
+-------+------------+-----------+----------+--------------------------------------+---------------------------------------+---------------+------------------+---------------------+---------+--------------------------------------+--------------+----------------+-----------+------------------+--------------+---------+-----------------+----------+------------+------+
| 31963 | 53 | 4128 | BackedUp |
d411e048-d8ca-4419-a84e-a54262f09d9a | i-53-3818-VM_DATA-3818_20121227060445 |
4 | DAILY | 2012-12-27 06:04:45 | NULL |
6764c0e6-e382-48b9-b5c5-ab93b5799f2d | 31898 | 2 |
1 | 74 | 107374182400 | 2.2 | XenServer | 0 |
10 | NULL |
+-------+------------+-----------+----------+--------------------------------------+---------------------------------------+---------------+------------------+---------------------+---------+--------------------------------------+--------------+----------------+-----------+------------------+--------------+---------+-----------------+----------+------------+------+
1 row in set (0.00 sec)
vhd=VHD-24833850-b490-4a36-959a-57a6176a3744 capacity=107374182400
size=67578626048 hidden=1 parent=none
vhd=VHD-d411e048-d8ca-4419-a84e-a54262f09d9a capacity=107374182400
size=8388608 hidden=0 parent=VHD-24833850-b490-4a36-959a-57a6176a3744
vhd=VHD-57a4f262-58c8-4b35-beac-b73a1acf14d1 capacity=107374182400
size=23970447360 hidden=1 parent=VHD-24833850-b490-4a36-959a-57a6176a3744
vhd=VHD-cbc62118-4765-4691-adbd-3c5a88bd5748 capacity=107374182400
size=8388608 hidden=0 parent=VHD-57a4f262-58c8-4b35-beac-b73a1acf14d1
vhd=VHD-f914dfd8-a53b-41b6-80e5-acf8cbc479f7 capacity=107374182400
size=24222105600 hidden=1 parent=VHD-57a4f262-58c8-4b35-beac-b73a1acf14d1
vhd=VHD-b03ebfac-9e0a-429c-8677-5495fb55fe94 capacity=107374182400
size=8388608 hidden=0 parent=VHD-f914dfd8-a53b-41b6-80e5-acf8cbc479f7
vhd=VHD-319abb67-5583-4837-bb7f-94b1def7c268 capacity=107374182400
size=21709717504 hidden=1 parent=VHD-f914dfd8-a53b-41b6-80e5-acf8cbc479f7
vhd=VHD-3b52130f-4b57-4d42-8634-e7ea604e70a7 capacity=107374182400
size=8388608 hidden=0 parent=VHD-319abb67-5583-4837-bb7f-94b1def7c268
vhd=VHD-cbe65966-86ed-44ec-9f0b-e9708184bad8 capacity=107374182400
size=21562916864 hidden=1 parent=VHD-319abb67-5583-4837-bb7f-94b1def7c268
vhd=VHD-23f178c2-1e17-49d0-82cb-83f3bf41b85a
capacity=107374182400 size=8388608 hidden=0
parent=VHD-cbe65966-86ed-44ec-9f0b-e9708184bad8
vhd=VHD-7cf30f57-01bc-4f47-b96e-59466b1adf19
capacity=107374182400 size=23471325184 hidden=1
parent=VHD-cbe65966-86ed-44ec-9f0b-e9708184bad8
vhd=VHD-75ef3e23-c479-46d5-9e30-b4830bb71514
capacity=107374182400 size=8388608 hidden=0
parent=VHD-7cf30f57-01bc-4f47-b96e-59466b1adf19
vhd=VHD-f823d36f-36fe-49d8-9f8d-46b859a98f94
capacity=107374182400 size=21814575104 hidden=1
parent=VHD-7cf30f57-01bc-4f47-b96e-59466b1adf19
vhd=VHD-6874c61d-b809-4b71-b062-3248d3689aec
capacity=107374182400 size=8388608 hidden=0
parent=VHD-f823d36f-36fe-49d8-9f8d-46b859a98f94
vhd=VHD-b3b68fdb-85d3-4cfe-8d06-3130ef93dfcc
capacity=107374182400 size=24893194240 hidden=1
parent=VHD-f823d36f-36fe-49d8-9f8d-46b859a98f94
vhd=VHD-5b231146-0fca-4f68-a208-d6dea377473a
capacity=107374182400 size=8388608 hidden=0
parent=VHD-b3b68fdb-85d3-4cfe-8d06-3130ef93dfcc
vhd=VHD-d9dbc2f9-1950-40c7-972e-d6574e47e501
capacity=107374182400 size=24704450560 hidden=1
parent=VHD-b3b68fdb-85d3-4cfe-8d06-3130ef93dfcc
vhd=VHD-2ed27c97-cd70-4462-a2dd-3d0af3abbbdf
capacity=107374182400 size=8388608 hidden=0
parent=VHD-d9dbc2f9-1950-40c7-972e-d6574e47e501
vhd=VHD-fd9a327e-de6c-4abc-b217-48e0ceed03c4
capacity=107374182400 size=23597154304 hidden=1
parent=VHD-d9dbc2f9-1950-40c7-972e-d6574e47e501
vhd=VHD-fd648003-5d69-4d33-a006-85add9ee2f63
capacity=107374182400 size=8388608 hidden=0
parent=VHD-fd9a327e-de6c-4abc-b217-48e0ceed03c4
vhd=VHD-1e93bf9b-d90c-420a-aa49-6a561292cf58
capacity=107374182400 size=17754488832 hidden=1
parent=VHD-fd9a327e-de6c-4abc-b217-48e0ceed03c4
vhd=VHD-10762f8b-5c99-458c-9a39-4ba6013ba8a6
capacity=107374182400 size=8388608 hidden=0
parent=VHD-1e93bf9b-d90c-420a-aa49-6a561292cf58
vhd=VHD-37c3feec-2f05-49ca-b016-a4c3c37c40d2
capacity=107374182400 size=16793993216 hidden=1
parent=VHD-1e93bf9b-d90c-420a-aa49-6a561292cf58
vhd=VHD-6bb8e002-fae9-4b13-83a4-07a4e76d443c capacity=107374182400 size=8388608
hidden=0 parent=VHD-37c3feec-2f05-49ca-b016-a4c3c37c40d2
vhd=VHD-0c70af25-8f85-4b25-80fe-2e10ab36d448 capacity=107374182400
size=23240638464 hidden=1 parent=VHD-37c3feec-2f05-49ca-b016-a4c3c37c40d2
vhd=VHD-886a9e91-e06f-48c1-a0b3-755df54af08b capacity=107374182400 size=8388608
hidden=0 parent=VHD-0c70af25-8f85-4b25-80fe-2e10ab36d448
vhd=VHD-eca035fc-9532-4d63-8073-055c579a754b capacity=107374182400
size=19100860416 hidden=1 parent=VHD-0c70af25-8f85-4b25-80fe-2e10ab36d448
vhd=VHD-c5d0ed54-4f68-4554-b568-b75f07599f39 capacity=107374182400 size=8388608
hidden=0 parent=VHD-eca035fc-9532-4d63-8073-055c579a754b
vhd=VHD-f6c6e1b9-d7f9-41dc-8c1b-ff722d0b4e5f capacity=107374182400
size=23005757440 hidden=1 parent=VHD-eca035fc-9532-4d63-8073-055c579a754b
vhd=VHD-21b1d377-9672-4516-b343-14314d84aa75 capacity=107374182400 size=8388608
hidden=0 parent=VHD-f6c6e1b9-d7f9-41dc-8c1b-ff722d0b4e5f
vhd=VHD-7ea810e7-39cb-4b43-bae0-89d68cd783f4 capacity=107374182400
size=19696451584 hidden=1 parent=VHD-f6c6e1b9-d7f9-41dc-8c1b-ff722d0b4e5f
vhd=VHD-f162cd9c-655f-4486-b0d3-0130d587d4dd capacity=107374182400 size=8388608
hidden=0 parent=VHD-7ea810e7-39cb-4b43-bae0-89d68cd783f4
vhd=VHD-9bd354ba-5365-40cd-88f9-092bbe77e03e capacity=107374182400
size=28382855168 hidden=1 parent=VHD-7ea810e7-39cb-4b43-bae0-89d68cd783f4
vhd=VHD-671b1904-d876-47b4-8dea-4f96122bb524 capacity=107374182400 size=8388608
hidden=0 parent=VHD-9bd354ba-5365-40cd-88f9-092bbe77e03e
vhd=VHD-e877b4d8-5699-4268-a8dc-c470c4e597f2 capacity=107374182400
size=39896219648 hidden=1 parent=VHD-9bd354ba-5365-40cd-88f9-092bbe77e03e
vhd=VHD-cbb1e04d-1955-4bbd-9ffa-c0027f292881 capacity=107374182400 size=8388608
hidden=0 parent=VHD-e877b4d8-5699-4268-a8dc-c470c4e597f2
vhd=VHD-c45edea9-a22c-4e83-8aa4-9bac223f7413 capacity=107374182400
size=15397289984 hidden=1 parent=VHD-e877b4d8-5699-4268-a8dc-c470c4e597f2
vhd=VHD-8144b5cd-dea5-43ac-a21f-b8c6e911edb8 capacity=107374182400 size=8388608
hidden=0 parent=VHD-c45edea9-a22c-4e83-8aa4-9bac223f7413
vhd=VHD-b79f90bb-b59d-4fb3-b6cc-fe904b8d55c7 capacity=107374182400
size=12280922112 hidden=1 parent=VHD-c45edea9-a22c-4e83-8aa4-9bac223f7413
vhd=VHD-898890f0-a758-48d5-b132-6767d42b8f0a capacity=107374182400 size=8388608
hidden=0 parent=VHD-b79f90bb-b59d-4fb3-b6cc-fe904b8d55c7
vhd=VHD-586cf97c-6110-4751-8f0c-c3f4d41d7525 capacity=107374182400
size=26965180416 hidden=1 parent=VHD-b79f90bb-b59d-4fb3-b6cc-fe904b8d55c7
vhd=VHD-606b1bfe-e884-4a60-ac9b-abf2066fcafe capacity=107374182400
size=107592286208 hidden=0 parent=VHD-586cf97c-6110-4751-8f0c-c3f4d41d7525
vhd=VHD-ed953149-2037-48ad-801f-2d40b25ef9af capacity=107374182400 size=8388608
hidden=0 parent=VHD-586cf97c-6110-4751-8f0c-c3f4d41d7525
<26335> 2013-05-09 09:56:10.717099 SR 7930
('18797b0c-8a72-3a88-95b7-5e9e0a9d21db') (79 VDIs in 17 VHD trees):
*24833850[VHD](100.000G//62.938G|n)
*57a4f262[VHD](100.000G//22.324G|n)
*f914dfd8[VHD](100.000G//22.559G|n)
b03ebfac[VHD](100.000G//8.000M|n)
*319abb67[VHD](100.000G//20.219G|n)
*cbe65966[VHD](100.000G//20.082G|n)
23f178c2[VHD](100.000G//8.000M|n)
*7cf30f57[VHD](100.000G//21.859G|n)
75ef3e23[VHD](100.000G//8.000M|n)
*f823d36f[VHD](100.000G//20.316G|n)
*b3b68fdb[VHD](100.000G//23.184G|n)
5b231146[VHD](100.000G//8.000M|n)
*d9dbc2f9[VHD](100.000G//23.008G|n)
2ed27c97[VHD](100.000G//8.000M|n)
*fd9a327e[VHD](100.000G//21.977G|n)
*1e93bf9b[VHD](100.000G//16.535G|n)
10762f8b[VHD](100.000G//8.000M|n)
*37c3feec[VHD](100.000G//15.641G|n)
*0c70af25[VHD](100.000G//21.645G|n)
*eca035fc[VHD](100.000G//17.789G|n)
*f6c6e1b9[VHD](100.000G//21.426G|n)
21b1d377[VHD](100.000G//8.000M|n)
*7ea810e7[VHD](100.000G//18.344G|n)
f162cd9c[VHD](100.000G//8.000M|n)
*9bd354ba[VHD](100.000G//26.434G|n)
671b1904[VHD](100.000G//8.000M|n)
*e877b4d8[VHD](100.000G//37.156G|n)
cbb1e04d[VHD](100.000G//8.000M|n)
*c45edea9[VHD](100.000G//14.340G|n)
*b79f90bb[VHD](100.000G//11.438G|n)
*586cf97c[VHD](100.000G//25.113G|n)
ed953149[VHD](100.000G//8.000M|n)
606b1bfe[VHD](100.000G//100.203G|n)
898890f0[VHD](100.000G//8.000M|n)
8144b5cd[VHD](100.000G//8.000M|n)
c5d0ed54[VHD](100.000G//8.000M|n)
886a9e91[VHD](100.000G//8.000M|n)
6bb8e002[VHD](100.000G//8.000M|n)
fd648003[VHD](100.000G//8.000M|n)
6874c61d[VHD](100.000G//8.000M|n)
3b52130f[VHD](100.000G//8.000M|n)
cbc62118[VHD](100.000G//8.000M|n)
d411e048[VHD](100.000G//8.000M|n)
----------------------------------------------------------------------
The information in this message is intended for the named recipients only. It
may contain information that is privileged, confidential or otherwise protected
from disclosure. If you are not the intended recipient, you are hereby notified
that any disclosure, copying, distribution, or the taking of any action in
reliance on the contents of this message is strictly prohibited. If you have
received this e-mail in error, do not print it or disseminate it or its
contents. In such event, please notify the sender by return e-mail and delete
the e-mail file immediately thereafter. Thank you.
