[ovirt-users] Cancel a running task | Zombie Task

[Simone Tiraboschi]

----- Original Message -----
> From: "Paul Heinlein" <heinlein at madboa.com>
> To: "Punit Dambiwal" <hypunit at gmail.com>
> Cc: users at ovirt.org
> Sent: Thursday, April 9, 2015 8:07:56 PM
> Subject: Re: [ovirt-users] Cancel a running task | Zombie Task
> 
> On Thu, 9 Apr 2015, Punit Dambiwal wrote:
> 
> > I have checked and found two tasks running from last 14 hours and
> > there is no option to kill it...
> > 
> > Inline image 1
> > 
> > from the SPM host :-
> > 
> > [root at cpu11 ~]# vdsClient -s 0 getAllTasksStatuses
> > {'status': {'message': 'OK', 'code': 0}, 'allTasksStatus': {}}
> > 
> > [root at cpu11 ~]#
> > 
> > Please let me know how i can kill those processes...
> 
> There may be a officially blessed method for killing zombie tasks, but
> my experience is that all you can do is delete them from the database.

The canonical way relies on the /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh utility.
Directly manipulating the DB should be avoided as far as possible.

> On the ovirt-engine server, get a psql shell, e.g.,
> 
>    psql -d engine -U postgres
> 
> Data about running tasks are stored in the job table. You might find
> this query interesting:
> 
>    select * from job order by start_time desc;
> 
> Grab the job_id for the task you want to delete, then use the
> DeleteJob procedure, e.g.,
> 
>    select DeleteJob('8424f7a9-2a4c-4567-b528-45bbc1c2534f');
> 
> Give the web GUI a minute or so to catch up with you. The tasks should
> be gone.
> 
> --
> Paul Heinlein
> heinlein at madboa.com
> 45°38' N, 122°6' W
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>