[mythtv-users] Slow scheduling response

Lane Roberts roberts.lane at gmail.com
Tue Nov 17 02:43:23 UTC 2009

On Mon, Nov 16, 2009 at 8:25 PM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 11/16/2009 08:34 PM, Lane Roberts wrote:
>> On Mon, Nov 16, 2009 at 6:59 PM, Michael T. Dean wrote:
>>> On 11/16/2009 07:20 PM, Lane Roberts wrote:
>>>> Thanks for pointing me in the right direction - there was definitely
>>>> something wrong with the schema. Scheduling is back down to sub-2
>>>> seconds, which is good enough for me.
>>>> The only issue I ran into was that my backup had an `offset` column in
>>>> recordedmarkup, that is not present in the new schema. I truncated the
>>>> partial restore tables, added the `offset` column, and re-ran the
>>>> restore without any problems.
>>> You can only do a partial restore from/to the same version of MythTV
>>> schema.
>>>  If you did a partial restore from your 0.21-fixes database into a
>>> 0.22-fixes schema, it will corrupt some of your data.  (Most noticeable,
>>> in
>>> this case with seeking in old recordings and with bookmarkes, etc.)
>>> If you want to do the partial restore from your 0.21-fixes database,
>>> you'll
>>> need to follow instructions at
>>> http://www.gossamer-threads.com/lists/mythtv/users/406111#406111 (which
>>> includes a "blank" 0.21-fixes database--use that instead of start
>>> mythtv-setup to create the schema).
>> ok, I did see that part in the docs. The two issues you mentioned, I'm
>> not too concerned about (I've only got a few existing recordings). How
>> likely am I to run into anything more serious?
>> Since I only added the offset column for the restore, then dropped it,
>> I should be alright going forward, correct? I'm only really concerned
>> about what happens when I go to upgrade to .23. I'm assuming that
>> since the schema is now correct, I should be alright?
> Without knowing the exact steps you followed and versions of everything used
> in the process, I can't even guess as to what problems you may
> encounter--and definitely am not willing to say you won't have problems
> (even if I were trace all of the code to find out what should have happened
> and compare it to what did happen).  But, the process described in the link
> above will work and give you good data.
> I highly recommend re-doing the restore with the proper versions of schema.
> Mike

Ok, I will give that a shot. Thanks for all your help.


More information about the mythtv-users mailing list