<br><br><div class="gmail_quote">On 9 September 2012 07:55, Sebastian Niehaus <span dir="ltr"><<a href="mailto:niehaus@web.de" target="_blank">niehaus@web.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I suppose, I have an mysql problem which broke my tables. Running<br>
mythtv on Debian Squeeze.<br>
<br>
<br>
,----<br>
| mythtv@ceramic:~$ apt-cache policy mythtv<br>
| mythtv:<br>
| Installiert: 0.24.2-0.0squeeze1<br>
| Kandidat: 0.24.2-0.0squeeze1<br>
| Versionstabelle:<br>
| *** 0.24.2-0.0squeeze1 0<br>
| 500 <a href="ftp://ftp.debian-multimedia.org/" target="_blank">ftp://ftp.debian-multimedia.org/</a> squeeze/main amd64 Packages<br>
| 100 /var/lib/dpkg/status<br>
| mythtv@ceramic:~$<br>
`----<br>
<br>
<br>
When I (re)start mysql I get this error message:<br>
<br>
,----<br>
| root@ceramic:/home/niehaus# ERROR 144 (HY000) at line 1: Table './mythconverg/oldprogram' is marked as crashed and last (automatic?) repair failed<br>
| ERROR 144 (HY000) at line 1: Table './mythconverg/recordedseek' is marked as crashed and last (automatic?) repair failed<br>
`----<br>
<br>
I tried to repair the tables like this:<br>
<br>
<br>
,----<br>
| root@ceramic:/home/niehaus# mysqlcheck --auto-repair --check -u debian-sys-maint -p mythconverg<br>
| Enter password:<br>
| mythconverg.archiveitems OK<br>
| mythconverg.callsignnetworkmap OK<br>
| mythconverg.capturecard OK<br>
| mythconverg.cardinput OK<br>
| mythconverg.channel OK<br>
| mythconverg.channelgroup OK<br>
| mythconverg.channelgroupnames OK<br>
| mythconverg.channelscan OK<br>
| mythconverg.channelscan_channel OK<br>
| mythconverg.channelscan_dtv_multiplex OK<br>
| mythconverg.codecparams OK<br>
| mythconverg.credits OK<br>
| mythconverg.customexample OK<br>
| mythconverg.diseqc_config OK<br>
| mythconverg.diseqc_tree OK<br>
| mythconverg.displayprofilegroups OK<br>
| mythconverg.displayprofiles OK<br>
| mythconverg.dtv_multiplex OK<br>
| mythconverg.dtv_privatetypes OK<br>
| mythconverg.dvdbookmark OK<br>
| mythconverg.dvdinput OK<br>
| mythconverg.dvdtranscode OK<br>
| mythconverg.eit_cache OK<br>
| mythconverg.filemarkup OK<br>
| mythconverg.gallerymetadata OK<br>
| mythconverg.gamemetadata OK<br>
| mythconverg.gameplayers OK<br>
| mythconverg.housekeeping OK<br>
| mythconverg.inputgroup OK<br>
| mythconverg.internetcontent OK<br>
| mythconverg.internetcontentarticles OK<br>
| mythconverg.inuseprograms OK<br>
| mythconverg.jobqueue OK<br>
| mythconverg.jumppoints OK<br>
| mythconverg.keybindings OK<br>
| mythconverg.keyword OK<br>
| mythconverg.music_albumart OK<br>
| mythconverg.music_albums OK<br>
| mythconverg.music_artists OK<br>
| mythconverg.music_directories OK<br>
| mythconverg.music_genres OK<br>
| mythconverg.music_playlists OK<br>
| mythconverg.music_smartplaylist_categories OK<br>
| mythconverg.music_smartplaylist_items OK<br>
| mythconverg.music_smartplaylists OK<br>
| mythconverg.music_songs OK<br>
| mythconverg.music_stats OK<br>
| mythconverg.mythlog OK<br>
| mythconverg.mythweb_sessions OK<br>
| mythconverg.networkiconmap OK<br>
| mythconverg.newssites OK<br>
| mythconverg.oldfind OK<br>
| mythconverg.oldprogram OK<br>
| mythconverg.oldrecorded OK<br>
| mythconverg.people OK<br>
| mythconverg.pidcache OK<br>
| mythconverg.playgroup OK<br>
| mythconverg.powerpriority OK<br>
| mythconverg.profilegroups OK<br>
| mythconverg.program OK<br>
| mythconverg.programgenres OK<br>
| mythconverg.programrating OK<br>
| mythconverg.recgrouppassword OK<br>
| mythconverg.record OK<br>
| mythconverg.record_tmp OK<br>
| mythconverg.recorded OK<br>
| mythconverg.recordedcredits OK<br>
| mythconverg.recordedfile OK<br>
| mythconverg.recordedmarkup OK<br>
| mythconverg.recordedprogram OK<br>
| mythconverg.recordedrating OK<br>
|<br>
| mythconverg.recordedseek<br>
| warning : Table is marked as crashed and last repair failed<br>
| warning : Size of indexfile is: 104750080 Should be: 1024<br>
| error : Record-count is not ok; is 3277130 Should be: 0<br>
| warning : Found 3277130 key parts. Should be: 0<br>
| error : Corrupt<br>
| mythconverg.recordingprofiles OK<br>
| mythconverg.recordmatch OK<br>
| mythconverg.romdb OK<br>
| mythconverg.schemalock OK<br>
| mythconverg.settings OK<br>
| mythconverg.storagegroup OK<br>
| mythconverg.tvchain OK<br>
| mythconverg.tvosdmenu OK<br>
| mythconverg.upnpmedia OK<br>
| mythconverg.videocast OK<br>
| mythconverg.videocategory OK<br>
| mythconverg.videocountry OK<br>
| mythconverg.videogenre OK<br>
| mythconverg.videometadata OK<br>
| mythconverg.videometadatacast OK<br>
| mythconverg.videometadatacountry OK<br>
| mythconverg.videometadatagenre OK<br>
| mythconverg.videosource OK<br>
| mythconverg.videotypes OK<br>
| mythconverg.weatherdatalayout OK<br>
| mythconverg.weatherscreens OK<br>
| mythconverg.weathersourcesettings OK<br>
| mythconverg.websites OK<br>
|<br>
| Repairing tables<br>
|<br>
|<br>
`----<br>
<br>
<br>
The mysqlckeck command gets stuck here and shows no further reaction.<br>
Any idea how to fix this?<br>
<br>
<br>
I know this is more an mySQL question than a mythtv question but if I<br>
get a hint how to "reset" this specific table, I dont't mind very much<br>
losing its data ....<br>
<br>
<br>
<br>
<br>
<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> gets some errors too, I don't know if they are of any<br>
relevance ...<br>
<br>
<br>
,----<br>
| mythtv@ceramic:~$ /usr/share/doc/mythtv-backend/contrib/maintenance/<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a><br>
| DBD::mysql::st execute failed: Got error 28 from storage engine at /usr/share/perl5/MythTV.pm line 875.<br>
| DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/perl5/MythTV.pm line 876.<br>
| Repaired/Optimized: `mythconverg`.`archiveitems`<br>
| Analyzed: `mythconverg`.`archiveitems`<br>
| Repaired/Optimized: `mythconverg`.`callsignnetworkmap`<br>
| Analyzed: `mythconverg`.`callsignnetworkmap`<br>
| Repaired/Optimized: `mythconverg`.`capturecard`<br>
|<br>
| [...]<br>
|<br>
`----<br>
<br>
<br>
<br>
Thanks,<br>
<br>
<br>
Sebastian<br>
<br>
<br></blockquote><div><br>mysqlcheck --repair mythconverg<br><br>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.<br>
<br>Cheers,<br><br>Anthony<br></div></div><br>