Opened 14 years ago

Closed 14 years ago

#1319 closed defect (worksforme)

scheduler is sometimes recording wrong program

Reported by: henri@… Owned by: gigem
Priority: minor Milestone: unknown
Component: mythtv Version: head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

twice since i upgraded from 0.18 to svn 8978M i've had a show i never scheduled record.

the most recent one is a mixup where it recoreded "One Piece" using the "Teen Titans" recording rule

here is what i have in the database:

the incorrect recording:

mysql> select * from recorded where starttime = '2006-02-17T17:00:00' ;\
+--------+---------------------+---------------------+-----------+------------------------+-------------+----------+----------+----------+---------+---------+------------+-------------+----------+----------+----------+--------------+----------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+-------------+-----------+
| chanid | starttime           | endtime             | title     | subtitle               | description | category | hostname | bookmark | editing | cutlist | autoexpire | commflagged | recgroup | recordid | seriesid | programid    | lastmodified   | filesize  | stars | previouslyshown | originalairdate | preserve | findid | deletepending | transcoder | timestretch | recpriority | basename                | progstart           | progend             | playgroup | profile     | duplicate |
+--------+---------------------+---------------------+-----------+------------------------+-------------+----------+----------+----------+---------+---------+------------+-------------+----------+----------+----------+--------------+----------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+-------------+-----------+
|   3053 | 2006-02-17 17:00:00 | 2006-02-17 17:30:00 | One Piece | The Belle of the Brawl |             | Children | myth     | 7402     |       0 | NULL    |          1 |           0 | Default  |      557 | SH690150 | EP6901500034 | 20060217173000 | 831569796 |     0 |               0 | 2005-05-21      |        0 |      0 |             0 |          0 |           1 |         -10 | 3053_20060217170000.mpg | 2006-02-17 17:00:00 | 2006-02-17 17:30:00 | Default   | Low Quality |         1 |
+--------+---------------------+---------------------+-----------+------------------------+-------------+----------+----------+----------+---------+---------+------------+-------------+----------+----------+----------+--------------+----------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+-------------+-----------+

the recording rule:

mysql> select * from record where recordid = 557;
+----------+------+--------+-----------+------------+----------+------------+-------------+----------------+-------------+----------+-------------+-------------+------------+-------------+-----------+-----------+----------+-----------+-------+-------------+---------+----------+--------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+
| recordid | type | chanid | starttime | startdate  | endtime  | enddate    | title       | subtitle       | description | category | profile     | recpriority | autoexpire | maxepisodes | maxnewest | endoffset | recgroup | dupmethod | dupin | startoffset | station | seriesid | programid    | search | autotranscode | autocommflag | autouserjob1 | autouserjob2 | autouserjob3 | autouserjob4 | findday | findtime | findid | inactive | parentid | transcoder | tsdefault | playgroup |
+----------+------+--------+-----------+------------+----------+------------+-------------+----------------+-------------+----------+-------------+-------------+------------+-------------+-----------+-----------+----------+-----------+-------+-------------+---------+----------+--------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+
|      557 |    3 |   3053 | 14:00:00  | 2005-06-16 | 14:30:00 | 2005-06-16 | Teen Titans | The Apprentice |             | Children | Low Quality |         -10 |          1 |           6 |         1 |         0 | Default  |         6 |    15 |           0 | TOONP   | SH587023 | EP5870230013 |      0 |             0 |            0 |            0 |            0 |            0 |            0 |       0 | 00:00:00 |      0 |        0 |        0 |          0 |         1 | Default   |
+----------+------+--------+-----------+------------+----------+------------+-------------+----------------+-------------+----------+-------------+-------------+------------+-------------+-----------+-----------+----------+-----------+-------+-------------+---------+----------+--------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+

when i run

mythbackend --testsched

it shows the Teen Titans as upcoming recordings and no mention of One Piece

when i grep for "One Piece" in my log file i get many copies of these two lines:

  +One Piece - "The Belle of the Brawl   53 3053  17 17:00-17:30  3 2 2  C 2 -10
One Piece - "The Belle of the Brawl   53 3053  17 17:00-17:30  3 2 2  C 2 -10

