[mythtv-users] './mythconverg/recordedseek' is marked as crashed

[Mike Holden]

On 29 July 2015 at 13:28, Hika van den Hoven <hikavdh at gmail.com> wrote:

> Hoi Bill,
>
> Wednesday, July 29, 2015, 4:55:17 AM, you wrote:
>
> > On 07/28/2015 09:21 PM, Hika van den Hoven wrote:
> >> Hoi Hika,
> >>
> >> Wednesday, July 29, 2015, 3:50:46 AM, you wrote:
> >>
> >>> Hoi All,
> >>
> >>> It seems my recordedseek table is crashed. What do I do now?
> >>> Backups return empty and optimize_mythdb.pl fails.
> >>> It seems to have happened a few days ago since the last backup with
> >>> content was from almost a week ago.
> >>> For the rest everything works. I can record, watch, schedule. That's
> >>> why I didn't notice at first.
> >>
> >>> I guess I somehow have to dump the table and recreate it. Which will
> >>> take a long time. (some 3.4 Tb in recordings )
> >>
> >> OK, now it gets really weird. It seems that optimize_mythdb.pl crashes
> >> the table.
> >> I emptied the table.
> >> Restarted mysql end mythbackend
> >> I could see the table again.
> >> Rebuilding a recording works.
> >> I could do a backup again.
> >> And then just to be sure I ran optimize_mythdb.pl and I'm back where I
> >> started. "last repair failed at optimize_mythdb.pl line 38"
> >>
> >> So I'm doing it again and for now remove optimize_mythdb.pl from cron.
> >>
>
> > Isn't line 38 the 'new' "ALTER TABLE recordedseek ORDER BY chanid,
> starttime, type"
> > code? You could temporarily comment out that part just to prove it
> is/isn't causing
> > the problem.
>
> This is line 37 - 40:
> # Defragement seek table
>     if ($dbh->do("ALTER TABLE `recordedseek` ORDER BY chanid, starttime,
> type")) {
>         print "Defragmented: recordedseek\n";
>     }
>
> If I remark it out. the table still gets crashed by optimize_mythdb.pl
>
> I tried dropping and reloading. But the reload query is from the
> earlier emptied table, so I'm not sure if it is OK.
>
> - phpMyAdmin SQL Dump
> -- version 4.1.14.3
> -- http://www.phpmyadmin.net
> --
> -- Machine: localhost
> -- Gegenereerd op: 29 jul 2015 om 02:11
> -- Serverversie: 5.6.24-log
> -- PHP-versie: 5.5.23-pl0-gentoo
>
> SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
> SET time_zone = "+00:00";
>
>
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!40101 SET NAMES utf8 */;
>
> --
> -- Databank: `mythconverg`
> --
>
> -- --------------------------------------------------------
>
> --
> -- Tabelstructuur voor tabel `recordedseek`
> --
>
> DROP TABLE IF EXISTS `recordedseek`;
> CREATE TABLE IF NOT EXISTS `recordedseek` (
>   `chanid` int(10) unsigned NOT NULL DEFAULT '0',
>   `starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
>   `mark` mediumint(8) unsigned NOT NULL DEFAULT '0',
>   `offset` bigint(20) unsigned NOT NULL,
>   `type` tinyint(4) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`)
> ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
>
> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
>
>
Check the mysql log file. There may be further information in there?

Could be hardware issues, full disk etc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150729/aaf44a47/attachment.html>