[ovirt-users] Hanging remove snapshot tasks

[Michal Skrivanek]

On 9 Oct 2015, at 13:32, Arsène Gschwind wrote:

> Could anybody tell me if I can just delete these entries without generating further problems?

Well, I suppose they are not running anymore, right? You didn't start any snapshot operation recently…
Did you try all teh options of taskcleaner.sh?
If you're out of options…then I guess just remove them

> 
> Thanks for any hint,
> Arsène
> 
> On 10/08/2015 05:49 PM, Arsène Gschwind wrote:
>> Yes they are in this table:engine=# select command_type, entity_type from business_entity_snapshot;
>>                   command_type                   |                      entity_type                       
>> -------------------------------------------------+--------------------------------------------------------
>>  org.ovirt.engine.core.bll.RemoveSnapshotCommand | org.ovirt.engine.core.common.businessentities.Snapshot
>>  org.ovirt.engine.core.bll.RemoveSnapshotCommand | org.ovirt.engine.core.common.businessentities.Snapshot
>>  org.ovirt.engine.core.bll.RemoveSnapshotCommand | org.ovirt.engine.core.common.businessentities.Snapshot
>>  org.ovirt.engine.core.bll.RemoveSnapshotCommand | org.ovirt.engine.core.common.businessentities.Snapshot
>> (4 rows)
>> 
>> engine=# 
>> 
>> The doc says that taskcleaner.sh should be called by ovirt-setup, I can see it in the log, it is called but it doesn't clean that compensations. 
>> Could I just remove these entries?
>> 
>> Thanks for your help,
>> Arsène
>> 
>> 
>> On 10/08/2015 04:48 PM, Simone Tiraboschi wrote:
>>> 
>>> 
>>> On Thu, Oct 8, 2015 at 12:49 PM, Arsène Gschwind <arsene.gschwind at unibas.ch> wrote:
>>> Did restart the service and tried to udate again but still the same problem.
>>> Are there some entries in the DB somewhere?
>>> 
>>> These are compensations so they should be in that table, please try executing this query:
>>>     select command_type, entity_type from business_entity_snapshot
>>> to check if they are there.
>>> 
>>> You could use /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh utility to cleanup there.
>>>  
>>> Thanks,
>>> Arsène
>>> 
>>> 
>>> On 10/08/2015 12:33 PM, Raz Tamir wrote:
>>>> As part of the update process, the ovirt-engine service will restart.
>>>> Can you try restart it manually with 'service ovirt-engine restart' and try the update again?
>>>> 
>>>> 
>>>> 
>>>> Thanks,
>>>> Raz Tamir
>>>> Red Hat Israel
>>>> 
>>>> On Thu, Oct 8, 2015 at 1:27 PM, Arsène Gschwind <arsene.gschwind at unibas.ch> wrote:
>>>> The update still fails with the same problems.
>>>> Running that command on the spm host returns nothing.
>>>> 
>>>> Thanks,
>>>> Arsène
>>>> 
>>>> 
>>>> On 10/08/2015 12:08 PM, Raz Tamir wrote:
>>>>> Ok, so try to update again, and if you fail, please run 'vdsClient -s 0 getAllTasks' from your spm host and provide the output
>>>>> 
>>>>> 
>>>>> 
>>>>> Thanks,
>>>>> Raz Tamir
>>>>> Red Hat Israel
>>>>> 
>>>>> On Thu, Oct 8, 2015 at 12:55 PM, Arsène Gschwind <arsene.gschwind at unibas.ch> wrote:
>>>>> Hi Raz,
>>>>> 
>>>>> The table is empty:
>>>>> 
>>>>> engine=# select * from async_tasks;
>>>>>  task_id | action_type | status | result | step_id | command_id | started_at | storage_pool_id | task_type | vdsm_task_id | root_comm
>>>>> and_id | user_id 
>>>>> ---------+-------------+--------+--------+---------+------------+------------+-----------------+-----------+--------------+----------
>>>>> -------+---------
>>>>> (0 rows)
>>>>> 
>>>>> Thanks for your help,
>>>>> Arsène
>>>>> 
>>>>> 
>>>>> 
>>>>> On 10/07/2015 08:59 PM, Raz Tamir wrote:
>>>>>> Hi Arsène,
>>>>>> From the engine run the following commands:
>>>>>> 1. # su - postgres
>>>>>> 2. # psql -d engine
>>>>>> 3. please, provide the output of this command:
>>>>>>     # select * from async_tasks ;
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> Thanks,
>>>>>> Raz Tamir
>>>>>> Red Hat Israel
>>>>>> 
>>>>>> On Wed, Oct 7, 2015 at 6:34 PM, Arsène Gschwind <arsene.gschwind at unibas.ch> wrote:
>>>>>> Any idea how to get ride of those tasks?
>>>>>> 
>>>>>> Thanks a lot
>>>>>> Arsène
>>>>>> 
>>>>>> 
>>>>>> On 10/06/2015 02:43 PM, Arsène Gschwind wrote:
>>>>>> Hi,
>>>>>> 
>>>>>> I would like to update ovirt to 3.5.4 from 3.5.3 but engine-setup fails due to remove snapshot tasks.
>>>>>> 
>>>>>> [ INFO  ] Cleaning async tasks and compensations
>>>>>>           The following system tasks have been found running in the system:
>>>>>>           The following commands have been found running in the system:
>>>>>>           The following compensations have been found running in the system:
>>>>>>           org.ovirt.engine.core.bll.RemoveSnapshotCommand org.ovirt.engine.core.common.businessentities.Snapshot
>>>>>>           org.ovirt.engine.core.bll.RemoveSnapshotCommand org.ovirt.engine.core.common.businessentities.Snapshot
>>>>>>           org.ovirt.engine.core.bll.RemoveSnapshotCommand org.ovirt.engine.core.common.businessentities.Snapshot
>>>>>>           org.ovirt.engine.core.bll.RemoveSnapshotCommand org.ovirt.engine.core.common.businessentities.Snapshot
>>>>>>           Would you like to try to wait for that?
>>>>>> 
>>>>>> This tasks are not showing up in the task monitor and I have no idea how to get them away to be abl to update.
>>>>>> 
>>>>>> Thanks for any hint/help
>>>>>> 
>>>>>> rgds, Arsène
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at ovirt.org
>>>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>>> 
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at ovirt.org
>>>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>>> 
>>>>> 
>>>>> 
>>>> 
>>>> 
>>> 
>>> 
>>> _______________________________________________
>>> Users mailing list
>>> Users at ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>> 
>>> 
>> 
> 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20151009/9149f4a7/attachment-0001.html>