mysql To Delete A Recording From the Job Queue

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
jamoody
Junior
Posts: 85
Joined: Mon Aug 18, 2014 4:19 pm
United States of America

mysql To Delete A Recording From the Job Queue

Post by jamoody » Thu May 04, 2017 12:58 am

I have 2 recordings in the job queue (commercial flagging) which show in the frontend System Status but never move off Queued. I tried deleting them via the panel but they just won't delete. The recordings are valid.

What is the mysql command to display and then delete specific items from the job queue? Thanks.

daraden
Senior
Posts: 169
Joined: Tue Feb 23, 2016 7:33 am
United States of America

Re: mysql To Delete A Recording From the Job Queue

Post by daraden » Fri May 05, 2017 1:38 am

Code: Select all

mysql -u mythtv -p mythconverg -e "SELECT * from jobqueue WHERE type=2"
will give you a list of commercial flagging jobs in the job queue. If you remove the WHERE type=2 it will list all entries in the job queue.

After you find the offending entries use

Code: Select all

mysql -u mythtv -p mythconverg -e "DELETE from jobqueue WHERE id=<IdNumber>"
you could use WHERE chanid=<chanid> starttime=<starttime>, but that would also remove any other jobs you have for that recording.

If you have more than a couple you may want to log into mysql to avoid typing the password every time.

jamoody
Junior
Posts: 85
Joined: Mon Aug 18, 2014 4:19 pm
United States of America

Re: mysql To Delete A Recording From the Job Queue

Post by jamoody » Mon May 08, 2017 5:09 pm

Thanks for the help.

Post Reply