LinHES Forums
http://forum.linhes.org/

mythtv.log errors.. Can't open file: 'recordedprogram.MYI.'
http://forum.linhes.org/viewtopic.php?f=6&t=10878
Page 1 of 1

Author:  Irishcream [ Tue Jul 18, 2006 8:07 am ]
Post subject:  mythtv.log errors.. Can't open file: 'recordedprogram.MYI.'

I'm getting this odd error in my mythbackend.log file.... and it's piling up!

Code:
more mythbackend.log | grep error -A 2

Driver error was [2/1016]:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'recordedprogram.MYI'. (errno: 145)

--
strange error flushing buffer ...
2006-07-09 14:00:06.202 Commercial Flagging Starting for MythBusters "Exploding Toilet" recorded from channel 5057 at Sun Jul 9 14:00:00 2006
2006-07-09 14:00:08.878 Using runtime prefix = /usr


permissions should be fine... why can't it open this file?

Code:
ls -l /var/lib/mysql/mythconverg/recordedprogram.MYD
-rw-rw----  1 mysql mysql 20020 Jun 19 08:55 /var/lib/mysql/mythconverg/recordedprogram.MYD


mysql was a lot bigger... but i already fixed that log file. and I couldnt find any errors in it.

Code:
du -h /var/log
1.6M    /var/log/apache
4.0K    /var/log/apache-perl
1.4M    /var/log/exim4
24K     /var/log/gdm
4.0K    /var/log/isdn
22M     /var/log/mysql
738M    /var/log/mythtv
4.0K    /var/log/news
292K    /var/log/ntpstats
44K     /var/log/samba
4.0K    /var/log/webmin/diffs
8.0K    /var/log/webmin
777M    /var/log


So basically my / partition fills up and mythtv dies every few weeks!

any help?

Author:  tjc [ Tue Jul 18, 2006 7:10 pm ]
Post subject: 

Sounds like the last time you ran out of disk space was just before it tried to update the index file (if memory serves .myd is the data, and .myi is the index). You might be able to recover the DB following Cecil's sticky db repair posting.

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/