[mythtv] Scheduler problems (duplicate detection)

John Pullan jmp at tarantella.com
Mon Feb 28 21:36:03 UTC 2005


I'm having problems with duplicate detection. In the following example
"the gadget show" is repeated, but both episodes are being scheduled. 

Could someone cast there eye over this and tell me if there is a bug or
if not why both are being scheduled ? Or where I should look.

Thanks

>From the program table :

 select * from program where title="The Gadget Show";

| chanid | starttime           | endtime             | title           |
subtitle | description                           | category |
category_type | airdate | stars | previouslyshown | title_pronounce |
stereo | subtitled | hdtv | closecaptioned | partnumber | parttotal |
seriesid  | originalairdate | showtype | colorcode |
syndicatedepisodenumber | programid | manualid |

|   1011 | 2005-03-04 19:30:00 | 2005-03-04 19:58:00 | The Gadget Show |
| Technology show. Jason Bradbury investigates Linus; the show visits
the Bang and Olufsen testing lab; Jon Bentley tests mobile phone email;
and how global positioning systems work. |          |               |
2005 |     0 |       0 |                 |      0 |         0 |    0 |
0 |   0 |         0 | 187219799 | NULL            |          |
|                |           |        0 |
|   1011 | 2005-03-04 23:50:00 | 2005-03-05 00:20:00 | The Gadget Show |
| Technology show. Jason Bradbury investigates Linus; the show visits
the Bang and Olufsen testing lab; Jon Bentley tests mobile phone email;
and how global positioning systems work. |          |               |
2005 |     0 |       0 |                 |      0 |         0 |    0 |
0 |   0 |         0 | 187219799 | NULL            |          |
|                |           |        0 |


>From the backend.

mythbackend -v schedule
2005-02-28 21:16:49.240 New DB connection, total: 1
Starting up as the master server.
2005-02-28 21:16:49.250 New DB connection, total: 2
2005-02-28 21:16:49.254 DVB#0 DVB SI Table Parser Started
2005-02-28 21:16:49.254 DVB#0 Using DVB card 0, with frontend Philips
TDA10045H DVB-T.
2005-02-28 21:16:49.256 New DB connection, total: 3
2005-02-28 21:16:50.307 DVB#0 DVB signal c7c7 | snr fefe | ber   a8 |
unc    0
2005-02-28 21:16:50.307 DVB#0 Status: LOCK.
2005-02-28 21:16:50.307 DVB#0 Multiplex Locked
2005-02-28 21:16:51.922 DVB#0 Successfully tuned to channel 1.
2005-02-28 21:16:51.926 New DB scheduler connection
2005-02-28 21:16:51.931 mythbackend version: 0.17.20050223-1
www.mythtv.org
2005-02-28 21:16:51.931 Enabled verbose msgs : important general
schedule
2005-02-28 21:16:53.931 Reschedule requested for id -1.
Query 0: /record.search = 0 AND (record.recordid = -1 OR -1 = -1) AND
program.manualid = 0 AND program.title = record.title
2005-02-28 21:16:53.934  |-- Start DB Query 0...
2005-02-28 21:16:53.936  |-- -1 results in 0.001186 sec.
2005-02-28 21:16:53.936  +-- Done.
2005-02-28 21:16:53.937 PruneOldRecords...
2005-02-28 21:16:53.937 AddNewRecords...
2005-02-28 21:16:53.938  |-- Start DB Query...
2005-02-28 21:16:53.940  |-- 2 results in 0.00208 sec. Processing...
2005-02-28 21:16:53.942  +-- Cleanup...
2005-02-28 21:16:53.942 Sort by time...
2005-02-28 21:16:53.942 PruneOverlaps...
2005-02-28 21:16:53.942 Sort by priority...
2005-02-28 21:16:53.942 BuildListMaps...
2005-02-28 21:16:53.942 SchedNewRecords...
2005-02-28 21:16:53.942 Scheduling:
  +The Gadget Show                        5 1011  04 19:30-19:58  1 1 1
C 1   0  +The Gadget Show                        5 1011  04 23:50-00:20
1 1 1  C 1   02005-02-28 21:16:53.943 Sort retrylist...
2005-02-28 21:16:53.943 MoveHigherRecords...
2005-02-28 21:16:53.943 Retrying:
2005-02-28 21:16:53.943 ClearListMaps...
2005-02-28 21:16:53.943 Sort by time...
2005-02-28 21:16:53.943 PruneRedundants...
--- print list start ---
Title - Subtitle                    Chan ChID Day Start  End   S C I  T
N Pri
The Gadget Show                        5 1011  04 19:30-19:58  1 1 1  C
1   0
The Gadget Show                        5 1011  04 23:50-00:20  1 1 1  C
1   0
---  print list end  ---
2005-02-28 21:16:53.943 Scheduled 2 items in 0.0 = 0.00 match + 0.01
place
2005-02-28 21:16:53.945 Seem to be woken up by USER

-- 
John Pullan <jmp at tarantella.com>



More information about the mythtv-dev mailing list