[mythtv-users] mythjobqueue reporting "0 commercial break(s)" on one machine only, flagging OK.

Chris chris-ns2 at pgh4.com
Fri Mar 9 21:16:54 UTC 2007


Thanks Matt,

Guess I should have just done that.  I appreciate the prompt reply.  I 
have it configured and it's flagging now.

Matt Rude wrote:
> Chris wrote:
>   
>> 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>
>>     
>
> NA-7 needs an Storagegroup setup.
>
> -Matt
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   


More information about the mythtv-users mailing list