[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