[mythtv-users] MythArchive native mode 0.26-fixes

[Paul Harrison]

On 30/07/13 22:11, HP-mini wrote:
> On Tue, 2013-07-30 at 21:50 +0100, John Pilkington wrote:
>> On 30/07/13 20:28, HP-mini wrote:
>>> On Sun, 2013-07-28 at 21:34 +0100, John Pilkington wrote:
>>>> On 28/07/13 20:57, HP-mini wrote:
>>>>> On Sun, 2013-07-28 at 10:49 +0100, John Pilkington wrote:
>>>>>> On 27/07/13 23:56, John Pilkington wrote:
>>>>>>> On 27/07/13 23:48, HP-mini wrote:
>>>>>>>
>>>>>>> <snip>
>>>>>>>
>>>>>> ..but this is worrying:  a few hours after MythArchive imported that
>>>>>> single recording, all recordings except the import and those made after
>>>>>> the MythArchive run appear to have lost their seektables.
>>>>>>
>>>
>>>>     On entering the editor, which I can usually use as a flexible skip
>>>> tool, they show 'no seektable'.  I haven't looked directly at the DB.
>>>
>>> Can confirm that same is happening with latest master..test recording
>>> was uncut mpegts.
>>>
>>>> I'm reducing the number of my short recordings anyway, by concatenating
>>>> 8 to 1 with a built-in rebuild, but it will be tedious if this happens
>>>> with every import.  I haven't tried another one yet.
>>>>
>>> Good idea.
>>>
>> I've opened  http://code.mythtv.org/trac/ticket/11712 after a second try
>> with the same result.  I think the earlier copy failure happened because
>> I hadn't properly set the destination channel.
>>
>> It all seemed to happen immediately.  I get the impression that there's
>> a seektable switch attached to individual recordings, and that the
>> import resets them all.  I would expect really deleting all the
>> seektables to be slower.
>>
>> _
> The mytharchivehelper (main.cpp) code (when importing native) checks for
> existing recording of same name & existing recordedseek (DB table).
> There must be something wrong with the SQL query so that it returns all
> recordings & not just the ones that match chanID & startTime...
>
> My "import" box only has 100 recordings & the seektables were gone in an
> instant.
>
>


There's a couple of typo's in the two query's that removes the old 
seektables in NativeArchive::importRecording(). I don't see how it would 
cause the behaviour you describe though I would have thought the query's 
would just fail to execute?

Paul H.