[mythtv-users] no seek table

[Daryl McDonald]

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.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151008/346c8207/attachment.html>