Opened 18 years ago
Closed 18 years ago
#1319 closed defect (worksforme)
scheduler is sometimes recording wrong program
| Reported by: | 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 18 years ago by
| Priority: | minor → major |
|---|---|
| Severity: | medium → high |
comment:2 Changed 18 years ago by
| Priority: | major → minor |
|---|---|
| Severity: | high → medium |
comment:3 Changed 18 years ago by
| Resolution: | → worksforme |
|---|---|
| Status: | new → closed |
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.
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
select * from record where recordid = 1073;
sql to get all upcomming recordings grabbed from mythbackend log and run from the command line (just a few lines):
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?