[mythtv-users] Jobs stuck in the job queue

[Alan Anderson]

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.org
> > 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.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

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