<br>
<div class="gmail_quote">On Wed, Dec 17, 2008 at 3:51 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On 12/17/2008 02:27 PM, Stackpole, Chris wrote:<br>> From: Greg Hermsen<br>
<div class="Ih2E3d">>> I've had mixed results with commercial skip. The promise is shows is big enough that I haven't given up on it yet. Commercial skipping will work well for a day or two, then at some point where MythTV should skip a commercial, the video freezes and the audio goes into a high-speed,<br>
>> unintelligible mode. I'm not able to stop it. After anywhere from 10 - 20 minutes MythTV returns to the listing of recorded shows. I assume that when the audio reaches the ended of the recorded program is when MythTV unfreezes from commerial skip<br>
>><br>>> Has anybody else seen this? Is there something I can do to fix this?<br></div>
<div class="Ih2E3d">> I had this issue sometime ago with Myth .20 something and Knoppmyth. I<br>> checked the log files and found an error (don't remember which one right<br>> now)<br><br></div>I'll fill in the blank for you:</blockquote>
<div> </div>
<div>Thanks Mike. I give this a try.</div>
<div> </div>
<div>Chris, I am running Mythbuntu 0.21.20080304-1 18704</div>
<div> </div>
<div>Thanks again.</div>
<div>Greg</div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span id=""></span><br><br>Error was: Driver error was [2/145]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>
Table './mythconverg/recordedseek' is marked as crashed and should be<br>repaired<br>
<div class="Ih2E3d"><br>> and after a google search I found a lot of people had that error<br>> and that it had been fixed. I switched over to Mythbuntu and MythTV .21<br>> the problem went away.<br>><br><br>
</div>Probably because MythBuntu packagers have set up MythBuntu systems to<br>automatically run optimize_mythdb.pl.<br><br>So, OP, you should run optimize_mythdb.pl (while mythbackend is running)<br>to fix the crashed table (and, really, it doesn't hurt to run it in a<br>
cron job at least once per month--though once per day works great at<br>fixing crashed tables before you notice them). You can find<br>optimize_mythdb.pl in the contrib directory of the source distribution,<br>but most packagers include it in the install somewhere (use locate or<br>
ask someone who's using your distro for more specific info).<br><br>Once you repair the database with optimize_mythdb.pl, you may still see<br>some recordings with the same problem. For them, you have 2 choices:<br>1) delete the recording (and re-record it if desired) or 2)<br>
<a href="http://www.mythtv.org/wiki/index.php/Repairing_the_Seektable" target="_blank">http://www.mythtv.org/wiki/index.php/Repairing_the_Seektable</a> .<br>Basically, the seektables of /any/ recordings you made while the table<br>
was crashed will be corrupt/need repairing. The seektables of /some/<br>recordings that were made before the table crashed /could/ be<br>corrupt/need repairing. You'll have to run mythtranscode --buildindex<br>(for MPEG-2 recordings) or mythcommflag --rebuild (for NUV recordings,<br>
including software-encoded recordings from frame grabbers or<br>lossy-transcoded recordings) on each affected recording individually.<br><br>Mike<br>_______________________________________________<br>mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote>
</div><br>