[mythtv-users] no seek table

[Hika van den Hoven]

Hoi Daryl,

Thursday, October 8, 2015, 11:32:53 PM, you wrote:

> On Oct 8, 2015 9:20 AM, "John Pilkington" <J.Pilk at tesco.net> wrote:
>>
>> 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.
>>
>>

> I agree the backup will be quicker, but will I have to use find orphans
> after to get the new recordings? This is what I don't get yet.

You should first check if the seektable is indeed crashed and that
optimize_mythdb.pl can't fix it. As John said this script will tell
you.

Next you can try a partial restore of only the seektable. The easiest
way is if you have phpmyadmin running and you feel save in using it.
If so I can tell you how.


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