[mythtv] Logo detection and TFW buffer exceeded

Craig Treleaven ctreleaven at cogeco.ca
Fri Oct 12 20:06:50 UTC 2012


At 10:07 AM -0700 10/12/12, Chris Pinkham wrote:
>* On Fri Oct 12, 2012 at 09:49:11AM -0400, Craig Treleaven wrote:
>>  >2012-10-12 08:27:25.633142 I [3240/12291] CoreContext
>>  >ClassicCommDetector.cpp:359 (go) - Finding Logo
>
>Logo detection seeks around quite a bit looking at various
>samples within the video.  One possibility may be that it is
>not be using the seektable and is having to read the whole file
>in instad going frame by frame to get to the new position.
>
>Can you check to see if your recordedseek table needs repairing
>with "repair table recordedseek;" in mysql?
>
>During playback, can you skip arounds recordings quickly or is
>that slow?

Thanks Chris.  I run optimize_mythdb.pl daily.  FFW and REW are fast. 
To be sure, I ran the repair you mentioned directly:

>  mysql5 -u mythtv -p -h 192.168.2.222 mythconverg
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1125
Server version: 5.1.65 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> repair table recordedseek;
+--------------------------+--------+----------+----------+
| Table                    | Op     | Msg_type | Msg_text |
+--------------------------+--------+----------+----------+
| mythconverg.recordedseek | repair | status   | OK       |
+--------------------------+--------+----------+----------+
1 row in set (7.55 sec)

I suppose it would have complained if the table was broken.

By chance, I noticed the commit to master from #11061 (Speed up TFW 
recovery after falling behind on writes.)  Is it possible that I'm 
experiencing a consequence of this?  Do you know if that patch is 
going to be back-ported to .25-fixes?

Craig


More information about the mythtv-dev mailing list