[mythtv-users] Schedules Direct Grabbing failure. [SOLVED]

[R KANNAN]

> >
> >     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
>
>
I found the problem. I had run mthfilldatabase as 'root' On Oct 1. It
filled the data till 10/14 and left a file called /tmp/mythtv_ddp_data
with no write permissions for anyone. After I deleted the file and ran
'mythfilldatabase', it worked fine. and got data for 5 days.

Thanks for your help. Now I am back to figuring out why my recording stop
after 320 MB when there is plenty of space available. I get messages like..

AutoExpire: Filesystem Info cache is empty, unable to determine what
Recordings to expire

and the recording stops.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121004/fe216421/attachment.html>