After several months of use, Live TV suddenly stopped working. Upon looking at the logs, there seems to be a problem with one of the mysql tables.


From mythbackend.log:

~~~~~~~~~~~~~~~~~~~

2006-08-28 19:58:20.880 TVRec(1): Changing from None to WatchingLiveTV 2006-08-28 19:58:21.496 DB Error (Chain: AppendNewProgram): Query was: INSERT INTO tvchain (chanid, starttime, endtime, chainid, chainpos, discontinuity, watching, hostprefix, cardtype, channame, input) VALUES('1025', '2006-08-28T19:58:21', '2006-08-28T20:00:00', 'live-mythtv-2006-08-28T19:58:20', 0, 0, 0, 'myth://127.0.0.1:6543/', 'MPEG', '25', 'Tuner 0' ); Driver error was [2/1016]: QMYSQL3: Unable to execute query Database error was: Can't open file: 'tvchain.MYI'. (errno: 145) 2006-08-28 19:58:21.645 TVRec(1): Changing from WatchingLiveTV to None 2006-08-28 19:58:22.330 DB Error (Chain: FinishedRecording): Query was: UPDATE tvchain SET endtime = '2006-08-28T19:58:22' WHERE chanid = '1025' AND starttime = '2006-08-28T19:58:21' ; Driver error was [2/1016]: QMYSQL3: Unable to execute query Database error was: Can't open file: 'tvchain.MYI'. (errno: 145)

~~~~~~~~~~~~~~~~~~


I know this might not be specifcally a mythtv issue, but can anybody help my diagnose this problem?

I already checked the file and it exists, but thats all I know.

Everything else functions normally except LiveTV.

-Scott

- Check your disk space. There's a logfile rotattion glitch in R5C7. The usual culprit is "/var/log/mysql/mysql.log".

- Follow Cecil's DB repair sticky posting here: http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043

wow, mysql.log was 1.6 gigs....still though I was only at 86% capacity for that drive. I am going to look at the post you mentioned now...

That did it! Following Cecil's thread on how to repair the table did the trick.

Was the large logfile the root cause here? It was large but the drive was not full. However, I guess it could have been at some time, before I deleted some recordings.


Thank you for your help!