[mythtv-users] unable to watch recordings
sarvin
sarvinc at fastmail.fm
Fri Jun 23 16:14:45 UTC 2006
On Jun 23, 2006, at 2:57 AM, Steve Daniels wrote:
>
>> -----Original Message-----
>> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
>> bounces at mythtv.org] On Behalf Of sarvin
>> Sent: 23 June 2006 06:20
>> To: Discussion about mythtv
>> Subject: [mythtv-users] unable to watch recordings
>>
>> Unfortunately I lost power to my MythTV and the computer was shutdown
>> improperly. For some reason I'm not able to watch recorded or live
>> T.V. any longer. The logs look fine, mysql and mythbackend both start
>> fine as well. I'm not sure what the problem is or where to look. Any
>> advice would be greatly appreciated.
>
> You say the logs look fine, did you also look at the mysql logs and
> check
> the tables, just because it starts doesn't mean mysql has clean and
> tidy
> uncorrupted tables ready for mythbackend to play with.
>
> HTH
>
> Steve
mysqld.err produces:
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060622 21:05:07 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 55130.
InnoDB: Doing recovery: scanned up to log sequence number 0 55130
InnoDB: Last MySQL binlog file position 0 79, file name ./Athlon64-
bin.000315
060622 21:05:08 InnoDB: Flushing modified pages from the buffer pool...
060622 21:05:08 InnoDB: Started; log sequence number 0 55130
/usr/sbin/mysqld: ready for connections.
Version: '4.1.14-log' socket: '/var/run/mysqld/mysqld.sock' port:
3306 Gentoo Linux mysql-4.1.14-r1
060622 21:05:20 [ERROR] /usr/sbin/mysqld: Can't open file:
'mythlog.MYI' (errno: 145)
060622 21:05:20 [ERROR] /usr/sbin/mysqld: Can't open file:
'mythlog.MYI' (errno: 145)
060623 0:00:20 [ERROR] /usr/sbin/mysqld: Can't open file:
'mythlog.MYI' (errno: 145)
060623 0:00:20 [ERROR] /usr/sbin/mysqld: Can't open file:
'mythlog.MYI' (errno: 145)
060623 0:02:15 [Note] /usr/sbin/mysqld: Normal shutdown
060623 0:02:15 InnoDB: Starting shutdown...
060623 0:02:18 InnoDB: Shutdown completed; log sequence number 0 55166
060623 0:02:18 [Note] /usr/sbin/mysqld: Shutdown complete
060623 0:02:23 InnoDB: Started; log sequence number 0 55166
/usr/sbin/mysqld: ready for connections.
Version: '4.1.14-log' socket: '/var/run/mysqld/mysqld.sock' port:
3306 Gentoo Linux mysql-4.1.14-r1
060623 0:04:09 [Note] /usr/sbin/mysqld: Normal shutdown
Other than that, everything else appears normal.
I've run optimize_mythdb.pl in the hopes that that might solve the
problem. How would I check the tables?
More information about the mythtv-users
mailing list