Mailing List Archive: MythTV: Users

Jobs stuck in the job queue

Index | Next | Previous | View Threaded

andersonas at comcast

Nov 21, 2009, 10:47 AM

Post #1 of 5 (1075 views)
Permalink

Jobs stuck in the job queue

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

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

ianforde at gmail

Nov 21, 2009, 11:09 AM

Post #2 of 5 (1041 views)
Permalink

Re: Jobs stuck in the job queue [In reply to]

On Sat, 2009-11-21 at 11:47 -0700, Alan Anderson wrote:
> 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. ?

>From the Main Menu, go to Information Center/System Status/Job Queue.
In there, you can delete entries from the job queue...

-I

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

andersonas at comcast

Nov 21, 2009, 2:14 PM

Post #3 of 5 (1038 views)
Permalink

Re: Jobs stuck in the job queue [In reply to]

On Saturday 21 November 2009 12:09:00 Ian Forde wrote:
> On Sat, 2009-11-21 at 11:47 -0700, Alan Anderson wrote:
> > 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. ?
> >
> >From the Main Menu, go to Information Center/System Status/Job Queue.
>
> In there, you can delete entries from the job queue...
>
> -I
>

Nope not in this case those jobs do not show up in there either. The only
place I can see them is the mythshutdown -s -v jobqueue.

Thanks

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

andersonas at comcast

Nov 21, 2009, 4:15 PM

Post #4 of 5 (1026 views)
Permalink

Re: Jobs stuck in the job queue [In reply to]

On Saturday 21 November 2009 15:14:19 Alan Anderson wrote:
> On Saturday 21 November 2009 12:09:00 Ian Forde wrote:
> > On Sat, 2009-11-21 at 11:47 -0700, Alan Anderson wrote:
> > > 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. ?
> > >
> > >From the Main Menu, go to Information Center/System Status/Job Queue.
> >
> > In there, you can delete entries from the job queue...
> >
> > -I
>
> Nope not in this case those jobs do not show up in there either. The only
> place I can see them is the mythshutdown -s -v jobqueue.
>
> Thanks
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

I can see the records in the database backup jobqueue table. So tomorrow I'll
back the data base up. Edit the backup to remove the errant records then
restore. Can I simply delete records from the backup and restore or is there
some sort of overall file integrity I will be messing up.

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

andersonas at comcast

Nov 22, 2009, 7:54 AM

Post #5 of 5 (1001 views)
Permalink

Re: Jobs stuck in the job queue [In reply to]

On Saturday 21 November 2009 17:15:20 Alan Anderson wrote:
> On Saturday 21 November 2009 15:14:19 Alan Anderson wrote:
> > On Saturday 21 November 2009 12:09:00 Ian Forde wrote:
> > > On Sat, 2009-11-21 at 11:47 -0700, Alan Anderson wrote:
> > > > 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. ?
> > > >
> > > >From the Main Menu, go to Information Center/System Status/Job Queue.
> > >
> > > In there, you can delete entries from the job queue...
> > >
> > > -I
> >
> > Nope not in this case those jobs do not show up in there either. The
> > only place I can see them is the mythshutdown -s -v jobqueue.
> >
> > Thanks
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users [at] mythtv
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> I can see the records in the database backup jobqueue table. So tomorrow
> I'll back the data base up. Edit the backup to remove the errant records
> then restore. Can I simply delete records from the backup and restore or
> is there some sort of overall file integrity I will be messing up.
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Dropping the database and restoring a edited backup resolved the issue.

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads