[mythtv-users] how to set xmltvid to unknown and keep it there?
Eric Sharkey
eric at lisaneric.org
Thu Jul 7 15:30:57 UTC 2011
On Thu, Jul 7, 2011 at 10:07 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> xmltvid should be empty--not NULL--if unset. Therefore, there's no need
> to do direct DB editing. Note that using the mythtv-setup GUI we
> provide to edit your channels will prevent you from putting in NULL here
> (or, for other data where NULL is the proper value, it will put in
> NULL)... This is why you should use the GUI to access MythTV data--it
> knows the data constraints that users shouldn't need to know (and that
> no one person--the devs included--knows completely).
Most of the time, I set the xmltvid by tuning the channel in "Live
TV", pushing E, then editing the channel settings from the popup
dialog.
> Please make
> sure that xmltvid is listed as "No" for "Null" in:
>
> mysql -umythtv -p mythconverg -e 'DESC channel;'
It is listed that way.
> a) How many Schedules Direct lineups do you have?
One.
> b) How many MythTV Video Sources do you have?
Three.
> c) What all cards are you using for capture (and which input/connection
> on them)?
HDHR, two tuners, both source 5.
Firewire capture to HD tuner box, source 4.
PVR150 composite in to same HD tuner box (it downscales everything to
SD), in the same input group as firewire, source 6.
source 5 has only clear QAM channels. Sources 4 and 6 have all
channels enabled in schedules direct, but differ as channels usually
blocked by 5C encryption marked with visible = 0 in source 4.
> d) Are you saying that the xmltvid gets "updated" when you run
> mythfilldatabase?
That appears to be the case.
> e) Are you saying this happens after each time you try to unset the
> xmltvid or only after new channel scans?
Every time, yes.
> f) Are you running mythfilldatabase with any arguments (such as
> --do-channel-updates or --do-not-filter-new-channels or ...)?
No, not as far as I know.
> g) Do you actually receive History/History International on any inputs
> in MythTV?
Yes, but not in clear QAM (not via the HDHR).
> It sounds like the problem is that Schedules Direct is sending info
> about the channel such that channel number for History/History
> International is the same as the channel number currently used for your
> community channels, so mythfilldatabase updates it for you, thinking
> it's the same channel and that you didn't configure it.
No, the channel numbers are different, but the freqid does match. I'm
not sure what freqid is used for for firewire or composite in on a
PVR150.
Here's how it happens:
mysql> select chanid, channum, freqid, serviceid, callsign, name,
xmltvid from channel where sourceid = 5 and name like 'Unknown%' order
by freqid +0, serviceid +0;
+--------+---------+--------+-----------+-----------+-----------+---------+
| chanid | channum | freqid | serviceid | callsign | name | xmltvid |
+--------+---------+--------+-----------+-----------+-----------+---------+
| 17721 | 21 | 127 | 12721 | Unknown21 | Unknown21 | 18822 |
| 17722 | 22 | 127 | 12722 | Unknown22 | Unknown22 | 18822 |
| 17729 | 29 | 127 | 12729 | Unknown29 | Unknown29 | 18822 |
| 17731 | 31 | 127 | 12731 | Unknown31 | Unknown31 | 18822 |
| 17733 | 33 | 127 | 12733 | Unknown33 | Unknown33 | 18822 |
| 17734 | 34 | 127 | 12734 | Unknown34 | Unknown34 | 18822 |
| 17840 | 40 | 128 | 12840 | Unknown40 | Unknown40 | 14771 |
| 17843 | 43 | 128 | 12843 | Unknown43 | Unknown43 | 14771 |
+--------+---------+--------+-----------+-----------+-----------+---------+
8 rows in set (0.00 sec)
mysql> update channel set xmltvid = '' where sourceid = 5 and name
like 'Unknown%';
Query OK, 8 rows affected (0.00 sec)
Rows matched: 8 Changed: 8 Warnings: 0
mysql> select chanid, channum, freqid, serviceid, callsign, name,
xmltvid from channel where sourceid = 5 and name like 'Unknown%' order
by freqid +0, serviceid +0;
+--------+---------+--------+-----------+-----------+-----------+---------+
| chanid | channum | freqid | serviceid | callsign | name | xmltvid |
+--------+---------+--------+-----------+-----------+-----------+---------+
| 17721 | 21 | 127 | 12721 | Unknown21 | Unknown21 | |
| 17722 | 22 | 127 | 12722 | Unknown22 | Unknown22 | |
| 17729 | 29 | 127 | 12729 | Unknown29 | Unknown29 | |
| 17731 | 31 | 127 | 12731 | Unknown31 | Unknown31 | |
| 17733 | 33 | 127 | 12733 | Unknown33 | Unknown33 | |
| 17734 | 34 | 127 | 12734 | Unknown34 | Unknown34 | |
| 17840 | 40 | 128 | 12840 | Unknown40 | Unknown40 | |
| 17843 | 43 | 128 | 12843 | Unknown43 | Unknown43 | |
+--------+---------+--------+-----------+-----------+-----------+---------+
8 rows in set (0.00 sec)
^Z
[1]+ Stopped mysql mythconverg
mythtered:/etc/cron.daily# mythfilldatabase
2011-07-07 11:05:12.374 Using runtime prefix = /usr
2011-07-07 11:05:12.378 Using configuration directory = /root/.mythtv
2011-07-07 11:05:12.379 Empty LocalHostName.
2011-07-07 11:05:12.379 Using localhost value of mythtered
2011-07-07 11:05:12.400 New DB connection, total: 1
2011-07-07 11:05:12.402 Connected to database 'mythconverg' at host: localhost
2011-07-07 11:05:12.406 Closing DB connection named 'DBManager0'
2011-07-07 11:05:12.406 Connected to database 'mythconverg' at host: localhost
2011-07-07 11:05:12.407 Current locale EN_US
2011-07-07 11:05:12.407 Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
2011-07-07 11:05:12.410 Loading en_us translation for module mythfrontend
2011-07-07 11:05:12.413 Current MythTV Schema Version (DBSchemaVer): 1264
2011-07-07 11:05:12.415 New DB connection, total: 2
2011-07-07 11:05:12.415 Connected to database 'mythconverg' at host: localhost
2011-07-07 11:05:16.860 Updating source #4 (Verizon Fios) with grabber
schedulesdirect1
2011-07-07 11:05:16.861 Found 373 channels for source 4 which use grabber
2011-07-07 11:05:16.861
2011-07-07 11:05:16.861 Checking day @ offset 0, date: Thu Jul 7 2011
2011-07-07 11:05:17.027 Data is already present for Thu Jul 7 2011, skipping
2011-07-07 11:05:17.027
2011-07-07 11:05:17.027 Checking day @ offset 1, date: Fri Jul 8 2011
2011-07-07 11:05:17.027 Data Refresh always needed for tomorrow
2011-07-07 11:05:17.027 Refreshing data for Fri Jul 8 2011
2011-07-07 11:05:17.027 This DataDirect listings source is shared by 3
MythTV lineups
2011-07-07 11:05:17.027 We should keep data around after this one
2011-07-07 11:05:17.027 New DB DataDirect connection
2011-07-07 11:05:17.028 Connected to database 'mythconverg' at host: localhost
2011-07-07 11:05:17.030 Retrieving datadirect data.
2011-07-07 11:05:17.030 Grabbing data for Thu Jul 7 2011 offset 1
2011-07-07 11:05:17.030 From Fri Jul 8 04:00:00 2011 to Sat Jul 9
04:00:00 2011 (UTC)
2011-07-07 11:05:17.030 Grabbing listing data
2011-07-07 11:05:17.031 DataDirect: Saving listings to DD cache
--2011-07-07 11:05:17--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: “STDOUT”
[ <=>
]
492,610 39.9K/s in 12s
2011-07-07 11:05:29 (39.9 KB/s) - written to stdout [492610]
2011-07-07 11:05:29.813 New DB connection, total: 3
2011-07-07 11:05:29.814 Connected to database 'mythconverg' at host: localhost
2011-07-07 11:05:29.815 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:44 PM
2011-07-07 11:05:30.021 sourceid 6 has lineup type: CableDigital
2011-07-07 11:05:38.427 Grab complete. Actual data from Fri Jul 8
04:00:00 2011 to Sat Jul 9 04:00:00 2011 (UTC)
2011-07-07 11:05:38.428 Main temp tables populated.
2011-07-07 11:05:38.428 Updating MythTV channels.
2011-07-07 11:05:38.463 IconData: Updating icons for sourceid: 4
2011-07-07 11:05:38.463 Channels updated.
2011-07-07 11:05:38.743 Clearing data for source.
2011-07-07 11:05:38.743 Clearing from Fri Jul 8 00:00:00 2011 to Sat
Jul 9 00:00:00 2011 (localtime)
2011-07-07 11:05:54.578 Data for source cleared.
2011-07-07 11:05:54.578 Updating programs.
2011-07-07 11:06:12.364 Program table update complete.
2011-07-07 11:06:12.368
2011-07-07 11:06:12.375 Checking day @ offset 2, date: Sat Jul 9 2011
2011-07-07 11:06:12.599 Data is already present for Sat Jul 9 2011, skipping
2011-07-07 11:06:12.599
2011-07-07 11:06:12.599 Checking day @ offset 3, date: Sun Jul 10 2011
2011-07-07 11:06:12.769 Data is already present for Sun Jul 10 2011, skipping
2011-07-07 11:06:12.769
2011-07-07 11:06:12.769 Checking day @ offset 4, date: Mon Jul 11 2011
2011-07-07 11:06:12.940 Data is already present for Mon Jul 11 2011, skipping
2011-07-07 11:06:12.940
2011-07-07 11:06:12.940 Checking day @ offset 5, date: Tue Jul 12 2011
2011-07-07 11:06:13.119 Data is already present for Tue Jul 12 2011, skipping
2011-07-07 11:06:13.120
2011-07-07 11:06:13.120 Checking day @ offset 6, date: Wed Jul 13 2011
2011-07-07 11:06:13.296 Data is already present for Wed Jul 13 2011, skipping
2011-07-07 11:06:13.296
2011-07-07 11:06:13.296 Checking day @ offset 7, date: Thu Jul 14 2011
2011-07-07 11:06:13.469 Data is already present for Thu Jul 14 2011, skipping
2011-07-07 11:06:13.469
2011-07-07 11:06:13.469 Checking day @ offset 8, date: Fri Jul 15 2011
2011-07-07 11:06:13.642 Data is already present for Fri Jul 15 2011, skipping
2011-07-07 11:06:13.642
2011-07-07 11:06:13.642 Checking day @ offset 9, date: Sat Jul 16 2011
2011-07-07 11:06:13.812 Data is already present for Sat Jul 16 2011, skipping
2011-07-07 11:06:13.812
2011-07-07 11:06:13.812 Checking day @ offset 10, date: Sun Jul 17 2011
2011-07-07 11:06:13.983 Data is already present for Sun Jul 17 2011, skipping
2011-07-07 11:06:13.984
2011-07-07 11:06:13.984 Checking day @ offset 11, date: Mon Jul 18 2011
2011-07-07 11:06:14.151 Data is already present for Mon Jul 18 2011, skipping
2011-07-07 11:06:14.151
2011-07-07 11:06:14.151 Checking day @ offset 12, date: Tue Jul 19 2011
2011-07-07 11:06:14.321 Data is already present for Tue Jul 19 2011, skipping
2011-07-07 11:06:14.321
2011-07-07 11:06:14.321 Checking day @ offset 13, date: Wed Jul 20 2011
2011-07-07 11:06:14.412 Data refresh needed because only 0 out of 373
channels have at least one program listed for day @ offset 13 from 8PM
- midnight. Previous day had 371 channels with data in that time
period.
2011-07-07 11:06:14.413 Refreshing data for Wed Jul 20 2011
2011-07-07 11:06:14.413 This DataDirect listings source is shared by 3
MythTV lineups
2011-07-07 11:06:14.413 We should keep data around after this one
2011-07-07 11:06:14.413 Retrieving datadirect data.
2011-07-07 11:06:14.413 Grabbing data for Thu Jul 7 2011 offset 13
2011-07-07 11:06:14.413 From Wed Jul 20 04:00:00 2011 to Thu Jul 21
04:00:00 2011 (UTC)
2011-07-07 11:06:14.413 Grabbing listing data
2011-07-07 11:06:14.415 DataDirect: Saving listings to DD cache
--2011-07-07 11:06:14--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: “STDOUT”
[ <=>
]
446,469 22.5K/s in 19s
2011-07-07 11:06:34 (22.5 KB/s) - written to stdout [446469]
2011-07-07 11:06:34.461 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:44 PM
2011-07-07 11:06:41.630 Grab complete. Actual data from Wed Jul 20
04:00:00 2011 to Thu Jul 21 04:00:00 2011 (UTC)
2011-07-07 11:06:41.631 Main temp tables populated.
2011-07-07 11:06:41.912 Clearing data for source.
2011-07-07 11:06:41.912 Clearing from Wed Jul 20 00:00:00 2011 to Thu
Jul 21 00:00:00 2011 (localtime)
2011-07-07 11:06:42.658 Data for source cleared.
2011-07-07 11:06:42.658 Updating programs.
2011-07-07 11:06:53.079 Program table update complete.
2011-07-07 11:06:54.267 Updating source #5 (Verizon Fios Clear) with
grabber schedulesdirect1
2011-07-07 11:06:54.268 Found 68 channels for source 5 which use grabber
2011-07-07 11:06:54.268
2011-07-07 11:06:54.268 Checking day @ offset 0, date: Thu Jul 7 2011
2011-07-07 11:06:54.299 Data is already present for Thu Jul 7 2011, skipping
2011-07-07 11:06:54.299
2011-07-07 11:06:54.299 Checking day @ offset 1, date: Fri Jul 8 2011
2011-07-07 11:06:54.299 Data Refresh always needed for tomorrow
2011-07-07 11:06:54.299 Refreshing data for Fri Jul 8 2011
2011-07-07 11:06:54.299 This DataDirect listings source is shared by 3
MythTV lineups
2011-07-07 11:06:54.299 We should use cached data for this one
2011-07-07 11:06:54.299 Retrieving datadirect data.
2011-07-07 11:06:54.299 Grabbing data for Thu Jul 7 2011 offset 1
2011-07-07 11:06:54.299 From Fri Jul 8 04:00:00 2011 to Sat Jul 9
04:00:00 2011 (UTC)
2011-07-07 11:06:54.300 Grabbing listing data
2011-07-07 11:06:54.300 DataDirect: Copying from DD cache
2011-07-07 11:06:54.306 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:44 PM
2011-07-07 11:07:04.431 Grab complete. Actual data from Fri Jul 8
04:00:00 2011 to Sat Jul 9 04:00:00 2011 (UTC)
2011-07-07 11:07:04.632 Main temp tables populated.
2011-07-07 11:07:04.632 Updating MythTV channels.
2011-07-07 11:07:05.062 IconData: Updating icons for sourceid: 5
2011-07-07 11:07:05.063 Channels updated.
2011-07-07 11:07:05.234 Clearing data for source.
2011-07-07 11:07:05.234 Clearing from Fri Jul 8 00:00:00 2011 to Sat
Jul 9 00:00:00 2011 (localtime)
2011-07-07 11:07:10.897 Data for source cleared.
2011-07-07 11:07:10.897 Updating programs.
2011-07-07 11:07:14.953 Program table update complete.
2011-07-07 11:07:14.958
2011-07-07 11:07:14.958 Checking day @ offset 2, date: Sat Jul 9 2011
2011-07-07 11:07:15.025 Data is already present for Sat Jul 9 2011, skipping
2011-07-07 11:07:15.025
2011-07-07 11:07:15.025 Checking day @ offset 3, date: Sun Jul 10 2011
2011-07-07 11:07:15.075 Data is already present for Sun Jul 10 2011, skipping
2011-07-07 11:07:15.076
2011-07-07 11:07:15.076 Checking day @ offset 4, date: Mon Jul 11 2011
2011-07-07 11:07:15.124 Data is already present for Mon Jul 11 2011, skipping
2011-07-07 11:07:15.124
2011-07-07 11:07:15.124 Checking day @ offset 5, date: Tue Jul 12 2011
2011-07-07 11:07:15.161 Data is already present for Tue Jul 12 2011, skipping
2011-07-07 11:07:15.161
2011-07-07 11:07:15.161 Checking day @ offset 6, date: Wed Jul 13 2011
2011-07-07 11:07:15.196 Data is already present for Wed Jul 13 2011, skipping
2011-07-07 11:07:15.196
2011-07-07 11:07:15.196 Checking day @ offset 7, date: Thu Jul 14 2011
2011-07-07 11:07:15.229 Data is already present for Thu Jul 14 2011, skipping
2011-07-07 11:07:15.230
2011-07-07 11:07:15.230 Checking day @ offset 8, date: Fri Jul 15 2011
2011-07-07 11:07:15.263 Data is already present for Fri Jul 15 2011, skipping
2011-07-07 11:07:15.263
2011-07-07 11:07:15.263 Checking day @ offset 9, date: Sat Jul 16 2011
2011-07-07 11:07:15.297 Data is already present for Sat Jul 16 2011, skipping
2011-07-07 11:07:15.297
2011-07-07 11:07:15.297 Checking day @ offset 10, date: Sun Jul 17 2011
2011-07-07 11:07:15.328 Data is already present for Sun Jul 17 2011, skipping
2011-07-07 11:07:15.328
2011-07-07 11:07:15.328 Checking day @ offset 11, date: Mon Jul 18 2011
2011-07-07 11:07:15.360 Data is already present for Mon Jul 18 2011, skipping
2011-07-07 11:07:15.360
2011-07-07 11:07:15.360 Checking day @ offset 12, date: Tue Jul 19 2011
2011-07-07 11:07:15.391 Data is already present for Tue Jul 19 2011, skipping
2011-07-07 11:07:15.391
2011-07-07 11:07:15.391 Checking day @ offset 13, date: Wed Jul 20 2011
2011-07-07 11:07:15.423 Data refresh needed because only 0 out of 68
channels have at least one program listed for day @ offset 13 from 8PM
- midnight. Previous day had 76 channels with data in that time
period.
2011-07-07 11:07:15.423 Refreshing data for Wed Jul 20 2011
2011-07-07 11:07:15.423 This DataDirect listings source is shared by 3
MythTV lineups
2011-07-07 11:07:15.423 We should use cached data for this one
2011-07-07 11:07:15.424 Retrieving datadirect data.
2011-07-07 11:07:15.424 Grabbing data for Thu Jul 7 2011 offset 13
2011-07-07 11:07:15.424 From Wed Jul 20 04:00:00 2011 to Thu Jul 21
04:00:00 2011 (UTC)
2011-07-07 11:07:15.424 Grabbing listing data
2011-07-07 11:07:15.424 DataDirect: Copying from DD cache
2011-07-07 11:07:15.430 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:44 PM
2011-07-07 11:07:24.235 Grab complete. Actual data from Wed Jul 20
04:00:00 2011 to Thu Jul 21 04:00:00 2011 (UTC)
2011-07-07 11:07:24.236 Main temp tables populated.
2011-07-07 11:07:24.383 Clearing data for source.
2011-07-07 11:07:24.383 Clearing from Wed Jul 20 00:00:00 2011 to Thu
Jul 21 00:00:00 2011 (localtime)
2011-07-07 11:07:24.519 Data for source cleared.
2011-07-07 11:07:24.519 Updating programs.
2011-07-07 11:07:25.476 Program table update complete.
2011-07-07 11:07:26.435 Updating source #6 (Verizon 5C SD) with
grabber schedulesdirect1
2011-07-07 11:07:26.436 Found 376 channels for source 6 which use grabber
2011-07-07 11:07:26.436
2011-07-07 11:07:26.436 Checking day @ offset 0, date: Thu Jul 7 2011
2011-07-07 11:07:26.610 Data is already present for Thu Jul 7 2011, skipping
2011-07-07 11:07:26.610
2011-07-07 11:07:26.610 Checking day @ offset 1, date: Fri Jul 8 2011
2011-07-07 11:07:26.610 Data Refresh always needed for tomorrow
2011-07-07 11:07:26.610 Refreshing data for Fri Jul 8 2011
2011-07-07 11:07:26.610 This DataDirect listings source is shared by 3
MythTV lineups
2011-07-07 11:07:26.610 We should use cached data for this one
2011-07-07 11:07:26.612 Retrieving datadirect data.
2011-07-07 11:07:26.612 Grabbing data for Thu Jul 7 2011 offset 1
2011-07-07 11:07:26.612 From Fri Jul 8 04:00:00 2011 to Sat Jul 9
04:00:00 2011 (UTC)
2011-07-07 11:07:26.612 Grabbing listing data
2011-07-07 11:07:26.612 DataDirect: Copying from DD cache
2011-07-07 11:07:26.719 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:44 PM
2011-07-07 11:07:34.679 Grab complete. Actual data from Fri Jul 8
04:00:00 2011 to Sat Jul 9 04:00:00 2011 (UTC)
2011-07-07 11:07:34.679 Main temp tables populated.
2011-07-07 11:07:34.679 Updating MythTV channels.
2011-07-07 11:07:34.719 IconData: Updating icons for sourceid: 6
2011-07-07 11:07:34.720 Channels updated.
2011-07-07 11:07:35.052 Clearing data for source.
2011-07-07 11:07:35.053 Clearing from Fri Jul 8 00:00:00 2011 to Sat
Jul 9 00:00:00 2011 (localtime)
2011-07-07 11:07:48.185 Data for source cleared.
2011-07-07 11:07:48.185 Updating programs.
2011-07-07 11:08:03.371 Program table update complete.
2011-07-07 11:08:03.374
2011-07-07 11:08:03.374 Checking day @ offset 2, date: Sat Jul 9 2011
2011-07-07 11:08:03.726 Data is already present for Sat Jul 9 2011, skipping
2011-07-07 11:08:03.726
2011-07-07 11:08:03.726 Checking day @ offset 3, date: Sun Jul 10 2011
2011-07-07 11:08:03.901 Data is already present for Sun Jul 10 2011, skipping
2011-07-07 11:08:03.902
2011-07-07 11:08:03.902 Checking day @ offset 4, date: Mon Jul 11 2011
2011-07-07 11:08:04.077 Data is already present for Mon Jul 11 2011, skipping
2011-07-07 11:08:04.078
2011-07-07 11:08:04.078 Checking day @ offset 5, date: Tue Jul 12 2011
2011-07-07 11:08:04.253 Data is already present for Tue Jul 12 2011, skipping
2011-07-07 11:08:04.253
2011-07-07 11:08:04.253 Checking day @ offset 6, date: Wed Jul 13 2011
2011-07-07 11:08:04.425 Data is already present for Wed Jul 13 2011, skipping
2011-07-07 11:08:04.426
2011-07-07 11:08:04.426 Checking day @ offset 7, date: Thu Jul 14 2011
2011-07-07 11:08:04.596 Data is already present for Thu Jul 14 2011, skipping
2011-07-07 11:08:04.596
2011-07-07 11:08:04.596 Checking day @ offset 8, date: Fri Jul 15 2011
2011-07-07 11:08:04.764 Data is already present for Fri Jul 15 2011, skipping
2011-07-07 11:08:04.764
2011-07-07 11:08:04.764 Checking day @ offset 9, date: Sat Jul 16 2011
2011-07-07 11:08:04.930 Data is already present for Sat Jul 16 2011, skipping
2011-07-07 11:08:04.930
2011-07-07 11:08:04.930 Checking day @ offset 10, date: Sun Jul 17 2011
2011-07-07 11:08:05.099 Data is already present for Sun Jul 17 2011, skipping
2011-07-07 11:08:05.099
2011-07-07 11:08:05.099 Checking day @ offset 11, date: Mon Jul 18 2011
2011-07-07 11:08:05.261 Data is already present for Mon Jul 18 2011, skipping
2011-07-07 11:08:05.261
2011-07-07 11:08:05.261 Checking day @ offset 12, date: Tue Jul 19 2011
2011-07-07 11:08:05.422 Data is already present for Tue Jul 19 2011, skipping
2011-07-07 11:08:05.422
2011-07-07 11:08:05.422 Checking day @ offset 13, date: Wed Jul 20 2011
2011-07-07 11:08:05.583 Data refresh needed because only 0 out of 376
channels have at least one program listed for day @ offset 13 from 8PM
- midnight. Previous day had 374 channels with data in that time
period.
2011-07-07 11:08:05.583 Refreshing data for Wed Jul 20 2011
2011-07-07 11:08:05.583 This DataDirect listings source is shared by 3
MythTV lineups
2011-07-07 11:08:05.584 We should use cached data for this one
2011-07-07 11:08:05.584 Retrieving datadirect data.
2011-07-07 11:08:05.584 Grabbing data for Thu Jul 7 2011 offset 13
2011-07-07 11:08:05.584 From Wed Jul 20 04:00:00 2011 to Thu Jul 21
04:00:00 2011 (UTC)
2011-07-07 11:08:05.584 Grabbing listing data
2011-07-07 11:08:05.585 DataDirect: Copying from DD cache
2011-07-07 11:08:05.593 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:44 PM
2011-07-07 11:08:13.058 Grab complete. Actual data from Wed Jul 20
04:00:00 2011 to Thu Jul 21 04:00:00 2011 (UTC)
2011-07-07 11:08:13.094 Main temp tables populated.
2011-07-07 11:08:13.409 Clearing data for source.
2011-07-07 11:08:13.409 Clearing from Wed Jul 20 00:00:00 2011 to Thu
Jul 21 00:00:00 2011 (localtime)
2011-07-07 11:08:21.052 Data for source cleared.
2011-07-07 11:08:21.052 Updating programs.
2011-07-07 11:08:39.260 Program table update complete.
2011-07-07 11:08:39.760 Data fetching complete.
2011-07-07 11:08:39.760 Adjusting program database end times.
2011-07-07 11:08:42.883 4 replacements made
2011-07-07 11:08:42.883 Marking generic episodes.
2011-07-07 11:08:47.864 Found 15924
2011-07-07 11:08:47.864 Fudging non-unique programids with multiple parts.
2011-07-07 11:08:48.279 SH013874890000 -> SH013874890402 (part 2 of 4)
2011-07-07 11:08:48.281 SH013874890000 -> SH013874890401 (part 1 of 4)
2011-07-07 11:08:48.282 SH013874890000 -> SH013874890403 (part 3 of 4)
2011-07-07 11:08:48.282 SH013874890000 -> SH013874890404 (part 4 of 4)
2011-07-07 11:08:48.283 Found 48
2011-07-07 11:08:48.283 Marking repeats.
2011-07-07 11:08:51.884 Found 33948
2011-07-07 11:08:51.884 Unmarking new episode rebroadcast repeats.
2011-07-07 11:08:53.045 Found 0
2011-07-07 11:09:03.744 Marking episode first showings.
2011-07-07 11:09:48.272 Found 36625
2011-07-07 11:09:48.272 Marking episode last showings.
2011-07-07 11:10:22.170 Found 36625
2011-07-07 11:10:22.257 Grabbing next suggested grabbing time
2011-07-07 11:10:22.860 DataDirect: BlockedTime is: 2011-07-07T11:10:22
2011-07-07 11:10:22.860 DataDirect: NextSuggestedTime is: 2011-07-08T14:50:56
2011-07-07 11:10:22.864
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2011-07-07 11:10:22.868 MythCoreContext: Connecting to backend server:
192.168.1.11:6543 (try 1 of 1)
2011-07-07 11:10:22.868 Using protocol version 63
2011-07-07 11:10:29.873 MythSocket(cc3b70:13): readStringList: Error,
timed out after 7000 ms.
2011-07-07 11:10:29.873 MythCoreContext, Error: Timeout connecting
server socket to master backend
2011-07-07 11:10:29.873 Connection to master server timed out.
Either the server is down or the master server settings
in mythtv-settings does not contain the proper
IP address
2011-07-07 11:10:29.873 Error rescheduling id -1 in
ScheduledRecording::signalChange
2011-07-07 11:10:29.873 MythCoreContext: Connecting to backend server:
192.168.1.11:6543 (try 1 of 1)
2011-07-07 11:10:29.874 Using protocol version 63
2011-07-07 11:10:30.668 Received a remote 'Clear Cache' request
2011-07-07 11:10:31.664 mythfilldatabase run complete.
2011-07-07 11:10:31.670 DataDirect: Deleting temporary files
mythtered:/etc/cron.daily# %%
mysql mythconverg
select select chanid, channum, freqid, serviceid, callsign, name,
xmltvid from channel where sourceid = 5 and name like 'Unknown%' order
by freqid +0, serviceid +0;
+--------+---------+--------+-----------+-----------+-----------+---------+
| chanid | channum | freqid | serviceid | callsign | name | xmltvid |
+--------+---------+--------+-----------+-----------+-----------+---------+
| 17721 | 21 | 127 | 12721 | Unknown21 | Unknown21 | 18822 |
| 17722 | 22 | 127 | 12722 | Unknown22 | Unknown22 | 18822 |
| 17729 | 29 | 127 | 12729 | Unknown29 | Unknown29 | 18822 |
| 17731 | 31 | 127 | 12731 | Unknown31 | Unknown31 | 18822 |
| 17733 | 33 | 127 | 12733 | Unknown33 | Unknown33 | 18822 |
| 17734 | 34 | 127 | 12734 | Unknown34 | Unknown34 | 18822 |
| 17840 | 40 | 128 | 12840 | Unknown40 | Unknown40 | 14771 |
| 17843 | 43 | 128 | 12843 | Unknown43 | Unknown43 | 14771 |
+--------+---------+--------+-----------+-----------+-----------+---------+
8 rows in set (0.00 sec)
mysql> select sourceid, chanid, channum, freqid, serviceid, callsign,
name, xmltvid from channel where name like 'history%';
+----------+--------+---------+--------+-----------+----------+-----------------------+---------+
| sourceid | chanid | channum | freqid | serviceid | callsign | name
| xmltvid |
+----------+--------+---------+--------+-----------+----------+-----------------------+---------+
| 6 | 6628 | 628 | 628 | 0 | HSTRYHD |
History HD | 57708 |
| 6 | 6127 | 127 | 127 | 0 | HI |
History International | 18822 |
| 6 | 6128 | 128 | 128 | 0 | HISTORY |
History | 14771 |
| 4 | 4628 | 628 | 628 | 0 | HSTRYHD |
History HD | 57708 |
| 4 | 4127 | 127 | 127 | 0 | HI |
History International | 18822 |
| 4 | 4128 | 128 | 128 | 0 | HISTORY |
History | 14771 |
+----------+--------+---------+--------+-----------+----------+-----------------------+---------+
6 rows in set (0.00 sec)
mysql>
Eric
More information about the mythtv-users
mailing list