[mythtv-users] no seek table

[John Pilkington]

On 08/10/15 13:12, Hika van den Hoven wrote:
> Hoi Daryl,
>
> Thursday, October 8, 2015, 1:56:14 PM, you wrote:
>
>> On Oct 8, 2015 7:50 AM, "Hika van den Hoven" <hikavdh at gmail.com> wrote:
>>>
>>> Hoi Daryl,
>>>
>>> Thursday, October 8, 2015, 1:11:15 PM, you wrote:
>>>
>>>> On Oct 8, 2015 3:27 AM, "John Pilkington" <J.Pilk at tesco.net> wrote:
>>>>>
>>>>> On 08/10/15 00:45, Daryl McDonald wrote:
>>>>>>
>>>>>> Greetings Mythizens, I'm running Myth 0.27 fixes in a 14.04 Ubuntu
>>>>>> Desktop, recently I've had some freeze-ups that I worked around with a
>>>>>> hard restart, this time it took two restarts one of which found errors
>>>>>> and asked me to push "f" to try to fix them, I did and now I have no
>>>>>> seek tables on any of my recordings, recent unedited or older already
>>>>>> edited ones. What can I do now to get this back to normal?
>>>>>>
>>>>>> TIA  Daryl
>>>>>>
>>>>> $ mythutil --help
>>>>> mythutil version: master [v0.28-pre-2683-g7f68683] www.mythtv.org
>>>>>
>>>>> Recording Utils Options:
>>>>> --checkrecordings                Check all recording exist and have a
>>>> seektable etc.
>>>>>    --fixseektable                   (optional) fix the seektable if
>>>> missing for a recording
>>>>>
>>>>> Don't know if this is in fixes.
>>>>>
>>>>> Otherwise 'mythcommflag --rebuild' individually.
>>>>>
>>>>> HTH, John
>>>>>
>>>
>>>> I'll try that when I get a chance, curiously there are no seek tables
>> for
>>>> new recordings either, last night's.
>>>> I did already optimize the db but that is done in a daily from also.
>>>
>>> Could it be your seektable crashed!? If so and you can not repair, you
>>> have to restore from a backup or start afresh with an empty one!
>>>
>>> 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
>>>
>>> _______________________________________________
>
>> Hoi Hika, what would then happen to recordings that are post backup?
>
> The seektable is completely recreateable as John said. It only will
> take a lot af time. As I understand it is more then half of everything
> in the DB. So restoring from backup might be faster. You then only
> have to recreate those since that backup.
> But if it is crashed you will first have to fix it. You can check in
> phpmyadmin. I probably could do it, but I've never done it, so I hope
> others with more experience will step in.
>

My reading of the optimize script suggests that it will print 'Skipped 
$table' if it finds one it can't repair.

I agree that recreating the tables will take a long time, and restoring 
the DB would be quicker, leaving only recent recordings to be scanned. 
But I suspect that --fixseektable, if you have it, is a background job 
and will just churn on until it's done.