[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