[mythtv-users] JobQueue: Skipping 'Flag Commercials', should run on xxx instead

Chris Pinkham cpinkham at bc2va.org
Thu Jan 11 04:10:42 UTC 2007


* On Wed Jan 10, 2007 at 09:54:33AM -0800, Blammo wrote:
>  Skipping 'Flag Commercials' job for chanid 1021 @ 20070108180000,
> should run on 'sbe1' instead
>  Skipping 'Flag Commercials' job for chanid 1021 @ 20070109140000,
> should run on 'sbe3' instead

The JobQueue sets the hostname field in the jobqueue table when a JobQueue
instance takes a job and tries to run it.  It is possible these jobs tried
to run on sbe1/sbe3 previously and failed for some reason.

The housekeeper should cleanup the jobqueue table entries once a day and
reset failed jobs, but it won't clear the hostname on a job that has a
hostname set.  There is no easy way for the cleanup to know whether the
job was supposed to run only on that host or whether that host just
claimed the job at some point.  If you want to get rid of these, run
the following SQL command:

UPDATE jobqueue SET hostname = ""
    WHERE chanid = 1021
	    AND STARTTIME in ( 20070108180000, 20070109140000 );

> +---------------------+------+----------+
> | JobsRunOnRecordHost | 0    | NULL     |
> +---------------------+------+----------+

> Does there need to be a value for each host, or is a global setting
> enough? Any thoughts on why the jobs won't run on an available host?

This is a global setting and I think unrelated to your issue.

--
Chris


More information about the mythtv-users mailing list