[mythtv-users] Schedules Direct Grabbing failure.

[Michael T. Dean]

On 10/04/2012 06:44 PM, R KANNAN wrote:
>
>     Message: 13
>     Date: Wed, 03 Oct 2012 20:24:21 -0400
>     From: "Michael T. Dean" <mtdean at thirdcontact.com
>     <mailto:mtdean at thirdcontact.com>>
>     To: Discussion about MythTV <mythtv-users at mythtv.org
>     <mailto:mythtv-users at mythtv.org>>
>     Subject: Re: [mythtv-users] Schedules Direct Grabbing failure.
>     Message-ID: <506CD735.7070809 at thirdcontact.com
>     <mailto:506CD735.7070809 at thirdcontact.com>>
>     Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>     On 10/03/2012 06:09 PM, R KANNAN wrote:
>     > All,
>     >
>     > For the past three days, mythfilldatabase is failing to populate
>     data
>     > beyond 10/14. Usually SD has data for 14 days.. The output looks
>     like
>     > the following..
>     >
>     ...
>     > content-type missing in HTTP POST, defaulting to
>     application/octet-stream
>     ...
>     > I wonder if there has been a failure to interpret data looking at
>     > :content-type missing in HTTP POST, defaulting to
>     > application/octet-stream" message.
>     >
>     > Any ideas?
>
>     That's unrelated/not relevant.  It's just Qt 4.8 trying to think for
>     developers, so it's doing something we hadn't told it to do.
>
>     If you want proof that it's not causing the issue, feel free to
>     upgrade
>     to 0.26--which has changed our code to make it so that Qt won't do
>     stuff
>     we didn't ask it and to prevent that warning.
>
>     Mike
>
>
>     ------------------------------
>
>     Message: 14
>     Date: Wed, 03 Oct 2012 20:26:05 -0400
>     From: "Michael T. Dean" <mtdean at thirdcontact.com
>     <mailto:mtdean at thirdcontact.com>>
>     To: Discussion about MythTV <mythtv-users at mythtv.org
>     <mailto:mythtv-users at mythtv.org>>
>     Subject: Re: [mythtv-users] Schedules Direct Grabbing failure.
>     Message-ID: <506CD79D.6000407 at thirdcontact.com
>     <mailto:506CD79D.6000407 at thirdcontact.com>>
>     Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>     On 10/03/2012 06:09 PM, R KANNAN wrote:
>     > All,
>     >
>     > For the past three days, mythfilldatabase is failing to populate
>     data
>     > beyond 10/14. Usually SD has data for 14 days.. The output looks
>     like
>     > the following..
>     >
>     ...
>     > 2012-10-03 18:05:11.804778 I  Grabbing data for Wed Oct 3 2012
>     offset 13
>     > 2012-10-03 18:05:11.804808 I  From Tue Oct 16 04:00:00 2012 to
>     Wed Oct
>     > 17 04:00:00 2012 (UTC)
>     >
>     ...
>     > 2012-10-03 18:05:24.065749 I  Grab complete.  Actual data from
>     Sun Oct
>     > 14 04:00:00 2012 to Mon Oct 15 04:00:00 2012 (UTC)
>
>     We asked for data for the 16th and SD/TMS gave us data for the
>     14th.  If
>     the servers don't give us the data we ask for, there's not much we
>     can do.
>
>     I'd suggest you try the "re-add all lineups" (or whatever it's called)
>     button on the Schedules Direct website and see if it helps.
>
>     Mike
>
>
> I tried readding and also  removing & adding line up. I still don'yt 
> seem to be able to grab the data.
>
>
> 2012-10-04 18:34:35.032289 I  DataDirect: Your subscription expires on 
> Mon Dec 17 10:40 AM
> 2012-10-04 18:34:38.875926 I  Grab complete.  Actual data from Sun Oct 
> 14 04:00:00 2012 to Mon Oct 15 04:00:00 2012 (UTC)
> 2012-10-04 18:34:38.876449 I  Main temp tables populated.
> 2012-10-04 18:34:38.949752 I  Clearing data for source.
> 2012-10-04 18:34:38.949808 I  Clearing from Sun Oct 14 00:00:00 2012 
> to Mon Oct 15 00:00:00 2012 (localtime)
>
> I think there may be an issue with my database. Is there a way to 
> check if my database is corrupted and if so how can I go about 
> rebuilding it?

optimize_mythdb.pl will fix crashed MySQL tables, but if it's still 
asking for one day's data and getting some other day's data, that's 
unrelated to your database.  At one point I had thought it possible that 
the problem is Qt 4.8's new time format causing problems, but if so, I'd 
think other users would be having problems, too (and would think that 
you would have started having the problem when you upgraded to Qt 4.8 
rather than at some random time--it doesn't seem like you had just 
upgraded your system/MythTV when this started happening, right?).  I had 
actually done some testing with the date formats that Qt 4.8 is sending 
and they seemed to work for me, so I really don't know what could be 
causing the problem (but I can almost guarantee that it's outside your 
database--just don't know if it's MythTV code (and if so, which code) or 
Schedules Direct/TMS code, or your SD/TMS account, or ...)

Also, please try checking your /tmp directory (or anywhere else) for 
mythtv_dd_cache* directory/directories and if you find them, please 
delete them all then re-run mfdb.

Mike