<blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; ">
<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica; ">Try a command-line run with --dd-grab-all and see if it helps. If so, <br>see <a href="http://www.gossamer-threads.com/lists/mythtv/users/449426#449426" rel="nofollow" target="_blank" style="color: rgb(0, 0, 187); ">http://www.gossamer-threads.com/lists/mythtv/users/449426#449426</a> and <br>
<a href="http://www.gossamer-threads.com/lists/mythtv/commits/449416#449416" rel="nofollow" target="_blank" style="color: rgb(0, 0, 187); ">http://www.gossamer-threads.com/lists/mythtv/commits/449416#449416</a> . <br><br>
If not (actually, even if so--the --dd-grab-all would just be a <br>workaround that may prevent triggering the issue), I'd guess it's one of <br>those mysql server deadlock issues that seem to be plaguing users of new <br>
mysqld versions. See <br><a href="http://www.gossamer-threads.com/lists/mythtv/commits/482305#482305" rel="nofollow" target="_blank" style="color: rgb(0, 0, 187); ">http://www.gossamer-threads.com/lists/mythtv/commits/482305#482305</a> + the <br>
rest of the ticket/thread. (And if the query cache stuff helps, please <br>let us know which mysqld version you're using. Thanks.) <br><br>Mike </span></blockquote><div><br></div><div>Thanks for the info Mike. This doesn't seem to be helping me, as the grab is just sitting like it always does. Below is a log entry from cron with mythfilldatabase running as usual.</div>
<div> </div><div><div>2011-07-15 07:53:31.345 Checking day @ offset 13, date: Thu Jul 28 2011</div><div>2011-07-15 07:53:31.346 Data refresh needed because no data exists for day @ offset 13 from 8PM - midnight.</div><div>
2011-07-15 07:53:31.346 Refreshing data for Thu Jul 28 2011</div><div>2011-07-15 07:53:31.347 Retrieving datadirect data.</div><div>2011-07-15 07:53:31.347 Grabbing data for Fri Jul 15 2011 offset 13</div><div>2011-07-15 07:53:31.347 From Thu Jul 28 04:00:00 2011 to Fri Jul 29 04:00:00 2011 (UTC)</div>
<div>2011-07-15 07:53:31.347 Grabbing listing data</div><div>--2011-07-15 07:53:31-- <a href="http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService">http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService</a></div>
<div>Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53</div><div>Connecting to <a href="http://webservices.schedulesdirect.tmsdatadirect.com">webservices.schedulesdirect.tmsdatadirect.com</a>|144.142.232.53|:80... connected.</div>
<div>HTTP request sent, awaiting response... 401 Unauthorized</div><div>Connecting to <a href="http://webservices.schedulesdirect.tmsdatadirect.com">webservices.schedulesdirect.tmsdatadirect.com</a>|144.142.232.53|:80... connected.</div>
<div>HTTP request sent, awaiting response... 200 OK</div><div>Length: unspecified [text/xml]</div><div>Saving to: `STDOUT'</div><div><br></div><div> 0K .......... .......... .......... .......... .......... 6.53K</div>
<div> 50K .........2011-07-15 07:53:39.978 DataDirect: Your subscription expires on Tue Jun 19 (2012) 10:45 PM</div><div>. .......... .......... .......... .......... 445</div><div> 100K .......... .......... .......... .......... .......... 299</div>
<div> 150K .......... .......... .......... .......... .......... 1.03K</div><div> 200K .......... .......... .. 1.05K=6m4s</div><div><br></div><div>2011-07-15 08:14:35 (626 B/s) - Read error at byte 227872 (Connection timed out).Retrying.</div>
<div><br></div><div>--2011-07-15 08:14:36-- (try: 2) <a href="http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService">http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService</a></div>
<div>Connecting to <a href="http://webservices.schedulesdirect.tmsdatadirect.com">webservices.schedulesdirect.tmsdatadirect.com</a>|144.142.232.53|:80... connected.</div><div>HTTP request sent, awaiting response... 401 Unauthorized</div>
<div>Connecting to <a href="http://webservices.schedulesdirect.tmsdatadirect.com">webservices.schedulesdirect.tmsdatadirect.com</a>|144.142.232.53|:80... connected.</div><div>HTTP request sent, awaiting response... 200 OK</div>
<div><br></div><div> The file is already fully retrieved; nothing to do.</div><div><br></div><div><br></div><div>gzip: stdin: unexpected end of file</div><div>2011-07-15 08:14:58.111 DataDirect, Error: DataDirect XML failed to properly parse, downloaded listings were probably corrupt.</div>
<div>2011-07-15 08:14:58.112 Encountered error in grabbing data.</div><div>2011-07-15 08:14:58.112 Failed to fetch some program info</div></div><div><br></div>