taskcleaner.sh only clears tasks form the engine database.
did you check your engine logs to see if this task is running?
it's a task that is executed during a snapshot merge (removal of a
snapshot), do you have any running snapshot removals?
if not you can stop and clear the task using vdsm-client

On Fri, Jul 26, 2019 at 1:31 PM Enrico <enrico.becche...@pg.infn.it> wrote:

>    Dear all,
>
> I try this:
>
> # /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -v -t
> fdcf4d1b-82fe-49a6-b233-323ebe568f8e
> select exists (select * from information_schema.tables where table_schema
> = 'public' and table_name = 'command_entities');
>  t
>  This will remove the given Task!!!
> Caution, this operation should be used with care. Please contact support
> prior to running this command
> Are you sure you want to proceed? [y/n]
> y
> SELECT Deleteasync_tasks('fdcf4d1b-82fe-49a6-b233-323ebe568f8e');
>                  0
>
> # /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh -v -R
> select exists (select * from information_schema.tables where table_schema
> = 'public' and table_name = 'command_entities');
>  t
>  This will remove all async_tasks table content!!!
> Caution, this operation should be used with care. Please contact support
> prior to running this command
> Are you sure you want to proceed? [y/n]
> y
> TRUNCATE TABLE async_tasks cascade;
> TRUNCATE TABLE
>
> but after these commands I see the same messages inside engine.log:
>
> 2019-07-26 12:25:19,727+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] Task id
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' has passed pre-polling period time
> and should be polled. Pre-polling period is 60000 millis.
> 2019-07-26 12:25:19,727+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] Task id
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' has passed pre-polling period time
> and should be polled. Pre-polling period is 60000 millis.
> 2019-07-26 12:25:19,779+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] Task id
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' has passed pre-polling period time
> and should be polled. Pre-polling period is 60000 millis.
> 2019-07-26 12:25:19,779+02 ERROR
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> BaseAsyncTask::logEndTaskFailure: Task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' (Parent Command 'Unknown',
> Parameters Type
> 'org.ovirt.engine.core.common.asynctasks.AsyncTaskParameters') ended with
> failure:
> 2019-07-26 12:25:19,779+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> SPMAsyncTask::ClearAsyncTask: Attempting to clear task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e'
> 2019-07-26 12:25:19,780+02 INFO
> [org.ovirt.engine.core.vdsbroker.irsbroker.SPMClearTaskVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] START,
> SPMClearTaskVDSCommand(
> SPMTaskGuidBaseVDSCommandParameters:{storagePoolId='18d57688-6ed4-43b8-bd7c-0665b55950b7',
> ignoreFailoverLimit='false',
> taskId='fdcf4d1b-82fe-49a6-b233-323ebe568f8e'}), log id: 753de6fe
> 2019-07-26 12:25:19,781+02 INFO
> [org.ovirt.engine.core.vdsbroker.vdsbroker.HSMClearTaskVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] START,
> HSMClearTaskVDSCommand(HostName = infn-vm05.management,
> HSMTaskGuidBaseVDSCommandParameters:{hostId='751f3e99-b95e-4c31-bc38-77f5661a0bdc',
> taskId='fdcf4d1b-82fe-49a6-b233-323ebe568f8e'}), log id: e5dc020
> 2019-07-26 12:25:19,786+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> SPMAsyncTask::ClearAsyncTask: At time of attempt to clear task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' the response code was
> 'TaskStateError' and message was 'Operation is not allowed in this task
> state: ("can't clean in state running",)'. Task will not be cleaned
> 2019-07-26 12:25:19,786+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> BaseAsyncTask::onTaskEndSuccess: Task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' (Parent Command 'Unknown',
> Parameters Type
> 'org.ovirt.engine.core.common.asynctasks.AsyncTaskParameters') ended
> successfully.
> 2019-07-26 12:25:19,786+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> SPMAsyncTask::ClearAsyncTask: Attempting to clear task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e'
> 2019-07-26 12:25:19,787+02 INFO
> [org.ovirt.engine.core.vdsbroker.irsbroker.SPMClearTaskVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] START,
> SPMClearTaskVDSCommand(
> SPMTaskGuidBaseVDSCommandParameters:{storagePoolId='18d57688-6ed4-43b8-bd7c-0665b55950b7',
> ignoreFailoverLimit='false',
> taskId='fdcf4d1b-82fe-49a6-b233-323ebe568f8e'}), log id: 40383d58
> 2019-07-26 12:25:19,788+02 INFO
> [org.ovirt.engine.core.vdsbroker.vdsbroker.HSMClearTaskVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] START,
> HSMClearTaskVDSCommand(HostName = infn-vm05.management,
> HSMTaskGuidBaseVDSCommandParameters:{hostId='751f3e99-b95e-4c31-bc38-77f5661a0bdc',
> taskId='fdcf4d1b-82fe-49a6-b233-323ebe568f8e'}), log id: 758d79b
> 2019-07-26 12:25:19,793+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> SPMAsyncTask::ClearAsyncTask: At time of attempt to clear task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' the response code was
> 'TaskStateError' and message was 'Operation is not allowed in this task
> state: ("can't clean in state running",)'. Task will not be cleaned
> 2019-07-26 12:25:19,793+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] Task id
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' has passed pre-polling period time
> and should be polled. Pre-polling period is 60000 millis.
> 2019-07-26 12:25:19,793+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> SPMAsyncTask::ClearAsyncTask: Attempting to clear task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e'
> 2019-07-26 12:25:19,794+02 INFO
> [org.ovirt.engine.core.vdsbroker.irsbroker.SPMClearTaskVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] START,
> SPMClearTaskVDSCommand(
> SPMTaskGuidBaseVDSCommandParameters:{storagePoolId='18d57688-6ed4-43b8-bd7c-0665b55950b7',
> ignoreFailoverLimit='false',
> taskId='fdcf4d1b-82fe-49a6-b233-323ebe568f8e'}), log id: 1dc8cb98
> 2019-07-26 12:25:19,795+02 INFO
> [org.ovirt.engine.core.vdsbroker.vdsbroker.HSMClearTaskVDSCommand]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) [] START,
> HSMClearTaskVDSCommand(HostName = infn-vm05.management,
> HSMTaskGuidBaseVDSCommandParameters:{hostId='751f3e99-b95e-4c31-bc38-77f5661a0bdc',
> taskId='fdcf4d1b-82fe-49a6-b233-323ebe568f8e'}), log id: 7df444c1
> 2019-07-26 12:25:19,800+02 INFO
> [org.ovirt.engine.core.bll.tasks.SPMAsyncTask]
> (EE-ManagedThreadFactory-engineScheduled-Thread-77) []
> SPMAsyncTask::ClearAsyncTask: At time of attempt to clear task
> 'fdcf4d1b-82fe-49a6-b233-323ebe568f8e' the response code was
> 'TaskStateError' and message was 'Operation is not allowed in this task
> state: ("can't clean in state running",)'. Task will not be cleaned
>
> it's seems to be task id   fdcf4d1b-82fe-49a6-b233-323ebe568f8e  is still
> running.
>
> Any other ideas ?
>
> Thank you so much.
> Best Regards
> Enrico
>
>
> Il 26/07/19 09:39, Strahil Nikolov ha scritto:
>
> Have you tried to remove your task via the taskcleaner.sh
> You can find some details on
> https://www.ovirt.org/develop/developer-guide/db-issues/helperutilities.html
>
> I should admit , that I have never used that.
>
> Best Regards,
> Strahil Nikolov
>
> В петък, 26 юли 2019 г., 09:03:10 ч. Гринуич+3, Enrico
> <enrico.becche...@pg.infn.it> <enrico.becche...@pg.infn.it> написа:
>
>
> Il 25/07/19 22:27, Strahil Nikolov ha scritto:
>
> > Hi all,
> >my ovirt cluster has got 3 Hypervisors runnig Centos 7.5.1804 vdsm is
> 4.20.39.1-1.el7,
> >ovirt engine is 4.2.4.5-1.el7, the storage systems are HP MSA P2000 and
> 2050 (fibre channel).
>
> >I need to stop one of the hypervisors for maintenance but this system is
> the storage pool manager.
>
> >For this reason I decided to manually activate SPM in one of the other
> nodes but this operation is not
> successful.
>
> Why would you do that ?
> Just put the host in maintenance and the system will evacuate all VMs and
> another host will be promoted as SPM .
> Once the host is in maintenance - you can proceed with your tasks.
>
> P.S: Don't forget to remove the mainteance mode once you are over.
>
> Best Regards,
> Strahil Nikolov
> Hi Strahil,
> I did not tell you that this is the first thing I tried but it didn't work
> because SPM can't be activated in another host,
> then I tried to manually move SPM without success.
> Any ideas ?
> Thanks a lot !
>
> Best Regards
>
> Enrico
>
> --
> _______________________________________________________________________
>
> Enrico Becchetti                    Servizio di Calcolo e Reti
>
> Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
> Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
> Phone:+39 075 5852777             Mail: Enrico.Becchetti<at>pg.infn.it
> _______________________________________________________________________
>
>
>
> --
> _______________________________________________________________________
>
> Enrico Becchetti                    Servizio di Calcolo e Reti
>
> Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
> Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
> Phone:+39 075 5852777             Mail: Enrico.Becchetti<at>pg.infn.it
> _______________________________________________________________________
>
> _______________________________________________
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/VQJCGFXAA37OXW7LO3CDPDXH7WXTF4LJ/
>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/TX6P4JTXCDJ43LHFJQEOCYHZX3P6X7EX/

Reply via email to