[mythtv-users] mythjobqueue reporting "0 commercial break(s)" on one machine only, flagging OK.
Chris
chris-ns2 at pgh4.com
Fri Mar 9 20:35:05 UTC 2007
What am I missing?
The show is flagged properly but the indication in mythweb and the
jobqueue table is 0 breaks.
mysql is running only on the backend
I ran mythtv-setup on all machines
all storage is on the backend as of now and shared via nfs
I forgot to define a storage group on the problem machine but it does
find the files so i left it.
mysql> select * from storagegroup;
+----+-----------+----------+---------------+
| id | groupname | hostname | dirname |
+----+-----------+----------+---------------+
| 1 | Default | mythback | /mythdata |
| 2 | Default | curly | /mnt/mythdata |
+----+-----------+----------+---------------+
2 rows in set (0.00 sec)
mysql>
I shutdown mythjobqueue on this problem machine and ran mythbackend
which complained that I did not have any capture cards by flagged
commercials just fine.
I shutdown mythbackend on my slave backend and ran mythjobqueue and it
worked fine.
I'm running svn from March 4th:
mythtv at na-7 ~ $ mythbackend --version
Library API version: 0.20.20070124-1
Source code version: 12929
Options compiled in:
linux release using_xvmcw using_lmsensors using_v4l using_oss
using_alsa using_ivtv using_dbox2 using_hdhr using_iptv using_live
using_lirc using_joystick_menu using_x11 using_xv using_xrandr
using_xvmc using_xvmc_vld using_frontend using_backend using_bindings_perl
mythtv at na-7 ~ $
mythtv at na-7 ~ $ la `which mythjobqueue`
-rwxr-xr-x 1 root root 23K Mar 4 13:57 /usr/local/bin/mythjobqueue
mythtv at na-7 ~ $
The problem machine na-7 was my 1st myth box and started out running
both the backend and frontend.
I then brought up mythback and made it backend and frontend leaving na-7
as a frontend only.
I built curly as a frontend only machine then in the last week started
running it as a slave backend with 1 capture card.
I force flagging on this machine only:
mysql> select * from settings where value = 'JobAllowCommFlag';
| value | data | hostname |
+------------------+------+----------+
| JobAllowCommFlag | 0 | curly |
| JobAllowCommFlag | 0 | mythback |
| JobAllowCommFlag | 1 | NA-7 |
+------------------+------+----------+
3 rows in set (0.00 sec)
mysql>
NA-7 always shows "0 commercial break(s)" except for the one instance
wher I was running mythbackend on it.
mysql> select id,type,flags,status,hostname,comment,starttime,inserttime
from jobqueue order by inserttime;
+-------+------+-------+--------+----------+-----------------------------+---------------------+---------------------+
| id | type | flags | status | hostname | comment
| starttime | inserttime |
+-------+------+-------+--------+----------+-----------------------------+---------------------+---------------------+
| 11203 | 2 | 0 | 272 | mythback | 3 commercial break(s)
| 2007-03-07 09:31:00 | 2007-03-07 10:01:03 |
| 11204 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 14:29:00 | 2007-03-07 15:00:59 |
| 11205 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 15:59:00 | 2007-03-07 16:31:00 |
| 11206 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 16:59:00 | 2007-03-07 18:30:02 |
| 11208 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 18:30:00 | 2007-03-07 19:01:00 |
| 11209 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 19:59:00 | 2007-03-07 21:00:02 |
| 11210 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 20:29:00 | 2007-03-07 21:00:04 |
| 11211 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 20:00:00 | 2007-03-07 21:00:05 |
| 11212 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 21:00:00 | 2007-03-07 21:31:01 |
| 11213 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 21:00:00 | 2007-03-07 22:00:03 |
| 11215 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 22:00:00 | 2007-03-07 23:01:01 |
| 11216 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-07 21:58:00 | 2007-03-07 23:02:01 |
| 11217 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 00:59:00 | 2007-03-08 02:09:03 |
| 11218 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 02:09:00 | 2007-03-08 03:17:58 |
| 11219 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 03:59:00 | 2007-03-08 05:00:56 |
| 11222 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 11:59:00 | 2007-03-08 12:30:57 |
| 11223 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 07:00:42 | 2007-03-08 13:35:10 |
| 11226 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 14:01:28 | 2007-03-08 14:46:26 |
| 11228 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 16:59:00 | 2007-03-08 18:30:02 |
| 11229 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 17:59:00 | 2007-03-08 18:31:00 |
| 11230 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 18:30:00 | 2007-03-08 19:00:59 |
| 11231 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 19:59:00 | 2007-03-08 21:00:02 |
| 11232 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 19:59:00 | 2007-03-08 21:00:59 |
| 11234 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 21:30:00 | 2007-03-08 22:01:02 |
| 11235 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 20:59:00 | 2007-03-08 22:31:00 |
| 11236 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 22:01:00 | 2007-03-08 22:31:03 |
| 11237 | 2 | 0 | 272 | curly | 4 commercial break(s)
| 2007-03-08 22:31:00 | 2007-03-08 23:01:00 |
| 11238 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-08 22:00:00 | 2007-03-08 23:01:11 |
| 11239 | 2 | 0 | 272 | curly | 6 commercial break(s)
| 2007-03-01 19:59:00 | 2007-03-09 00:39:40 |
| 11240 | 2 | 4 | 272 | na-7 | Finished, 3 break(s) found.
| 2007-02-15 19:59:00 | 2007-03-09 00:44:57 |
| 11241 | 2 | 0 | 272 | na-7 | 0 commercial break(s)
| 2007-03-02 19:30:00 | 2007-03-09 01:21:41 |
| 11243 | 2 | 0 | 272 | curly | 2 commercial break(s)
| 2007-02-15 19:59:00 | 2007-03-09 02:03:18 |
| 11244 | 2 | 0 | 272 | curly | 5 commercial break(s)
| 2007-03-02 20:59:00 | 2007-03-09 02:03:33 |
| 11245 | 2 | 0 | 272 | curly | 6 commercial break(s)
| 2007-03-08 21:00:00 | 2007-03-09 02:03:46 |
| 11246 | 2 | 0 | 272 | curly | 6 commercial break(s)
| 2007-03-09 03:59:00 | 2007-03-09 05:01:01 |
| 11247 | 2 | 0 | 272 | curly | 6 commercial break(s)
| 2007-03-09 05:59:00 | 2007-03-09 07:01:00 |
| 11248 | 2 | 0 | 272 | curly | 6 commercial break(s)
| 2007-03-09 05:59:00 | 2007-03-09 07:01:00 |
+-------+------+-------+--------+----------+-----------------------------+---------------------+---------------------+
37 rows in set (0.00 sec)
mysql>
Here is a "for instance":
mysql> select module,logdate,host,RIGHT(message,8) as Message,details
from mythlog where module = 'commflag' and details like '%Mar 8 22:01%'
order by logdate;
+----------+---------------------+------+----------+--------------------------------------------------------------------------------------------------------+
| module | logdate | host | Message | details
|
+----------+---------------------+------+----------+--------------------------------------------------------------------------------------------------------+
| commflag | 2007-03-08 23:11:16 | na-7 | Starting | The Office "The
Convict" recorded from channel 1012 at Thu Mar 8 22:01:00 2007
|
| commflag | 2007-03-08 23:36:38 | na-7 | Finished | The Office "The
Convict" recorded from channel 1012 at Thu Mar 8 22:01:00 2007 (0
commercial break(s)) |
+----------+---------------------+------+----------+--------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
mysql> select * from recordedmarkup where chanid = '1012' and starttime
= '2007-03-08 22:01:00' order by starttime,chanid,mark;
+--------+---------------------+-------+--------+------+
| chanid | starttime | mark | offset | type |
+--------+---------------------+-------+--------+------+
| 1012 | 2007-03-08 22:01:00 | 0 | NULL | -3 |
| 1012 | 2007-03-08 22:01:00 | 15578 | NULL | 4 |
| 1012 | 2007-03-08 22:01:00 | 20718 | NULL | 5 |
| 1012 | 2007-03-08 22:01:00 | 28107 | NULL | 4 |
| 1012 | 2007-03-08 22:01:00 | 34694 | NULL | 5 |
| 1012 | 2007-03-08 22:01:00 | 48007 | NULL | 4 |
| 1012 | 2007-03-08 22:01:00 | 53722 | NULL | 5 |
+--------+---------------------+-------+--------+------+
7 rows in set (0.00 sec)
mysql>
mysql> select * from settings where value like '%Server%';
+------------------------------------------------------------+--------------------------------------+----------+
| value | data
| hostname |
+------------------------------------------------------------+--------------------------------------+----------+
| BackendServerIP |
192.168.0.250 | na-7 |
| BackendServerPort | 6543
| NA-7 |
| MasterServerIP |
192.168.0.245 | NULL |
| MasterServerPort | 6543
| NULL |
| ServerHaltCommand | sudo
/sbin/halt -p | NULL |
| BackendServerIP |
192.168.0.245 | mythback |
| BackendServerPort | 6543
| mythback |
| upnp:UDN:urn:schemas-upnp-org:device:MediaServer:1 |
07fc00a2-2de2-403c-8d13-62b1f6ad031d | mythback |
| upnp:UDN:urn:schemas-mythtv-org:device:MasterMediaServer:1 |
a3f1f29a-d58c-4f8c-b23c-b0daf20b3575 | mythback |
| BackendServerIP |
192.168.0.252 | curly |
| BackendServerPort | 6543
| curly |
| upnp:UDN:urn:schemas-mythtv-org:device:SlaveMediaServer:1 |
31581e1b-4cee-4a30-bfc5-56dd5d21fc1e | curly |
| upnp:UDN:urn:schemas-mythtv-org:device:SlaveMediaServer:1 |
385695f5-4ef5-4a79-b2f3-de5bcf9489af | na-7 |
+------------------------------------------------------------+--------------------------------------+----------+
13 rows in set (0.00 sec)
mysql>
Let me now if I should include any additional info and thanks.
More information about the mythtv-users
mailing list