[mythtv-users] Problems with ATSC program guide
Tyler T
tylernt at gmail.com
Wed Mar 11 03:48:52 UTC 2009
>> You guys may have to crank up the logging for EIT and post some examples so
>> people can see maybe what's going on.
>
> I'll report back after a day or two.
Ok, here's a Zenith DTV box:
http://i39.tinypic.com/25zh44x.jpg
(FYI the Zap2It website shows this same description)
vs Mythtv (as shown in Webmin's MySQL viewer):
http://i44.tinypic.com/2kq23m.gif
This seems to be a description for 'Rules of Engagement', which shows
Mondays at 8:30pm (one day plus one timeslot before 'The Mentalist').
Here's the interesting bit, I went back in Myth's listings for 'Rules'
and it has the wrong description as well (for some other random show,
not 'Rules' or 'Mentalist'). So there appears to be some kind of
pattern to it.
Anyhoo, the zipped mythbackend log is 40KB. Here are some excerpts, I
can post (or email individually) the rest upon request.
2009-03-09 23:39:33.014 EITHelper: localtime offset -6:00:00
2009-03-09 23:39:33.156 New DB scheduler connection
2009-03-09 23:39:33.157 Connected to database 'mythconverg' at host: mythback
2009-03-09 23:39:34.642 Main::Registering HttpStatus Extension
2009-03-09 23:39:34.665 mythbackend version: 0.21.20080304-1 www.mythtv.org
2009-03-09 23:39:34.666 Enabled verbose msgs: important general eit
2009-03-09 23:39:34.670 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2009-03-09 23:39:36.186 Reschedule requested for id -1.
2009-03-09 23:39:36.648 Scheduled 15 items in 0.5 = 0.02 match + 0.44 place
2009-03-09 23:39:36.656 Seem to be woken up by USER
2009-03-09 23:39:43.433 UPnpMedia: BuildMediaMap - no VideoStartupDir
set, skipping scan.
2009-03-09 23:39:43.570 JobQueue: Started "HD to SD" for "Family Guy"
recorded from channel 2121 at Mon Mar 9 22:00:00 2009
2009-03-09 23:40:53.216 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2009-03-09 23:41:03.435 EITScanner (2): StartActiveScan called with 6
multiplexes
2009-03-09 23:41:03.703 EITScanner (2): Now looking for EIT data on
multiplex of channel 4_1
2009-03-09 23:41:03.704 EITCache: Pruning all entries that ended
before UTC 2009-03-08T23:46:17
2009-03-09 23:41:03.704 EITCache: Deleting old cache entries from the database
2009-03-09 23:41:04.383 Adding Source #1 ATSC chan 4-1
2009-03-09 23:41:04.383 Adding Source #3 ATSC chan 4-3
2009-03-09 23:41:04.383 Adding Source #4 ATSC chan 4-4
2009-03-09 23:41:04.383 Adding Source #2 ATSC chan 4-2
2009-03-09 23:41:04.640 EITScanner (2): Started passive scan.
2009-03-09 23:41:05.052 EITHelper: Added 4 events -- complete(3)
incomplete(3) unmatched(5)
2009-03-09 23:41:05.581 EITHelper: Added 13 events -- complete(13)
incomplete(5) unmatched(5)
2009-03-09 23:41:06.075 EITHelper: Added 13 events -- complete(13)
incomplete(5) unmatched(5)
2009-03-09 23:41:06.553 EITHelper: Added 11 events -- complete(10)
incomplete(5) unmatched(5)
2009-03-09 23:41:07.041 EITHelper: Added 13 events -- complete(13)
incomplete(5) unmatched(5)
2009-03-09 23:41:07.553 EITHelper: Added 15 events -- complete(14)
incomplete(5) unmatched(5)
2009-03-09 23:41:08.009 EITHelper: Added 7 events -- complete(7)
incomplete(5) unmatched(5)
2009-03-09 23:41:08.440 EITHelper: Added 4 events -- complete(4)
incomplete(5) unmatched(5)
2009-03-09 23:41:08.858 EITHelper: Added 2 events -- complete(2)
incomplete(5) unmatched(5)
2009-03-09 23:41:09.270 EITHelper: Added 1 events -- complete(1)
incomplete(5) unmatched(5)
2009-03-09 23:41:09.676 EITHelper: Added 1 events -- complete(0)
incomplete(5) unmatched(5)
2009-03-09 23:42:09.849 EITScanner (2): Added 84 EIT Events
2009-03-09 23:42:09.867 Reschedule requested for id -1.
2009-03-09 23:42:10.395 Scheduled 15 items in 0.5 = 0.04 match + 0.48 place
...
2009-03-09 23:56:47.815 EITScanner (2): Now looking for EIT data on
multiplex of channel 2_1
2009-03-09 23:56:47.815 EITCache: Pruning all entries that ended
before UTC 2009-03-09T00:02:01
2009-03-09 23:56:47.815 EITCache: Deleting old cache entries from the database
2009-03-09 23:56:48.199 Adding Source #1 ATSC chan 2-1
2009-03-09 23:56:48.563 EITScanner (2): Started passive scan.
2009-03-09 23:56:49.142 match[0]: -1500 'CSI: Miami' vs. 'CBS 2
Eyewitness News 10 at 10'
2009-03-09 23:56:49.213 match[0]: -120 'CBS 2 Eyewitness News 10 at
10' vs. 'Late Show With David Letterman'
2009-03-09 23:56:49.266 match[0]: -1800 'The Late Late Show With Craig
Ferguson' vs. 'Paid Programming'
2009-03-09 23:56:49.341 match[0]: 0 'First Business' vs. 'CBS 2
Eyewitness News at 5:00a'
2009-03-09 23:56:49.354 match[0]: 0 'CBS Morning News' vs. 'CBS 2
Eyewitness News at 5:30a'
2009-03-09 23:56:49.359 EITHelper: Added 7 events -- complete(7)
incomplete(10) unmatched(10)
...
2009-03-09 23:56:50.985 EITHelper: Added 14 events -- complete(14)
incomplete(10) unmatched(10)
2009-03-09 23:56:51.413 match[0]: -1500 'Without a Trace' vs. 'CBS 2
Eyewitness News 10 at 10'
2009-03-09 23:56:51.436 DB Error (change_program):
Query was:
UPDATE program SET starttime = '2009-03-10T22:00:00', endtime =
'2009-03-10T22:37:00' WHERE chanid = 2021 AND starttime =
'2009-03-10T21:35:00'
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '2021-2009-03-10 22:00:00-0' for key 1
I suspect that many of the 'match' log entries are because of the DST
change. My listings were all off by an hour and my backend recorded a
bunch of the wrong shows until I restarted the backend. Apparently,
EIT users should always restart the backend right after a DST change.
Anyway, I grepped all the match[0] entries and none of them were about
'Mentalist' or 'Rules' as mentioned above. I also checked the
descriptions in the Myth DB for that channel for an hour ahead and an
hour behind, neither were the description shown on the DTV box. I set
up this backend January-ish and the problem appeared long before the
DST change, so, I don't think DST is at fault here.
As for the DB error, I searched for others and came up with this:
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:59:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:30:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T23:00:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T22:30:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T22:00:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-02-18T03:00:00', endtime =
'2009-02-18T21:30:00' WHERE chanid = 2062 AND starttime =
'2009-02-18T02:30:00'
UPDATE program SET starttime = '2009-03-09T22:00:00', endtime =
'2009-03-09T22:37:00' WHERE chanid = 2071 AND starttime =
'2009-03-09T21:35:00'
UPDATE program SET starttime = '2009-03-10T22:00:00', endtime =
'2009-03-10T22:37:00' WHERE chanid = 2021 AND starttime =
'2009-03-10T21:35:00'
I did a quick browse and couldn't see any wrong descriptions on
channels NOT listed above, but I'll keep an eye out. It will be good
to know if only the channels listed above are the ones with wrong
descriptions.
Please let me know if there's any more information I can provide, or
troubleshooting steps I can take.
___
/yler
More information about the mythtv-users
mailing list