View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 2 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Tue Jul 18, 2006 8:07 am 
Offline
Joined: Thu Dec 29, 2005 12:56 am
Posts: 87
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?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 18, 2006 7:10 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 20 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu