[mythtv-users] Jobs stuck in the job queue

[Alan Anderson]

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.