[mythtv-users] Jobs stuck in the job queue

[Alan Anderson]

Hi

This is probably more DB cruft left over from previous upgrades that mythtv 
0.22 finds. And other versions of mythtv ?did not care about.

But since the upgrade from 0.21 to 0.22 mythbackend will not shutdown due to 
jobs pending. ?I do not see any extra transcode or commercial detection 
process left running. ?A fresh reboot results in the same. ?I do not see these 
jobs via mythweb it shows the queue is empty.

According to the mythshutdown -s -v jobsqueue there is a really old job queued 
from 2005. ?Any ideas on how to clean this up? ? I have had various issues 
over the years ?transcode jobs failing due to segfaults and or dirty 
recordings etc. ?Out of 29 jobs found the 2005 job is the only one marked 
found ?the rest are marked ignore. ?

# mythshutdown -s -v jobqueue
2009-11-21 10:16:56.913 Using runtime prefix = /usr
2009-11-21 10:16:56.913 Using configuration directory = /root/.mythtv
2009-11-21 10:16:56.913 Empty LocalHostName.
2009-11-21 10:16:56.913 Using localhost value of pvr.home.lan
2009-11-21 10:16:57.590 New DB connection, total: 1
2009-11-21 10:16:57.599 Connected to database 'mythconverg' at host: localhost
2009-11-21 10:16:57.600 Closing DB connection named 'DBManager0'
2009-11-21 10:16:57.601 Deleting UPnP client...
2009-11-21 10:16:58.061 Mythshutdown: --status
2009-11-21 10:16:58.197 isRecording: Attempting to connect to master server...
2009-11-21 10:16:58.199 Connected to database 'mythconverg' at host: localhost
2009-11-21 10:16:58.212 MythContext: Connecting to backend server: 
192.168.123.20:6543 (try 1 of 1)
2009-11-21 10:16:58.213 Using protocol version 50
2009-11-21 10:16:58.436 JobQueue: Currently set to run new jobs from 00:00 to 
23:59
2009-11-21 10:16:58.436 JobQueue: HasRunningOrPendingJobs: checking for jobs 
starting before: Sat Nov 21 10:31:58 2009
2009-11-21 10:16:58.436 New DB connection, total: 2
2009-11-21 10:16:58.438 Connected to database 'mythconverg' at host: localhost
2009-11-21 10:16:58.443 JobQueue: GetJobsInQueue: findJobs search bitmask 4, 
found 29 total jobs
2009-11-21 10:16:58.444 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1071 @ 20050921105500 in Errored state.
2009-11-21 10:16:58.444 JobQueue: GetJobsInQueue: Found 'Transcode' Job for 
chanid 2003 @ 20050922130000 in Queued state.
2009-11-21 10:16:58.444 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1003 @ 21060206232815 in Errored state.
2009-11-21 10:16:58.444 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 3501 @ 20091119185900 in Finished state.
2009-11-21 10:16:58.445 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 3501 @ 20091119185900 in Finished state.
2009-11-21 10:16:58.445 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 4301 @ 20091119185900 in Finished state.
2009-11-21 10:16:58.445 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 4301 @ 20091119185900 in Finished state.
2009-11-21 10:16:58.445 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 3501 @ 20091119195900 in Finished state.
2009-11-21 10:16:58.445 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 3501 @ 20091119195900 in Finished state.
2009-11-21 10:16:58.445 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 1007 @ 20091119195900 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1007 @ 20091119195900 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 5101 @ 20091119200000 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 5101 @ 20091119200000 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 4101 @ 20091119205900 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 4101 @ 20091119205900 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 5102 @ 20091120185900 in Finished state.
2009-11-21 10:16:58.446 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 5102 @ 20091120185900 in Finished state.
2009-11-21 10:16:58.447 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 1071 @ 20091120185900 in Finished state.
2009-11-21 10:16:58.447 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1071 @ 20091120185900 in Finished state.
2009-11-21 10:16:58.447 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 1029 @ 20091120185900 in Finished state.
2009-11-21 10:16:58.447 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1029 @ 20091120185900 in Finished state.
2009-11-21 10:16:58.447 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 4101 @ 20091120200000 in Finished state.
2009-11-21 10:16:58.447 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 4101 @ 20091120200000 in Finished state.
2009-11-21 10:16:58.448 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 1071 @ 20091120200000 in Finished state.
2009-11-21 10:16:58.448 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1071 @ 20091120200000 in Finished state.
2009-11-21 10:16:58.448 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 1029 @ 20091120200000 in Finished state.
2009-11-21 10:16:58.448 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 1029 @ 20091120200000 in Finished state.
2009-11-21 10:16:58.448 JobQueue: GetJobsInQueue: Ignore 'Transcode' Job for 
chanid 4101 @ 20091120210000 in Finished state.
2009-11-21 10:16:58.448 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' 
Job for chanid 4101 @ 20091120210000 in Finished state.
2009-11-21 10:16:58.449 JobQueue: HasRunningOrPendingJobs: found pending job 
scheduled to start at: Mon Jan 1 00:00:00 2007
2009-11-21 10:16:58.449 Has queued or pending jobs
2009-11-21 10:16:58.505 Mythshutdown: --status returned: 32

I tried creating a empty 2003_20050922130000.nuv file.  It did not help.


Thanks for any ideas
Alan