[mythtv-users] Problem with latest run of optimize_mythdb.pl

[Hika van den Hoven]

Hoi Craig,

Sunday, December 27, 2015, 5:18:24 PM, you wrote:

> I normally run optimize_mythdb.pl once a day to keep the database in good
> condition.  Today's run reported an error:

> DBD::mysql::db do failed: Table './mythconverg/recordedseek' is marked as
> crashed and last (automatic?) repair failed at
> /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl line
> 38.

> I manually re-ran it and got the same result.  Short of restoring
> yesterday's backup of the database (which would mean a loss of data for
> recordings done in the last day), is there anything else to do?  I can
> manage mysql commands, but I don't do it routinely, so any direct
> intervention in the database would need to be clearly detailed.

> If the best approach is to restore yesterday's DB backup, is there anything
> to be done to recover data about the recordings that were done since the
> backup?  Maybe I just need to run find-orphans or something else, or should
> I extract data from the tables in the current database to re-enter into the
> restored instance?  (That last would definitely be something I'd need help
> and guidance on performing.)

> Advice?

> --
> Craig.

The recordedseek table is by far the biggest in the database but
recreatable. It is the table that enables the easy skipping through
any recording, keeps any cut points etc. Recreating though will take a
lot of time. To rebuild for a recording you use:
mythcommflag --rebuild -f <FileName>
I have setup a userjob to do this.
mythcommflag --rebuild -f %FILE% -V %VERBOSELEVEL%
or:
mythcommflag --rebuild -j %JOBID% -V %VERBOSELEVEL%

You then can rebuild at need, the job will show in the menu on your
frontend and in mythweb. Every rebuild, depending on length and
pc-power takes a few minutes.

So you can choose to clear this table and keep all other data intact.

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