[mythtv-users] Puzzled by seektables.

[Davide Chiarini]

Michael,

thanks for your response

> I'm guessing either a) you have a 0.19 version of
> mythbackend/mythcommflag on your system, b) your recordedmarkup table
> was corrupt when you upgraded to 0.20, so data wasn't properly moved to
> recordedseek, or c) your recordedseek table is currently corrupt (does
> not rule out b, though).

i'm sure that both programs are version 0.20. i've checked out both
recorededmarkup and recordedseek tables, and both contain data, and
are pretty heavy (135k records the first, 300k the second)

> The first step in fixing it is to run optimize_mythdb.pl from the
> contrib directory of the source distribution (also probably installed by
> packages).  Once that's done, run "mythcommflag --rebuild -f
> /path/to/recording" on one file.  Then, try to edit that recording (let
> me know if you need help figuring out which recording goes with a file,
> but basically, the last part of the filename is date/time and the first
> part is typically "related" to channel number).

optimize_mythdb.pl seems to have worked fine. I run mythcommflag
(below is the output), and it went through the whole file (although
there's a " Parser not found for Codec Id: 94211" message).
Unfortunately I still can't edit the recordings, and I still get the
"no seektable" error.

In mythbackend logs I get
2006-10-28 05:17:07.629 Cannot edit - no full position map

Is there maybe a way to reconstruct the table (would I lose my
recordings if I drop it?)

thanks for helping,
davide


--------------------------
root at server:/stor/myth$ mythcommflag --rebuild -f 3002_20061016210000.mpg
2006-10-28 12:16:23.703 Using runtime prefix = /usr
2006-10-28 12:16:23.760 New DB connection, total: 1
2006-10-28 12:16:23.786 mythcommflag version: 0.20.20060828-3 www.mythtv.org
2006-10-28 12:16:23.787 Enabled verbose msgs: important

MythTV Commercial Flagger, started at Sat Oct 28 12:16:23 2006
Rebuilding SeekTable(s) for:
ChanID  Start Time      Title                                      Status
------  --------------  -----------------------------------------  ------
2006-10-28 12:16:23.800 New DB connection, total: 2
3002    20061016210000  Distretto Di Polizia 6
2006-10-28 12:16:23.917 Using protocol version 31
[mpegts @ 0xb72d07f0]Parser not found for Codec Id: 94211 !
0: start_time: 161.907 duration: 917.525
1: start_time: 161.869 duration: 917.540
2: start_time: 161.864 duration: 917.542
3: start_time: 161.866 duration: 917.545
stream: start_time: 1798.484 duration: 10195.200 bitrate=8563 kb/s
 99%/  424fpsRebuilt

Finished commercial break flagging at Sat Oct 28 12:26:57 2006