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

[Bruce Markey]

MythTV wrote:
> #1319: scheduler is sometimes recording wrong program
...
>  almost seems to be getting worse (just yesterday it recorded 4 incorrect
>  problems)
> 
>  here is more info using the same example ("teen titans" i tried removing
>  the recording rule and creating a new one, so the recordid has changed)

There are two phases in the scheduler; match, which finds programs
in the listings that match each rule, them place, which fills in
the schedule and sets the status for each program from match.

The match results are stored in 'recordmatch':

mysql> describe recordmatch;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| recordid  | int(10) unsigned | YES  | MUL | NULL    |       |
| chanid    | int(10) unsigned | YES  |     | NULL    |       |
| starttime | datetime         | YES  |     | NULL    |       |
| manualid  | int(10) unsigned | YES  |     | NULL    |       |
+-----------+------------------+------+-----+---------+-------+

It doesn't make sense that if there are is a kChannelRecord rule
that asks for WHERE title='Teen Titans' that it would find chanid
and starttime for another title.

Therefore, I suspect that you have a corrupt recordmatch table or
program table (or a remote possibility of a timezone/timestamp
issue but with this example that looks less likely).

Please do the following:

$ killall mythbackend;
$ mysqlcheck -ro -u mythtv -pmythtv mythconverg
$ mysql -u mythtv -pmythtv mythconverg
mysql> truncate table recordmatch;
mysql> truncate table program;
mysql> quit
$ mythfilldatabase
$ mysqlcheck -ro -u mythtv -pmythtv mythconverg
$ mythbackend

--  bjm