[mythtv-users] mysql problems and how to fix them ...
Sebastian Niehaus
niehaus at web.de
Sat Sep 8 21:55:21 UTC 2012
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120908/23d71ec8/attachment.sig>
More information about the mythtv-users
mailing list