[mythtv-users] mysql problems and how to fix them ...

Anthony Giggins seven at seven.dorksville.net
Sun Sep 9 02:33:45 UTC 2012


On 9 September 2012 07:55, Sebastian Niehaus <niehaus at web.de> wrote:

> Hi,
>
> I suppose, I have an mysql problem which broke my tables.  Running
> mythtv on Debian Squeeze.
>
>
> ,----
> | mythtv at ceramic:~$ apt-cache policy  mythtv
> | mythtv:
> |   Installiert: 0.24.2-0.0squeeze1
> |   Kandidat:    0.24.2-0.0squeeze1
> |   Versionstabelle:
> |  *** 0.24.2-0.0squeeze1 0
> |         500 ftp://ftp.debian-multimedia.org/ squeeze/main amd64 Packages
> |         100 /var/lib/dpkg/status
> | mythtv at ceramic:~$
> `----
>
>
> When I (re)start mysql I get this error message:
>
> ,----
> | root at ceramic:/home/niehaus# ERROR 144 (HY000) at line 1: Table
> './mythconverg/oldprogram' is marked as crashed and last (automatic?)
> repair failed
> | ERROR 144 (HY000) at line 1: Table './mythconverg/recordedseek' is
> marked as crashed and last (automatic?) repair failed
> `----
>
> I tried to repair the tables like this:
>
>
> ,----
> | root at ceramic:/home/niehaus# mysqlcheck --auto-repair --check -u
> debian-sys-maint -p mythconverg
> | Enter password:
> | mythconverg.archiveitems                           OK
> | mythconverg.callsignnetworkmap                     OK
> | mythconverg.capturecard                            OK
> | mythconverg.cardinput                              OK
> | mythconverg.channel                                OK
> | mythconverg.channelgroup                           OK
> | mythconverg.channelgroupnames                      OK
> | mythconverg.channelscan                            OK
> | mythconverg.channelscan_channel                    OK
> | mythconverg.channelscan_dtv_multiplex              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.filemarkup                             OK
> | mythconverg.gallerymetadata                        OK
> | mythconverg.gamemetadata                           OK
> | mythconverg.gameplayers                            OK
> | mythconverg.housekeeping                           OK
> | mythconverg.inputgroup                             OK
> | mythconverg.internetcontent                        OK
> | mythconverg.internetcontentarticles                OK
> | mythconverg.inuseprograms                          OK
> | mythconverg.jobqueue                               OK
> | mythconverg.jumppoints                             OK
> | mythconverg.keybindings                            OK
> | mythconverg.keyword                                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.mythlog                                OK
> | mythconverg.mythweb_sessions                       OK
> | mythconverg.networkiconmap                         OK
> | mythconverg.newssites                              OK
> | mythconverg.oldfind                                OK
> | mythconverg.oldprogram                             OK
> | mythconverg.oldrecorded                            OK
> | mythconverg.people                                 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
> | warning  : Table is marked as crashed and last repair failed
> | warning  : Size of indexfile is: 104750080      Should be: 1024
> | error    : Record-count is not ok; is 3277130   Should be: 0
> | warning  : Found 3277130 key parts. Should be: 0
> | error    : Corrupt
> | mythconverg.recordingprofiles                      OK
> | mythconverg.recordmatch                            OK
> | mythconverg.romdb                                  OK
> | mythconverg.schemalock                             OK
> | mythconverg.settings                               OK
> | mythconverg.storagegroup                           OK
> | mythconverg.tvchain                                OK
> | mythconverg.tvosdmenu                              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                      OK
> | mythconverg.weatherscreens                         OK
> | mythconverg.weathersourcesettings                  OK
> | mythconverg.websites                               OK
> |
> | Repairing tables
> |
> |
> `----
>
>
> The mysqlckeck command gets stuck here and shows no further reaction.
> Any idea how to fix this?
>
>
> I know this is more an mySQL question than a mythtv question but if I
> get a hint how to "reset" this specific table, I dont't mind very much
> losing its data ....
>
>
>
>
> optimize_mythdb.pl gets some errors too, I don't know if they are of any
> relevance ...
>
>
> ,----
> | mythtv at ceramic:~$ /usr/share/doc/mythtv-backend/contrib/maintenance/
> optimize_mythdb.pl
> | DBD::mysql::st execute failed: Got error 28 from storage engine at
> /usr/share/perl5/MythTV.pm line 875.
> | DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> /usr/share/perl5/MythTV.pm line 876.
> | Repaired/Optimized: `mythconverg`.`archiveitems`
> | Analyzed: `mythconverg`.`archiveitems`
> | Repaired/Optimized: `mythconverg`.`callsignnetworkmap`
> | Analyzed: `mythconverg`.`callsignnetworkmap`
> | Repaired/Optimized: `mythconverg`.`capturecard`
> |
> | [...]
> |
> `----
>
>
>
> Thanks,
>
>
> Sebastian
>
>
>
mysqlcheck --repair mythconverg

should be able to repair it, mysqlcheck may not have been stuck it just may
have been a big table which recordedseek normally is depending how many
recordings you have.

Cheers,

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120909/3cf5c4d6/attachment.html>


More information about the mythtv-users mailing list