LinHES Forums
http://forum.linhes.org/

advice rebuilding seek file?
http://forum.linhes.org/viewtopic.php?f=6&t=13582		 Page 1 of 1
Author:  neutron68 [ Tue Jan 16, 2007 11:08 pm ]
Post subject:  advice rebuilding seek file?
I've got an episode of NOVA from PBS that I had to reinsert into the database after an odd system problem back in November. I used the mythrebuilddatabase.pl script to get it back in and it worked.

Now, I'd like to use mpeg2 lossless transcoding to chop 5 minutes off the end of the show. The problem is that the seek table seems to be screwed up and I can't seem to rebuild it. I've been typing the command
Code:
 # mythcommflag --rebuild -f /myth/tv/1021_20061031200001.mpg
And it responds with
Code:
2007-01-16 22:53:00.839 Using runtime prefix = /usr
2007-01-16 22:53:00.870 New DB connection, total: 1
2007-01-16 22:53:00.878 mythcommflag version: 0.20.20060828-3 www.mythtv.org
2007-01-16 22:53:00.878 Enabled verbose msgs: important

MythTV Commercial Flagger, started at Tue Jan 16 22:53:00 2007
Rebuilding SeekTable(s) for:
ChanID  Start Time      Title                                      Status
------  --------------  -----------------------------------------  ------
2007-01-16 22:53:00.881 New DB connection, total: 2
1021    20061031200001  NOVA                                       2007-01-16 22:53:00.894 Using protocol version 31
0: start_time: 2773.919 duration: 323.606
1: start_time: 2773.882 duration: 323.611
2: start_time: 2773.881 duration: 323.611
stream: start_time: 30820.895 duration: 3596.058 bitrate=17837 kb/s
 96%/  498fpsRebuilt

Finished commercial break flagging at Tue Jan 16 22:56:30 2007

But, when I go to look at the show, the On Screen Display says it's only 13:10 minutes long, and I know the file is 60 minutes long. Any idea why the seek file won't rebuild properly and how I can fix it?

Feb. 3 edit:
I looked at the video in that particular clip and there seem to have been some reception errors during recording. Somehow the original recording's seek file was good enough for playback, but a rescan after doing some cut-editing of the file could not produce a valid seek file.

It scares me to think that I know more about this process than anyone else on this forum - to the point that no one will even attempt a response. :shock:

Eric
Author:  myth19kirt [ Sat Mar 24, 2007 10:49 pm ]
Post subject: 
Thanks Eric,

I found http://mysettopbox.tv/phpBB2/viewtopic.php?t=6748&highlight=import+record and

I had some videos on R5D1 that I wanted on my new R5E0. I copied the file and used the insert into recorded table. I then saw the video in MY RECORDINGS, and I used the Myth GUI and selected the option to reflag the comercials. I was able to view the video, but I got NO SEEKTABLE when trying to edit.

I wanted to reedit the videos and flawlessly transcode out the commercials and you provided the needed code. :lol:
Code:
mythcommflag --rebuild -f /myth/tv/1015_20070229110000.mpg


I was able to edit the reinserted video after that. Thanks to you.

Have you tried another mpg file? Maybe the Nova.mpg is damaged.
Author:  myth19kirt [ Wed Mar 28, 2007 2:50 pm ]
Post subject: 
The answer to the 13 minute delema is:

mythcommflag looks at the recored database for information on the mpg you imported.

You must supply chanid, starttime, endtime, title, ETC... when you imported the MPG and that is the reported length you are seeing. If you update the TIMES in recorded database for that MPG to be 60 minutes and redid the mythcommflag --rebuild; you will see it as 60 minutes.

mythcommflag uses chanid and starttime as unique KEYS for the recordedmarkup database.
Author:  borgednow [ Wed Mar 28, 2007 6:45 pm ]
Post subject: 
myth19kirt wrote:
The answer to the 13 minute delema is:

mythcommflag looks at the recored database for information on the mpg you imported.

You must supply chanid, starttime, endtime, title, ETC... when you imported the MPG and that is the reported length you are seeing. If you update the TIMES in recorded database for that MPG to be 60 minutes and redid the mythcommflag --rebuild; you will see it as 60 minutes.

mythcommflag uses chanid and starttime as unique KEYS for the recordedmarkup database.


It can't be the recordedmarkup table that the system gets the 13 minutes from.

I copied some programs over from my previous hardware. I set one program manually to duplicate the data in recorded, oldrecorded, and recordedmarkup that was in the other database. I was getting the same kind of error, with the system thinking the show was over 3 hours long. (start time was 20:31)

I did a reschedule of the job for commercial autoskip, and still had the same problem. The recordedmarkup records for the program are identical, still over 3 hours.

I copied another program over, used the mythrebuilddatabase.pl, and it worked perfectly.

I just noticed though that the table record doesn't have the row for this recording however. I'll add a row to it and see if that works.

Edit: nope. Didn't work. I'll try to run the commflag program tomorrow. I don't really want to run it now since I have some shows recording at the moment.

I think this info is no longer current.
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7

I'm reasonably sure it's not based on the recordedseek table either, because I discovered last night that my old systems recordedseek table didn't even exist. And yet, programs I recorded over the last month still work fine.

I'm guessing that the mythrebuilddatabase.pl process stores some data outside of mysql. I'll have to dig deeper into it. My old system, the mythrebuilddatabase.pl never worked under D1, but the new system with E50 it works great.

Edit: yep. Running commflag fixed the problem for me. It was actually setting it to nearly 4 hours rather than just over 3 as I'd misremembered.

So the length of the show is not stored in one of the time fields as far as I can tell.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/