[mythtv] [mythtv-commits] Ticket #1319: scheduler is sometimes recording wrong program

[Bruce Markey]

henri wrote:
...
> my guess is that the schedule is changing but the data in recordmatch
> isn't getting cleared? that would be the only explanation that makes

More likely it was getting the same, or different, incorrect result
each time (how did it get an incorrect row in the first place?).
Could have been a broken index or something.

> i'll keep a manual eye out for the 2 rules that are causing me
> problems (one on cartoon network, the other on comedy central). if it
> happens again hopefully i'll have more data (program entries from each
> day and recordmatch entries from each day)

If it does happen again, try:

SELECT chanid,starttime,title FROM program WHERE title='Foobar';

as a quick first check. If it returns a different title than the
WHERE clause then the DB is bad. If this result is correct but
the timestamps in recordmatch are different, it's probably still
a bad DB but you'll have narrowed down where to look for the cause.

--  bjm