[mythtv-users] mythjobqueue reporting "0 commercial break(s)" on one machine only, flagging OK.
Matt Rude
mythtv at mattrude.com
Fri Mar 9 20:41:09 UTC 2007
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 187 bytes
Desc: OpenPGP digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20070309/a15c4194/attachment.pgp
More information about the mythtv-users
mailing list