[mythtv-users] Seek Table Problem

[HP-mini]

On Tue, 2013-08-13 at 09:41 -0400, Ken Mandelberg wrote:
> After a system crash new recordings have a messed up seek table. I ran a 
> mythcommflag rebuild on one of them and get a lot of
> 
> --
> 
> 2013-08-13 09:35:30.333242 E  DB Error (delta position map insert):
> Query was:
> INSERT INTO recordedseek (chanid, starttime, mark, type, offset)  VALUES 
> ( ? , ? , ? , ? , ? )
> Bindings were:
> :CHANID=3868, :MARK=47959, :OFFSET=1642327, :STARTTIME=2013-08-13T03:00:00Z,
> :TYPE=33
> Driver error was [2/126]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Incorrect key file for table './mythconverg/recordedseek.MYI'; try to 
> repair it
> 
> ---
> 
> What can I do to repair this?
> 
> 
I would first backup existing DB tables with backup script from MythTV
wiki.
Then run repair & optimize tools from mythweb (for from terminal).

Could then run DB backup again, then check size of 2 backups..
If this reveals large data loss then could be better to restore a recent
DB backup (if there is one).

Check your mythcommflag --rebuild cmd again..

Any orphaned recordings can be located by an appropriately named script
& relocated to videos storage.