Ticket #9160: jobqueue.txt

File jobqueue.txt, 4.6 KB (added by Ken Emerson <kenneth.emerson@…>, 9 years ago)

Then entry of 6/24/2011 14:30 is currently running. The entry of 6/27/2011 14:30 is an orphan.

Line 
1mysql> select * from jobqueue;
2+------+--------+---------------------+---------------------+------+------+-------+--------+---------------------+----------+------+------------------------------+---------------------+
3| id   | chanid | starttime           | inserttime          | type | cmds | flags | status | statustime          | hostname | args | comment                      | schedruntime        |
4+------+--------+---------------------+---------------------+------+------+-------+--------+---------------------+----------+------+------------------------------+---------------------+
5| 9424 |   1082 | 2011-06-24 14:30:00 | 2011-06-28 13:51:19 |    2 |    0 |     1 |    272 | 2011-06-28 14:03:06 | mythtv   |      | 4 commercial breaks          | 2011-06-28 13:51:19 |
6| 9422 |   1082 | 2011-06-27 14:30:00 | 2011-06-28 00:47:32 |    2 |    0 |     1 |    272 | 2011-06-28 01:05:47 | mythtv   |      | 3 commercial breaks          | 2011-06-28 00:47:32 |
7| 9421 |   1061 | 2011-06-08 18:30:00 | 2011-06-28 00:37:25 |    2 |    0 |     1 |    272 | 2011-06-28 00:57:28 | mythtv   |      | 4 commercial breaks          | 2011-06-28 00:37:25 |
8| 9420 |   1061 | 2011-06-09 18:30:00 | 2011-06-28 00:20:20 |    2 |    0 |     1 |    272 | 2011-06-28 00:33:29 | mythtv   |      | 3 commercial breaks          | 2011-06-28 00:20:20 |
9| 9397 |   1082 | 2011-06-24 14:30:00 | 2011-06-24 15:00:15 |    2 |    0 |     0 |      4 | 2011-06-28 14:02:58 | mythtv   |      | 99% Completed @ 95.6455 fps. | 2011-06-24 15:00:15 |
10| 9410 |   1082 | 2011-06-22 14:30:00 | 2011-06-27 13:51:26 |    2 |    0 |     1 |    304 | 2011-06-27 18:10:49 | mythtv   |      | Failed with exit status 134  | 2011-06-27 13:51:26 |
11| 9411 |   1061 | 2011-06-10 18:30:00 | 2011-06-27 13:52:04 |    2 |    0 |     1 |    272 | 2011-06-27 18:22:38 | mythtv   |      | 3 commercial breaks          | 2011-06-27 13:52:04 |
12| 9423 |   2050 | 2011-06-28 01:30:00 | 2011-06-28 02:00:16 |    2 |    0 |     0 |    272 | 2011-06-28 02:12:20 | mythtv   |      | 4 commercial breaks          | 2011-06-28 02:00:16 |
13| 9413 |   3763 | 2011-06-27 13:00:00 | 2011-06-27 14:00:15 |    2 |    0 |     0 |    272 | 2011-06-27 18:58:05 | mythtv   |      | 4 commercial breaks          | 2011-06-27 14:00:15 |
14| 9414 |   1082 | 2011-06-27 14:00:00 | 2011-06-27 14:30:03 |    2 |    0 |     0 |    304 | 2011-06-27 18:25:56 | mythtv   |      | Failed with exit status 134  | 2011-06-27 14:30:03 |
15| 9415 |   1082 | 2011-06-27 14:30:00 | 2011-06-27 15:00:15 |    2 |    0 |     0 |      4 | 2011-06-28 01:05:41 | mythtv   |      | 99% Completed @ 95.6546 fps. | 2011-06-27 15:00:15 |
16| 9416 |   1061 | 2011-06-27 17:30:00 | 2011-06-27 18:00:15 |    2 |    0 |     0 |    272 | 2011-06-27 18:38:00 | mythtv   |      | 4 commercial breaks          | 2011-06-27 18:00:15 |
17| 9417 |   1061 | 2011-06-27 17:58:00 | 2011-06-27 18:30:15 |    2 |    0 |     0 |    272 | 2011-06-27 18:50:05 | mythtv   |      | 3 commercial breaks          | 2011-06-27 18:30:15 |
18| 9405 |   1181 | 2011-06-26 19:30:00 | 2011-06-26 20:00:15 |    2 |    0 |     0 |    272 | 2011-06-26 20:21:19 | mythtv   |      | 4 commercial breaks          | 2011-06-26 20:00:15 |
19| 9406 |   3735 | 2011-06-26 22:00:00 | 2011-06-26 22:59:59 |    2 |    0 |     0 |    272 | 2011-06-26 23:42:37 | mythtv   |      | 6 commercial breaks          | 2011-06-26 22:59:59 |
20| 9407 |   3738 | 2011-06-26 23:00:00 | 2011-06-27 00:01:16 |    2 |    0 |     0 |    272 | 2011-06-27 00:55:51 | mythtv   |      | 2 commercial breaks          | 2011-06-27 00:01:16 |
21| 9408 |   1082 | 2011-06-23 14:30:00 | 2011-06-27 13:50:39 |    2 |    0 |     1 |    304 | 2011-06-27 13:58:41 | mythtv   |      | Failed with exit status 134  | 2011-06-27 13:50:39 |
22| 9409 |   1082 | 2011-06-23 14:00:00 | 2011-06-27 13:50:53 |    2 |    0 |     1 |    304 | 2011-06-27 14:00:54 | mythtv   |      | Failed with exit status 134  | 2011-06-27 13:50:53 |
23| 9418 |   2050 | 2011-06-27 22:00:00 | 2011-06-27 22:32:15 |    2 |    0 |     0 |    272 | 2011-06-27 22:43:44 | mythtv   |      | 3 commercial breaks          | 2011-06-27 22:32:15 |
24| 9419 |   1042 | 2011-06-27 23:00:00 | 2011-06-28 00:00:16 |    2 |    0 |     0 |    272 | 2011-06-28 00:54:32 | mythtv   |      | 6 commercial breaks          | 2011-06-28 00:00:16 |
25| 9403 |   1061 | 2011-06-26 17:00:00 | 2011-06-26 17:30:05 |    2 |    0 |     0 |    272 | 2011-06-26 17:42:11 | mythtv   |      | 3 commercial breaks          | 2011-06-26 17:30:05 |
26+------+--------+---------------------+---------------------+------+------+-------+--------+---------------------+----------+------+------------------------------+---------------------+
2721 rows in set (0.00 sec)
28
29mysql> quit