[mythtv-users] Mythfilldatabase running every 5 minutes

John Taggart john at lackof.org
Wed May 28 04:32:03 UTC 2008


Here's some new developments,
/var/log/daemon.log shows

May 25 07:10:15 localhost mysqld[2707]: 080525  7:10:15 [ERROR] 
/usr/sbin/mysqld
: Table './mythconverg/housekeeping' is marked as crashed and should be 
repaired

but

sh-3.1$ mysqlcheck -r -u root -p mythconverg
Enter password:
mythconverg.archiveitems                           OK
mythconverg.callsignnetworkmap                     OK
mythconverg.capturecard                            OK
mythconverg.cardinput                              OK
mythconverg.channel                                OK
mythconverg.codecparams                            OK
mythconverg.credits                                OK
mythconverg.customexample                          OK
mythconverg.diseqc_config                          OK
mythconverg.diseqc_tree                            OK
mythconverg.displayprofilegroups                   OK
mythconverg.displayprofiles                        OK
mythconverg.dtv_multiplex                          OK
mythconverg.dtv_privatetypes                       OK
mythconverg.dvdbookmark                            OK
mythconverg.dvdinput                               OK
mythconverg.dvdtranscode                           OK
mythconverg.eit_cache                              OK
mythconverg.favorites                              OK
mythconverg.filemarkup                             OK
mythconverg.gallerymetadata                        OK
mythconverg.gamemetadata                           OK
mythconverg.gameplayers                            OK
mythconverg.inputgroup                             OK
mythconverg.inuseprograms                          OK
mythconverg.jobqueue                               OK
mythconverg.jumppoints                             OK
mythconverg.keybindings                            OK
mythconverg.keyword                                OK
mythconverg.mamemetadata                           OK
mythconverg.mamesettings                           OK
mythconverg.movies_movies                          OK
mythconverg.movies_showtimes                       OK
mythconverg.movies_theaters                        OK
mythconverg.music_albumart                         OK
mythconverg.music_albums                           OK
mythconverg.music_artists                          OK
mythconverg.music_directories                      OK
mythconverg.music_genres                           OK
mythconverg.music_playlists                        OK
mythconverg.music_smartplaylist_categories         OK
mythconverg.music_smartplaylist_items              OK
mythconverg.music_smartplaylists                   OK
mythconverg.music_songs                            OK
mythconverg.music_stats                            OK
mythconverg.musicmetadata                          OK
mythconverg.musicplaylist                          OK
mythconverg.mythlog                                OK
mythconverg.mythweb_sessions                       OK
mythconverg.neskeyword                             OK
mythconverg.nestitle                               OK
mythconverg.netflix                                OK
mythconverg.networkiconmap                         OK
mythconverg.newssites                              OK
mythconverg.oldfind                                OK
mythconverg.oldprogram                             OK
mythconverg.oldrecorded                            OK
mythconverg.people                                 OK
mythconverg.phonecallhistory                       OK
mythconverg.phonedirectory                         OK
mythconverg.pidcache                               OK
mythconverg.playgroup                              OK
mythconverg.powerpriority                          OK
mythconverg.profilegroups                          OK
mythconverg.program                                OK
mythconverg.programgenres                          OK
mythconverg.programrating                          OK
mythconverg.recgrouppassword                       OK
mythconverg.record                                 OK
mythconverg.record_tmp                             OK
mythconverg.recorded                               OK
mythconverg.recordedcredits                        OK
mythconverg.recordedfile                           OK
mythconverg.recordedmarkup                         OK
mythconverg.recordedprogram                        OK
mythconverg.recordedrating                         OK
mythconverg.recordedseek                           OK
mythconverg.recordingprofiles                      OK
mythconverg.recordmatch                            OK
mythconverg.romdb                                  OK
mythconverg.schemalock                             OK
mythconverg.settings                               OK
mythconverg.snessettings                           OK
mythconverg.storagegroup                           OK
mythconverg.tvchain                                OK
mythconverg.upnpmedia                              OK
mythconverg.videocast                              OK
mythconverg.videocategory                          OK
mythconverg.videocountry                           OK
mythconverg.videogenre                             OK
mythconverg.videometadata                          OK
mythconverg.videometadatacast                      OK
mythconverg.videometadatacountry                   OK
mythconverg.videometadatagenre                     OK
mythconverg.videosource                            OK
mythconverg.videotypes                             OK
mythconverg.weatherdatalayout
note     : The storage engine for the table doesn't support repair
mythconverg.weatherscreens
note     : The storage engine for the table doesn't support repair
mythconverg.weathersourcesettings
note     : The storage engine for the table doesn't support repair
mythconverg.websites                               OK
sh-3.1$

You'll notice that it conveniently skipped over the 
mythconverg.housekeeping.

That's when I found this thread:
http://www.gossamer-threads.com/lists/mythtv/users/42642#42642

1. Shutdown mysql
2. CD to the data directory that contains the MYI file in question
3. myisamchk -r  myisamchk -r /var/lib/mysql/mythconverg/housekeeping.MYI
4. Restart MySQL
5. Eat some cheese and watch TV.

Now when I run mysqlcheck it checks the mythconverg.housekeeping table.

Strange that mythfilldatabase didn't give any error messages, neither 
did optimize_mythdb.pl, or mysqlcheck.  I wonder what other tables might 
be "hiding" corruption.

Seems to be working at this point.


More information about the mythtv-users mailing list