[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