View unanswered posts    View active topics

Board index KnoppMyth General

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
Willo
PostPosted: Wed Jan 04, 2006 7:35 pm 
Offline
Joined: Sun Apr 03, 2005 2:45 pm
Posts: 22
Location: Lees Summit MO
Somehow I have hosed my channel table and am unable to repair it. While running mythfilldatabase I got the following error:


Quote:
2006-01-04 19:16:12.437 DB Error (checking existing program data):
Query was:
SELECT COUNT(*) FROM program LEFT JOIN channel USING (chanid) WHERE sourceid = 1 AND starttime >= DATE_ADD(CURRENT_DATE(), INTERVAL '13 18' DAY_HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL 14 DAY)
Driver error was [2/1017]:
QMYSQL3: Unable to execute query
Database error was:
Can't find file: 'channel.MYI' (errno: 2)

Data is already present for Tue Jan 17 2006, skipping
2006-01-04 19:16:12.466 New DB connection, total: 4
Adjusting program database end times...
0 replacements made.
2006-01-04 19:16:12.483 mythfilldatabase: Listings Download Finished
Marking repeats...found 0
Unmarking repeats from grabber that fall within our new episode window...found 0
2006-01-04 19:16:12.506 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)


In sql manager I tried

Code:
repair table channel;


but recieve this error:

Output from SQL command repair table channel; ..

Table Op Msg_type Msg_text
mythconverg.channel repair error Can't find file: 'channel.MYI' (errno: 2)

any suggestions for repairing or reloading the table?

_________________
websites: http://www.willoliver.com http://healthcareitforum.com


Last edited by Willo on Wed Jan 04, 2006 9:39 pm, edited 1 time in total.
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Wed Jan 04, 2006 9:23 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Look for Cecil's sticky post about repairing you DB. http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043

If it's REALLY fubar you might be able to do a backup, and an auto-upgrade. Make sure to verify that the backup worked before you start.
Top
 Profile  
 
Willo
 Post subject:
PostPosted: Wed Jan 04, 2006 9:47 pm 
Offline
Joined: Sun Apr 03, 2005 2:45 pm
Posts: 22
Location: Lees Summit MO
that was a horrible chain of events....

here's what happened. Turns out I was having an issue with Zap2it not connecting a couple days ago. I shut my box down while it was trying to download which caused some corruption with the channel table. For the next two days cron was trying to run which filled my logs and filled the drive.

Fix...

cleaned the logs by moving to another drive (just in case)

ran mythtv-setup and removed my channel data and reloaded

this seems to have repaired the table and things are looking good....

lesson 1 : rotate logs
lesson 2 : change the time zap2it downloads data

;)

_________________
websites: http://www.willoliver.com http://healthcareitforum.com
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 


Board index KnoppMyth General

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 18 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:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu