[mythtv-users] problems with recordedmarkup

Scott Rowe mythgnomer at rowelab.com
Sat Jan 1 11:28:50 EST 2005


Try 

mysqlcheck -u mythtv -pmythtv --analyze mythconverg 

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Micah Wedemeyer
> Sent: Saturday, January 01, 2005 9:36 AM
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] problems with recordedmarkup
> 
> I'm having problems with the recordedmarkup table in the database.
> 
> Something with wrong with jobqueue and recordedmarkup.  
> Commercials were no longer being flagged.  When I tried to 
> look at the tables, I got ERRNO 1016 or something like that 
> (I can't re-create it...see below)  So, I've tried to 
> trouble-shoot the problem.  Here's what has happened so far:
> 
> 1. I tried re-running mythtvsetup and mythfilldatabase.  Both 
> ran but did not fix the problem.
> 
> 2. I tried running repair table on recordedmarkup (using the 
> mysql shell).  It just ran for about 20 minutes and did 
> nothing (that I can tell).  I finally hit Ctrl-C and aborted 
> everything.
> 
> 3. I dropped the jobqueue table, with intent to re-create it. 
>  I then attempted to drop the recordedmarkup table.  However, 
> it will not drop.  The shell just hangs.  I can Ctrl-C and 
> abort, but the table is causing a lot of problems now.
>  Any time I try to access it in any way (desc, select, drop, 
> etc.) the mysql shell hangs.
> 
> Any ideas?
> 
> Thanks,
> Micah
> _______________________________________________
> 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