[mythtv] Patch for mythfilldatabase --no-delete
Oscar Carlsson
webmaster at trekotor.se
Thu Mar 3 11:06:13 UTC 2005
Mattias Holmlund wrote, On 2005-03-03 09:55:
> On 27 Feb 2005 09:13:42 +0000, Andrew M. Bishop
> <amb at gedanken.demon.co.uk> wrote:
> <snip>
>
>>The first of the two attached patches (mythfilldatabase.patch1.diff)
>>fixes this. Without the fix there are thousands of sql insert errors
>>and the database ends up with overlapping programs.
>
>
> I have probably been bitten by this behaviour. I found the following
> in my program table yesterday:
>
> mysql> select chanid, starttime, endtime, title from program where
> title="Mediemagasinet" order by starttime;
> +--------+---------------------+---------------------+----------------+
> | chanid | starttime | endtime | title |
> +--------+---------------------+---------------------+----------------+
> | 1005 | 2005-03-02 16:00:00 | 2005-03-02 16:30:00 | Mediemagasinet |
> | 1005 | 2005-03-02 16:05:00 | 2005-03-02 16:35:00 | Mediemagasinet |
> | 1005 | 2005-03-03 20:30:00 | 2005-03-03 21:00:00 | Mediemagasinet |
> | 1005 | 2005-03-05 14:00:00 | 2005-03-05 14:30:00 | Mediemagasinet |
> | 1005 | 2005-03-09 16:05:00 | 2005-03-09 16:35:00 | Mediemagasinet |
> | 1005 | 2005-03-10 20:30:00 | 2005-03-10 21:00:00 | Mediemagasinet |
> +--------+---------------------+---------------------+----------------+
> 6 rows in set (0.01 sec)
>
> As you can see, there are two entries for Mediemagasinet on March 2nd,
> one from 16:00 to 16:30 and one from 16:05 to 16:35. Mediemagasinet
> was originally scheduled for 16:00, but they changed it a few days ago
> to run at 16:05 instead. What I think has happened is that the first
> time mythfilldatabase fetched data for March 2nd it added the
> 16:00-entry. Then when it fetched new data for March 2nd it added the
> program at 16:05 without realising that it had to remove the
> 16:00-entry.
>
> I'm running Myth 0.17 (Debian packages) and tv_grab_se_swedb if that
> makes any difference.
Hi Mattias :)
Don't use --no-delete, since it won't delete old programs (just like the
description says it shouldn't). I'll rewrite this to only keep old
programs for 7 days, and nothing else (see the rest of the thread for
details).
/O
More information about the mythtv-dev
mailing list