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

[Hika van den Hoven]

Hoi Mike,

Wednesday, July 29, 2015, 7:00:48 AM, you wrote:

> 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.

Although I still don't know what caused the problem, I have it working
again.
I exported the databases (I have two others).
removed mysql
moved the database directory, just in case
emerged mariadb
configured/optimized mariadb
imported the databases
created the users

And everything is working again. And actually beter. I had performance
problems since May, which seems gone! And watching goes OK without the
recordseek table being filled. So I let it getting filled on use.

Thanks!

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens