[mythtv-users] record live/first showing of sports?

Steven Adeff adeffs.mythtv at gmail.com
Sun Jun 12 14:40:08 UTC 2011


On Sat, Jun 11, 2011 at 3:04 PM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 06/11/2011 02:20 PM, Steven Adeff wrote:
>> switched to Arclight and that option is definitely not there for me in
>> either pre-existing rules or when trying to create a new rule.
>>
>> is this something in the DB that may be missing, or something that
>> Mythbuntu may have "taken out"?
>
> Again, if that option truly isn't shown, it would indicate a
> mythfilldatabase failure--if it crashes before it finishes or
> something.  Do you see:
>
> ===============================================================
> | Attempting to contact the master backend for rescheduling.  |
> | If the master is not running, rescheduling will happen when |
> | the master backend is restarted.                            |
> ===============================================================
>
> at the bottom of your mythfilldatabase log runs?  If not, it may be
> crashing before it checks for repeats.
>
> Please post the output of:
>
> mysql -umythtv -p mythconverg -e "SELECT * FROM settings WHERE value =
> 'HaveRepeats';"
> mysql -umythtv -p mythconverg -e "SELECT count(previouslyshown) FROM
> program WHERE previouslyshown = 1;"

backend log,
2011-06-11 22:31:05.927 We should use cached data for this one
2011-06-11 22:31:05.949 Retrieving datadirect data.
2011-06-11 22:31:05.949 Grabbing data for Sat Jun 11 2011 offset 1
2011-06-11 22:31:05.949 From Sun Jun 12 04:00:00 2011 to Mon Jun 13
04:00:00 2011 (UTC)
2011-06-11 22:31:05.949 Grabbing listing data
2011-06-11 22:31:05.949 DataDirect: Copying from DD cache
2011-06-11 22:31:05.961 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:29 PM
2011-06-11 22:31:15.598 Grab complete.  Actual data from Sun Jun 12
04:00:00 2011 to Mon Jun 13 04:00:00 2011 (UTC)
2011-06-11 22:31:15.599 Main temp tables populated.
2011-06-11 22:31:15.693 Clearing data for source.
2011-06-11 22:31:15.693 Clearing from Sun Jun 12 00:00:00 2011 to Mon
Jun 13 00:00:00 2011 (localtime)
2011-06-11 22:31:16.094 Data for source cleared.
2011-06-11 22:31:16.094 Updating programs.
2011-06-11 22:31:16.521 Program table update complete.
2011-06-11 22:31:16.521
2011-06-11 22:31:16.521 Checking day @ offset 2, date: Mon Jun 13 2011
2011-06-11 22:31:16.521 Data Refresh needed because of user request
2011-06-11 22:31:16.522 Refreshing data for Mon Jun 13 2011
2011-06-11 22:31:16.522 This DataDirect listings source is shared by 3
MythTV lineups
2011-06-11 22:31:16.522 We should use cached data for this one
2011-06-11 22:31:16.542 Retrieving datadirect data.
2011-06-11 22:31:16.542 Grabbing data for Sat Jun 11 2011 offset 2
2011-06-11 22:31:16.542 From Mon Jun 13 04:00:00 2011 to Tue Jun 14
04:00:00 2011 (UTC)
2011-06-11 22:31:16.542 Grabbing listing data
2011-06-11 22:31:16.542 DataDirect: Copying from DD cache
2011-06-11 22:31:16.553 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:29 PM
2011-06-11 22:31:28.014 Grab complete.  Actual data from Mon Jun 13
04:00:00 2011 to Tue Jun 14 04:00:00 2011 (UTC)
2011-06-11 22:31:28.015 Main temp tables populated.
2011-06-11 22:31:28.121 Clearing data for source.
2011-06-11 22:31:28.121 Clearing from Mon Jun 13 00:00:00 2011 to Tue
Jun 14 00:00:00 2011 (localtime)
2011-06-11 22:31:28.585 Data for source cleared.
2011-06-11 22:31:28.586 Updating programs.
2011-06-11 22:31:29.169 Program table update complete.
2011-06-11 22:31:29.169
2011-06-11 22:31:29.169 Checking day @ offset 3, date: Tue Jun 14 2011
2011-06-11 22:31:29.189 Data is already present for Tue Jun 14 2011, skipping
2011-06-11 22:31:29.189
2011-06-11 22:31:29.189 Checking day @ offset 4, date: Wed Jun 15 2011
2011-06-11 22:31:29.208 Data is already present for Wed Jun 15 2011, skipping
2011-06-11 22:31:29.208
2011-06-11 22:31:29.208 Checking day @ offset 5, date: Thu Jun 16 2011
2011-06-11 22:31:29.227 Data is already present for Thu Jun 16 2011, skipping
2011-06-11 22:31:29.227
2011-06-11 22:31:29.227 Checking day @ offset 6, date: Fri Jun 17 2011
2011-06-11 22:31:29.245 Data is already present for Fri Jun 17 2011, skipping
2011-06-11 22:31:29.245
2011-06-11 22:31:29.245 Checking day @ offset 7, date: Sat Jun 18 2011
2011-06-11 22:31:29.264 Data is already present for Sat Jun 18 2011, skipping
2011-06-11 22:31:29.264
2011-06-11 22:31:29.264 Checking day @ offset 8, date: Sun Jun 19 2011
2011-06-11 22:31:29.283 Data is already present for Sun Jun 19 2011, skipping
2011-06-11 22:31:29.283
2011-06-11 22:31:29.283 Checking day @ offset 9, date: Mon Jun 20 2011
2011-06-11 22:31:29.301 Data is already present for Mon Jun 20 2011, skipping
2011-06-11 22:31:29.301
2011-06-11 22:31:29.301 Checking day @ offset 10, date: Tue Jun 21 2011
2011-06-11 22:31:29.319 Data is already present for Tue Jun 21 2011, skipping
2011-06-11 22:31:29.319
2011-06-11 22:31:29.319 Checking day @ offset 11, date: Wed Jun 22 2011
2011-06-11 22:31:29.337 Data is already present for Wed Jun 22 2011, skipping
2011-06-11 22:31:29.337
2011-06-11 22:31:29.337 Checking day @ offset 12, date: Thu Jun 23 2011
2011-06-11 22:31:29.355 Data is already present for Thu Jun 23 2011, skipping
2011-06-11 22:31:29.355
2011-06-11 22:31:29.355 Checking day @ offset 13, date: Fri Jun 24 2011
2011-06-11 22:31:29.373 Data is already present for Fri Jun 24 2011, skipping
2011-06-11 22:31:29.744 Updating source #7 (Comcast Boston Digital
Cable HDPVR) with grabber schedulesdirect1
2011-06-11 22:31:29.745 Found 170 channels for source 7 which use grabber
2011-06-11 22:31:29.745
2011-06-11 22:31:29.745 Checking day @ offset 0, date: Sat Jun 11 2011
2011-06-11 22:31:29.745 Data Refresh needed because of user request
2011-06-11 22:31:29.745 Refreshing data for Sat Jun 11 2011
2011-06-11 22:31:29.745 This DataDirect listings source is shared by 3
MythTV lineups
2011-06-11 22:31:29.745 We should use cached data for this one
2011-06-11 22:31:29.745 Retrieving datadirect data.
2011-06-11 22:31:29.745 Grabbing data for Sat Jun 11 2011 offset 0
2011-06-11 22:31:29.745 From Sat Jun 11 04:00:00 2011 to Sun Jun 12
04:00:00 2011 (UTC)
2011-06-11 22:31:29.745 Grabbing listing data
2011-06-11 22:31:29.745 DataDirect: Copying from DD cache
2011-06-11 22:31:29.752 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:29 PM
2011-06-11 22:31:40.103 Grab complete.  Actual data from Sat Jun 11
04:00:00 2011 to Sun Jun 12 04:00:00 2011 (UTC)
2011-06-11 22:31:40.104 Main temp tables populated.
2011-06-11 22:31:40.104 Updating MythTV channels.
2011-06-11 22:31:40.128 IconData: Updating icons for sourceid: 7
2011-06-11 22:31:40.128 Channels updated.
2011-06-11 22:31:40.299 Clearing data for source.
2011-06-11 22:31:40.299 Clearing from Sat Jun 11 00:00:00 2011 to Sun
Jun 12 00:00:00 2011 (localtime)
2011-06-11 22:31:45.955 Data for source cleared.
2011-06-11 22:31:45.955 Updating programs.
2011-06-11 22:31:48.015 Program table update complete.
2011-06-11 22:31:48.015
2011-06-11 22:31:48.015 Checking day @ offset 1, date: Sun Jun 12 2011
2011-06-11 22:31:48.015 Data Refresh always needed for tomorrow
2011-06-11 22:31:48.015 Refreshing data for Sun Jun 12 2011
2011-06-11 22:31:48.015 This DataDirect listings source is shared by 3
MythTV lineups
2011-06-11 22:31:48.015 We should use cached data for this one
2011-06-11 22:31:48.051 Retrieving datadirect data.
2011-06-11 22:31:48.051 Grabbing data for Sat Jun 11 2011 offset 1
2011-06-11 22:31:48.051 From Sun Jun 12 04:00:00 2011 to Mon Jun 13
04:00:00 2011 (UTC)
2011-06-11 22:31:48.051 Grabbing listing data
2011-06-11 22:31:48.051 DataDirect: Copying from DD cache
2011-06-11 22:31:48.063 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:29 PM
2011-06-11 22:31:57.762 Grab complete.  Actual data from Sun Jun 12
04:00:00 2011 to Mon Jun 13 04:00:00 2011 (UTC)
2011-06-11 22:31:57.763 Main temp tables populated.
2011-06-11 22:31:57.941 Clearing data for source.
2011-06-11 22:31:57.941 Clearing from Sun Jun 12 00:00:00 2011 to Mon
Jun 13 00:00:00 2011 (localtime)
2011-06-11 22:32:00.489 Data for source cleared.
2011-06-11 22:32:00.489 Updating programs.
2011-06-11 22:32:02.406 Program table update complete.
2011-06-11 22:32:02.406
2011-06-11 22:32:02.406 Checking day @ offset 2, date: Mon Jun 13 2011
2011-06-11 22:32:02.406 Data Refresh needed because of user request
2011-06-11 22:32:02.406 Refreshing data for Mon Jun 13 2011
2011-06-11 22:32:02.406 This DataDirect listings source is shared by 3
MythTV lineups
2011-06-11 22:32:02.406 We should use cached data for this one
2011-06-11 22:32:02.423 Retrieving datadirect data.
2011-06-11 22:32:02.423 Grabbing data for Sat Jun 11 2011 offset 2
2011-06-11 22:32:02.423 From Mon Jun 13 04:00:00 2011 to Tue Jun 14
04:00:00 2011 (UTC)
2011-06-11 22:32:02.423 Grabbing listing data
2011-06-11 22:32:02.423 DataDirect: Copying from DD cache
2011-06-11 22:32:02.435 DataDirect: Your subscription expires on Tue
Jun 19 (2012) 10:29 PM
2011-06-11 22:32:13.890 Grab complete.  Actual data from Mon Jun 13
04:00:00 2011 to Tue Jun 14 04:00:00 2011 (UTC)
2011-06-11 22:32:13.891 Main temp tables populated.
2011-06-11 22:32:14.079 Clearing data for source.
2011-06-11 22:32:14.080 Clearing from Mon Jun 13 00:00:00 2011 to Tue
Jun 14 00:00:00 2011 (localtime)
2011-06-11 22:32:16.654 Data for source cleared.
2011-06-11 22:32:16.654 Updating programs.
2011-06-11 22:32:18.711 Program table update complete.
2011-06-11 22:32:18.712
2011-06-11 22:32:18.712 Checking day @ offset 3, date: Tue Jun 14 2011
2011-06-11 22:32:18.828 Data is already present for Tue Jun 14 2011, skipping
2011-06-11 22:32:18.828
2011-06-11 22:32:18.828 Checking day @ offset 4, date: Wed Jun 15 2011
2011-06-11 22:32:18.934 Data is already present for Wed Jun 15 2011, skipping
2011-06-11 22:32:18.935
2011-06-11 22:32:18.935 Checking day @ offset 5, date: Thu Jun 16 2011
2011-06-11 22:32:19.072 Data is already present for Thu Jun 16 2011, skipping
2011-06-11 22:32:19.072
2011-06-11 22:32:19.072 Checking day @ offset 6, date: Fri Jun 17 2011
2011-06-11 22:32:19.191 Data is already present for Fri Jun 17 2011, skipping
2011-06-11 22:32:19.191
2011-06-11 22:32:19.191 Checking day @ offset 7, date: Sat Jun 18 2011
2011-06-11 22:32:19.310 Data is already present for Sat Jun 18 2011, skipping
2011-06-11 22:32:19.310
2011-06-11 22:32:19.310 Checking day @ offset 8, date: Sun Jun 19 2011
2011-06-11 22:32:19.429 Data is already present for Sun Jun 19 2011, skipping
2011-06-11 22:32:19.429
2011-06-11 22:32:19.429 Checking day @ offset 9, date: Mon Jun 20 2011
2011-06-11 22:32:19.533 Data is already present for Mon Jun 20 2011, skipping
2011-06-11 22:32:19.533
2011-06-11 22:32:19.533 Checking day @ offset 10, date: Tue Jun 21 2011
2011-06-11 22:32:19.635 Data is already present for Tue Jun 21 2011, skipping
2011-06-11 22:32:19.635
2011-06-11 22:32:19.635 Checking day @ offset 11, date: Wed Jun 22 2011
2011-06-11 22:32:19.738 Data is already present for Wed Jun 22 2011, skipping
2011-06-11 22:32:19.738
2011-06-11 22:32:19.738 Checking day @ offset 12, date: Thu Jun 23 2011
2011-06-11 22:32:19.844 Data is already present for Thu Jun 23 2011, skipping
2011-06-11 22:32:19.844
2011-06-11 22:32:19.844 Checking day @ offset 13, date: Fri Jun 24 2011
2011-06-11 22:32:19.944 Data is already present for Fri Jun 24 2011, skipping
2011-06-11 22:32:20.265 Data fetching complete.
2011-06-11 22:32:20.265 Adjusting program database end times.
2011-06-11 22:32:23.201     0 replacements made
2011-06-11 22:32:23.203 mythfilldatabase: Listings Download Finished
2011-06-11 22:32:23.204 Marking generic episodes.
2011-06-11 22:32:24.369     Found 8259
2011-06-11 22:32:24.370 Fudging non-unique programids with multiple parts.
2011-06-11 22:32:24.555     MV000498790000 -> MV000498790202 (part 2 of 2)
2011-06-11 22:32:24.556     MV000498790000 -> MV000498790201 (part 1 of 2)
2011-06-11 22:32:24.556     SH006652910000 -> SH006652910201 (part 1 of 2)
2011-06-11 22:32:24.557     SH006652910000 -> SH006652910202 (part 2 of 2)
2011-06-11 22:32:24.558     SH007525660000 -> SH007525660202 (part 2 of 2)
2011-06-11 22:32:24.558     SH007525660000 -> SH007525660201 (part 1 of 2)
2011-06-11 22:32:24.559     MV001088000000 -> MV001088000201 (part 1 of 2)
2011-06-11 22:32:24.559     MV001088000000 -> MV001088000202 (part 2 of 2)
2011-06-11 22:32:24.560     Found 36
2011-06-11 22:32:24.560 Marking repeats.
2011-06-11 22:32:25.618     Found 16735
2011-06-11 22:32:25.618 Unmarking new episode rebroadcast repeats.
2011-06-11 22:32:26.236     Found 0
2011-06-11 22:32:28.247 Marking episode first showings.
2011-06-11 22:32:43.621     Found 22574
2011-06-11 22:32:43.621 Marking episode last showings.
2011-06-11 22:32:59.584     Found 22574
2011-06-11 22:32:59.630 Grabbing next suggested grabbing time
2011-06-11 22:33:00.241 DataDirect: BlockedTime is: 2011-06-11T22:33:00
2011-06-11 22:33:00.242 DataDirect: NextSuggestedTime is: 2011-06-13T16:03:26
2011-06-11 22:33:00.243 DataDirect: Provider suggested running again
at 2011-06-13T16:03:26, but MythFillPeriod is 1.  Next run time will
be adjusted to be 2011-06-12T16:03:26.
2011-06-11 22:33:00.256
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2011-06-11 22:33:00.263 MythCoreContext: Connecting to backend server:
192.168.1.151:6543 (try 1 of 1)
2011-06-11 22:33:00.264 Using protocol version 63
2011-06-11 22:33:00.315 Received a remote 'Clear Cache' request
2011-06-11 22:33:01.315 mythfilldatabase run complete.
2011-06-11 22:33:01.321 DataDirect: Deleting temporary files


@mythbackend:~$ mysql -uroot -p mythconverg -e "SELECT * FROM settings
WHERE value = 'HaveRepeats';"
Enter password:
@mythbackend:~$ mysql -uroot -p mythconverg -e "SELECT
count(previouslyshown) FROM program WHERE previouslyshown = 1;"
Enter password:
+------------------------+
| count(previouslyshown) |
+------------------------+
|                 126502 |
+------------------------+


thanks for the help!

-- 
Steve
http://www.mythtv.org/wiki/User:Steveadeff
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette


More information about the mythtv-users mailing list