[ovirt-users] Can't remove snapshot

[Rik Theys]

Hi Greg,

> 
> 2016-02-09 21:30 GMT-03:00 Greg Padgett <gpadgett at redhat.com>:
>> On 02/09/2016 06:08 AM, Michal Skrivanek wrote:
>>>
>>>
>>>> On 03 Feb 2016, at 10:37, Rik Theys <Rik.Theys at esat.kuleuven.be> wrote:

>>>>> I can see the snapshot in the "Disk snapshot" tab of the storage. It has
>>>>> a status of "illegal". Is it OK to (try to) remove this snapshot? Will
>>>>> this impact the running VM and/or disk image?
>>>
>>>
>>> No, it’s not ok to remove it while live merge(apparently) is still ongoing
>>> I guess that’s a live merge bug?
>>
>>
>> Indeed, this is bug 1302215.
>>
>> I wrote a sql script to help with cleanup in this scenario, which you can
>> find attached to the bug along with a description of how to use it[1].
>>
>> However, Rik, before trying that, would you be able to run the attached
>> script [2] (or just the db query within) and forward the output to me? I'd
>> like to make sure everything looks as it should before modifying the db
>> directly.

I ran the following query on the engine database:

select images.* from images join snapshots ON (images.vm_snapshot_id =
snapshots.snapshot_id)
join vm_static on (snapshots.vm_id = vm_static.vm_guid)
where vm_static.vm_name = 'lena' and snapshots.description='before
jessie upgrade';

The resulting output is:

              image_guid              |     creation_date      |    size
    |               it_guid                |               parentid
          | images
tatus |        lastmodified        |            vm_snapshot_id
  | volume_type | volume_format |            image_group_id            |
        _create_da
te          |         _update_date          | active |
volume_classification
--------------------------------------+------------------------+-------------+--------------------------------------+--------------------------------------+-------
------+----------------------------+--------------------------------------+-------------+---------------+--------------------------------------+-------------------
------------+-------------------------------+--------+-----------------------
 24d78600-22f4-44f7-987b-fbd866736249 | 2015-05-19 15:00:13+02 |
34359738368 | 00000000-0000-0000-0000-000000000000 |
00000000-0000-0000-0000-000000000000 |
    4 | 2016-01-30 08:45:59.998+01 |
4b4930ed-b52d-47ec-8506-245b7f144102 |           1 |             5 |
b2390535-744f-4c02-bdc8-5a897226554b | 2015-05-19 15:00:1
1.864425+02 | 2016-01-30 08:45:59.999422+01 | f      |                     1
(1 row)

Regards,

Rik


>>
>> Thanks,
>> Greg
>>
>> [1] https://bugzilla.redhat.com/show_bug.cgi?id=1302215#c13
>> (Also note that the engine should be stopped before running this.)
>>
>> [2] Arguments are the ovirt db name, db user, and the name of the vm you
>> were performing live merge on.
>>
>>
>>> Thanks,
>>> michal
>>>
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Rik
>>>>
>>>> On 02/03/2016 10:26 AM, Rik Theys wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> I created a snapshot of a running VM prior to an OS upgrade. The OS
>>>>> upgrade has now been succesful and I would like to remove the snapshot.
>>>>> I've selected the snapshot in the UI and clicked Delete to start the
>>>>> task.
>>>>>
>>>>> After a few minutes, the task has failed. When I click delete again on
>>>>> the same snapshot, the failed message is returned after a few seconds.
>>>>>
>>>>>>  From browsing through the engine log (attached) it seems the snapshot
>>>>>
>>>>> was correctly merged in the first try but something went wrong in the
>>>>> finalizing fase. On retries, the log indicates the snapshot/disk image
>>>>> no longer exists and the removal of the snapshot fails for this reason.
>>>>>
>>>>> Is there any way to clean up this snapshot?
>>>>>
>>>>> I can see the snapshot in the "Disk snapshot" tab of the storage. It has
>>>>> a status of "illegal". Is it OK to (try to) remove this snapshot? Will
>>>>> this impact the running VM and/or disk image?

-- 
Rik Theys
System Engineer
KU Leuven - Dept. Elektrotechniek (ESAT)
Kasteelpark Arenberg 10 bus 2440  - B-3001 Leuven-Heverlee
+32(0)16/32.11.07
----------------------------------------------------------------
<<Any errors in spelling, tact or fact are transmission errors>>