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

[Hika van den Hoven]

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 */;




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