not sure what else to look for

Change History (3)

comment:1 Changed 14 years ago by henri@…

Priority: minormajor
Severity: mediumhigh

still happening with

Library API version: 0.19.20060226-1 Source code version: 9236M

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)

mythbackend --printsched

One Piece - "Fantastic Voyage"        53 3053  07 17:00-17:30  3 2 2  C 2 -10

select * from record where recordid = 1073;

recordid        type    chanid  starttime       startdate       endtime enddate title   subtitle        description     category        profile recpriority     autoexpire      maxepisodes     maxnewest       endoffset       recgroup        dupmethod       dupin   startoffset     station seriesid        programid       search  autotranscode   autocommflag    autouserjob1    autouserjob2    autouserjob3    autouserjob4    findday findtime        findid  inactive        parentid        transcoder      tsdefault       playgroup
1073    3       3053    07:30:00        2006-03-07      08:00:00        2006-03-07      Teen Titans             Six heroes live together and battle their nemesis.      Children    Default -10     1       6       1       0       Default 6       15      0       TOONP   SH587023        SH5870230000    0       0       0       0       0       0       0       3       07:30:00        732742  0       0       0       1       Default

sql to get all upcomming recordings grabbed from mythbackend log and run from the command line (just a few lines):

3053    3       2006-03-08 17:00:00     2006-03-08 17:30:00     Teen Titans             Six heroes live together and battle their nemesis.      53      TOONP   Cartoon Network (Pacific)       0       Children        -10     15      0       0       3       1073    2006-03-08 17:00:00     2006-03-08 17:30:00     0       Default 6       0       2       2       0       SH587023        SH5870230000    series  2000    0       2003-07-19      0       0       0       Default NULL    NULL    0
3053    3       2006-03-08 07:30:00     2006-03-08 08:00:00     Teen Titans             Six heroes live together and battle their nemesis.      53      TOONP   Cartoon Network (Pacific)       0       Children        -10     15      0       0       3       1073    2006-03-08 07:30:00     2006-03-08 08:00:00     0       Default 6       0       2       2       0       SH587023        SH5870230000    series  2000    0       2003-07-19      0       0       0       Default NULL    NULL    0
3053    3       2006-03-07 17:00:00     2006-03-07 17:30:00     One Piece               Fantastic Voyage                                              53      TOONP   Cartoon Network (Pacific)       0       Children    -10     15      0       0       3       1073    2006-03-07 17:00:00     2006-03-07 17:30:00     0       Default 6       0       2       2       0       SH690150        EP6901500044    series  2000    0       2005-07-30      0       0       0       Default NULL    NULL    0
3053    3       2006-03-07 07:30:00     2006-03-07 08:00:00     Transformers Cybertron  Haven                                                                                                                                                                                                                         53                                                          TOONP   Cartoon Network (Pacific)       1       Children        -10    15      1       0       3       1073    2006-03-07 07:30:00     2006-03-07 08:00:00     0       Default 6       0       2       2       0       SH754282        EP7542820001    series  2000    0       2005-07-02      0       0       0       Default -3      0       0
3053    3       2006-03-06 07:00:00     2006-03-06 07:30:00     Teen Titans     Kole    The Teen Titans discover an underworld after being sent through ice.    53      TOONP   Cartoon Network (Pacific)       1       Children        -10     15      0       0       3       1073    2006-03-06 07:00:00     2006-03-06 07:30:00     0       Default 6       0       2       2       0       SH587023        EP5870230058    series  2000    0       2005-11-05      0       0       0       Default NULL    NULL    0

the sql query is 4.4K long and way beyond what i can understand. but i don't get at all why "One Piece" AND "Transformers Cybertron" are showing up in the middle of the "Teen Titan" listings!!

what else can i do to debug this?

comment:2 Changed 14 years ago by anonymous

Priority: majorminor
Severity: highmedium

comment:3 Changed 14 years ago by bjm

Resolution: worksforme
Status: newclosed

Likely database corruption. See mythtv-dev. Not a bug report unless there is a test case that can be reproduced independently showing a defect in the code. That isn't the case here as no one else has seen anything like this.

Note: See TracTickets for help on using tickets.