[mythtv-users] SchedulesDirect Not Downloading

[Michael T. Dean]

On 07/09/2011 10:48 AM, Ben Curtis wrote:
> Is anyone else having issues with SchedulesDirect data downloading? I 
> get the following:
>
> 2011-07-09 10:43:58.372 Using runtime prefix = /usr
> 2011-07-09 10:43:58.372 Using configuration directory = /root/.mythtv
> 2011-07-09 10:43:58.372 DBPassword is not set in mysql.txt
> 2011-07-09 10:43:58.372 Empty LocalHostName.
> 2011-07-09 10:43:58.372 Using localhost value of server
> 2011-07-09 10:43:58.378 New DB connection, total: 1
> 2011-07-09 10:43:58.380 Connected to database 'mythconverg' at host: 
> localhost
> 2011-07-09 10:43:58.383 Closing DB connection named 'DBManager0'
> 2011-07-09 10:43:58.384 Connected to database 'mythconverg' at host: 
> localhost
> 2011-07-09 10:43:58.385 Current locale en_US
> 2011-07-09 10:43:58.385 Reading locale defaults from 
> /usr/share/mythtv//locales/en_us.xml
> 2011-07-09 10:43:58.390 Loading en_us translation for module mythfrontend
> 2011-07-09 10:43:58.391 Current MythTV Schema Version (DBSchemaVer): 1264
> 2011-07-09 10:43:58.392 New DB connection, total: 2
> 2011-07-09 10:43:58.392 Connected to database 'mythconverg' at host: 
> localhost
> 2011-07-09 10:43:58.400 Updating source #2 (Transmitted) with grabber 
> schedulesdirect1
> 2011-07-09 10:43:58.400 Found 19 channels for source 2 which use grabber
> 2011-07-09 10:43:58.400
> 2011-07-09 10:43:58.400 Checking day @ offset 0, date: Sat Jul 9 2011
> 2011-07-09 10:43:58.401 Data refresh needed because no data exists for 
> day @ offset 0 from 8PM - midnight.
> 2011-07-09 10:43:58.401 Refreshing data for Sat Jul 9 2011
> 2011-07-09 10:43:58.401 New DB DataDirect connection
> 2011-07-09 10:43:58.402 Connected to database 'mythconverg' at host: 
> localhost
> 2011-07-09 10:43:58.402 Retrieving datadirect data.
> 2011-07-09 10:43:58.402 Grabbing data for Sat Jul 9 2011 offset 0
> 2011-07-09 10:43:58.402 From Sat Jul 9 04:00:00 2011 to Sun Jul 10 
> 04:00:00 2011 (UTC)
> 2011-07-09 10:43:58.402 Grabbing listing data
> --2011-07-09 10:43:58-- 
> http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
> Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
> Connecting to webservices.schedulesdirect.tmsdatadirect.com 
> <http://webservices.schedulesdirect.tmsdatadirect.com>|144.142.232.53|:80... 
> connected.
> HTTP request sent, awaiting response... 401 Unauthorized
> Connecting to webservices.schedulesdirect.tmsdatadirect.com 
> <http://webservices.schedulesdirect.tmsdatadirect.com>|144.142.232.53|:80... 
> connected.
> HTTP request sent, awaiting response... 200 OK
> Length: unspecified [text/xml]
> Saving to: âSTDOUTâ
>
>     [ <=>                                                             
>                                                                       
>                                                                       
>                                                                       
>                                                                       
>                                                                       
>                                                                       
>                                 ] 65,042      14.0K/s             
>  2011-07-09 10:44:03.881 New DB connection, total: 3
> 2011-07-09 10:44:03.882 Connected to database 'mythconverg' at host: 
> localhost
> 2011-07-09 10:44:03.883 DataDirect: Your subscription expires on Tue 
> Jun 19 (2012) 10:45 PM
> 2011-07-09 10:44:30.854 sourceid 2 has lineup type: LocalBroadcast
>
> And as the next download starts, it just sits forever. It's apparently 
> been happening for a while, as all of my listings are "Unknown". 
> Funning FC15 with the atrpms packages installed. Any thoughts?
>

Try a command-line run with --dd-grab-all and see if it helps.  If so, 
see http://www.gossamer-threads.com/lists/mythtv/users/449426#449426 and 
http://www.gossamer-threads.com/lists/mythtv/commits/449416#449416 .

If not (actually, even if so--the --dd-grab-all would just be a 
workaround that may prevent triggering the issue), I'd guess it's one of 
those mysql server deadlock issues that seem to be plaguing users of new 
mysqld versions.  See 
http://www.gossamer-threads.com/lists/mythtv/commits/482305#482305 + the 
rest of the ticket/thread.  (And if the query cache stuff helps, please 
let us know which mysqld version you're using.  Thanks.)

Mike