Page 1 of 1

Job queue is backed up

Posted: Thu May 23, 2019 12:08 am
by necbot
My job queue has a lot of stuff backed up on it. It seems to be stalled on a commercial flag job. When I run...

Code: Select all

mysql -u mythtv -p mythconverg -e "SELECT id,chanid,starttime,comment,status FROM jobqueue"
I get this...

+-----+--------+---------------------+---------------------------+--------+
| id | chanid | starttime | comment | status |
+-----+--------+---------------------+---------------------------+--------+
| 189 | 10651 | 2019-05-20 01:00:00 | | 1 |
| 190 | 10651 | 2019-05-20 00:00:00 | | 1 |
| 191 | 10651 | 2019-05-20 02:00:00 | | 1 |
| 185 | 10651 | 2019-05-19 23:00:00 | | 1 |
| 186 | 10621 | 2019-05-19 23:00:00 | | 1 |
| 173 | 10651 | 2019-05-19 22:00:00 | Metadata Lookup Complete. | 272 |
| 376 | 10621 | 2019-05-23 00:00:00 | | 1 |
| 188 | 10621 | 2019-05-20 00:00:00 | | 1 |
| 187 | 10651 | 2019-05-20 00:00:00 | | 1 |
| 235 | 10624 | 2019-05-20 22:30:00 | | 1 |
| 234 | 10624 | 2019-05-20 23:00:00 | | 1 |
| 183 | 10611 | 2019-05-19 23:30:00 | | 1 |
| 178 | 10651 | 2019-05-19 23:00:00 | | 1 |
| 179 | 10621 | 2019-05-19 22:00:00 | | 1 |
| 180 | 10611 | 2019-05-19 23:00:00 | | 1 |
| 233 | 10621 | 2019-05-20 23:00:00 | | 1 |
| 184 | 10621 | 2019-05-20 00:00:00 | | 1 |
| 182 | 10611 | 2019-05-19 23:00:00 | | 1 |
| 181 | 10611 | 2019-05-19 23:30:00 | | 1 |
| 175 | 10651 | 2019-05-19 21:00:00 | Searching for Logo | 4 |
| 172 | 10621 | 2019-05-19 22:00:00 | Metadata Lookup Complete. | 272 |

ID 175 is stuck. What does status 4 mean?

Re: Job queue is backed up

Posted: Thu May 23, 2019 6:54 pm
by Gribnif
This happens to me every month or two, as well. Simply restarting the backend is enough to get it running again.

Re: Job queue is backed up

Posted: Thu May 23, 2019 10:16 pm
by necbot
I restarted and things seem to be moving again. I'm not sure why it stalled. I should have restarted sooner, I have a lot of commercial flagging job on the queue. Can I clear those somehow?

Re: Job queue is backed up

Posted: Thu May 23, 2019 10:34 pm
by bill6502
To your original question: https://www.mythtv.org/wiki/Jobqueue_table. 4=Running.

Or: https://code.mythtv.org/cgit/mythtv/tre ... jobqueue.h if you like.

'Searching for Logo' sounds like commercial flagging. If you add type to the initial
query, you can prove that(JOB_COMMFLAG=0x0002.)

Re: Job queue is backed up

Posted: Fri May 24, 2019 10:38 pm
by necbot
bill6502 wrote:
Thu May 23, 2019 10:34 pm
To your original question: https://www.mythtv.org/wiki/Jobqueue_table. 4=Running.

Or: https://code.mythtv.org/cgit/mythtv/tre ... jobqueue.h if you like.

'Searching for Logo' sounds like commercial flagging. If you add type to the initial
query, you can prove that(JOB_COMMFLAG=0x0002.)
Thanks! That page was very useful. One more question. After I restarted it stalled again. When it stalls, I see that it is stuck on a commercial flagging job and the message says "Searching for Logo". The latest job has been stalled for about 16 hours now.

Re: Job queue is backed up

Posted: Mon May 27, 2019 6:26 pm
by necbot
Okay I give up. Whenever I clear the stalled job another takes it's place. My job queue is backed up with over a weeks worth of jobs! Commercial flagging is clearly too buggy and doesn't work. How do I turn commercial flagging off?

Re: Job queue is backed up

Posted: Mon May 27, 2019 9:58 pm
by pvr4me
Commercial flagging works for me 99.99% of the time. I think the only time I've had stuck commflag jobs was when the recording was subtly damaged. It seems to abort on severely damaged recordings. What is the source of your recordings and have you noticed any glitches?

Craig

Re: Job queue is backed up

Posted: Mon May 27, 2019 10:29 pm
by bill6502
/var/log/mythtv/mythcommflag.log may have a clue about why it's hanging.

To turn flagging off, edit each recording rule. To turn it off for future rules,
edit the Default template (or others you may have created.)

Another option would be to change the Commercial detection method in
the frontend Setup->Video->General->General (Jobs) to a method that
doesn't use Logo Detection.

Re: Job queue is backed up

Posted: Tue May 28, 2019 12:40 am
by necbot
bill6502 wrote:
Mon May 27, 2019 10:29 pm
/var/log/mythtv/mythcommflag.log may have a clue about why it's hanging.

To turn flagging off, edit each recording rule. To turn it off for future rules,
edit the Default template (or others you may have created.)

Another option would be to change the Commercial detection method in
the frontend Setup->Video->General->General (Jobs) to a method that
doesn't use Logo Detection.
Thanks bill6502. That worked!