15
Mar/100
Mar/100
Mediaportal: Repair broken EPG (Corrupted Table)
Yesterday I had some problems with the EPG in my Mediaportal PC. The following symptoms occurred when I tried to open the EPG:
- EPG does not open
- High cpu usage of mysqld
- Eventlog entry in application log source MySQL:
mysqld.exe: Sort aborted
Maye this was caused by some power loss during fetching new EPG data.
Now how to fix it? I don’t want to drop that complete installation so I tried several things to solve the problem. At first I searched the problem in my MySQL installation and upgraded it from 5.0 to 5.1. That did not fix it.
After upgrading the MySQL version I connected to the database locally to check for corrupted tables:
CHECK TABLE `canceledschedule` , `card` , `cardgroup` , `cardgroupmap` , `channel` , `channelgroup` , `channellinkagemap` , `channelmap` , `conflict` , `diseqcmotor` , `favorite` , `groupmap` , `history` , `keyword` , `keywordmap` , `personaltvguidemap` , `program` , `radiochannelgroup` , `radiogroupmap` , `recording` , `satellite` , `schedule` , `server` , `setting` , `timespan` , `tuningdetail` , `tvmoviemapping` , `version`
And in fact I found some corrupted data in the program table. So I repaired it.
REPAIR TABLE `program`
Along the way I optimized alle the tables.
OPTIMIZE TABLE `canceledschedule` , `card` , `cardgroup` , `cardgroupmap` , `channel` , `channelgroup` , `channellinkagemap` , `channelmap` , `conflict` , `diseqcmotor` , `favorite` , `groupmap` , `history` , `keyword` , `keywordmap` , `personaltvguidemap` , `program` , `radiochannelgroup` , `radiogroupmap` , `recording` , `satellite` , `schedule` , `server` , `setting` , `timespan` , `tuningdetail` , `tvmoviemapping` , `version`
Misc
