[mythtv-users] Problem with SchedulesDirect, was working and now it's not

[Kevin Ould]

Hi everyone,

I have been having an issue with my SchedulesDirect updates since at least
yesterday. I noticed the problem as I was updating my channels and the newly
updated channels were not getting any guide data for these channels. In fact
I am not getting guide data for any channels now. I did have an issue
yesterday where my hard drive filled up with some log files I wasn't keeping
an eye on. I rectified that problem and rebooted the machine and everything
appeared to be working ok again, I am not sure exactly when the guide issues
started, wether it was before or after my full hard drive issue. I tried
rescanning my OTA HD tuner just now to see if it would make a difference, it
did fill in the xmltvids and chan icons but no guide data. Earlier I emptied
the "Program" table as I thought maybe there was some corruption and figured
it might fix my issues. Anyways here is a log of my latest attempt, it
basically will show the same thing for all my lineups:

2007-09-09 10:53:56.792 Using runtime prefix = /usr/local
2007-09-09 10:53:56.814 New DB connection, total: 1
2007-09-09 10:53:56.818 Connected to database 'mythconverg' at host:
localhost
2007-09-09 10:53:56.822 New DB connection, total: 2
2007-09-09 10:53:56.823 Connected to database 'mythconverg' at host:
localhost
2007-09-09 10:53:56.823 Updating source #1 (*****) with grabber
schedulesdirect1
2007-09-09 10:53:56.824 Found 110 channels for source 1 which use grabber
2007-09-09 10:53:56.825
2007-09-09 10:53:56.825 Checking day @ offset 0, date: Sun Sep 9 2007
2007-09-09 10:53:56.825 Data Refresh needed because user specified
--refresh-today
2007-09-09 10:53:56.825 Refreshing data for Sun Sep 9 2007
2007-09-09 10:53:56.825 This DataDirect listings source is shared by 4
MythTV lineups
2007-09-09 10:53:56.825 We should keep data around after this one
2007-09-09 10:53:56.826 New DB DataDirect connection
2007-09-09 10:53:56.826 Connected to database 'mythconverg' at host:
localhost
2007-09-09 10:53:56.826 Retrieving datadirect data.
2007-09-09 10:53:56.827 Grabbing data for Sun Sep 9 2007 offset 0
2007-09-09 10:53:56.827 From Sun Sep 9 04:00:00 2007 to Mon Sep 10 04:00:00
2007 (UTC)
2007-09-09 10:53:56.827 Grabbing listing data
2007-09-09 10:53:56.831 DataDirect: Saving listings to DD cache
--10:53:56--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
           => `-'
Resolving webservices.schedulesdirect.tmsdatadirect.com... 206.18.98.175
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to
webservices.schedulesdirect.tmsdatadirect.com:80.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    [  <=>                                ] 762,490      117.08K/s


10:54:45 (16.14 KB/s) - `-' saved [762490]

2007-09-09 10:54:46.142 DataDirect: Your subscription expires on 03/12/07
06:24:17 PM
2007-09-09 10:54:46.784 New DB connection, total: 3
2007-09-09 10:54:46.784 Connected to database 'mythconverg' at host:
localhost
2007-09-09 10:54:46.784 sourceid 1 has lineup type: Satellite
2007-09-09 10:54:46.935 sourceid 2 has lineup type: Satellite
2007-09-09 10:54:46.946 sourceid 3 has lineup type: LocalBroadcast
2007-09-09 10:54:47.190 sourceid 7 has lineup type: Satellite
2007-09-09 10:55:04.509 Grab complete.  Actual data from Sun Sep 9 04:00:00
2007 to Mon Sep 10 04:00:00 2007 (UTC)
2007-09-09 10:55:04.509 Main temp tables populated.
2007-09-09 10:55:04.509 Updating myth channels.
2007-09-09 10:55:05.451 Updating icons for sourceid: 1
2007-09-09 10:55:05.452 Channels updated.
2007-09-09 10:55:05.453 DataDirect, Error: UpdateProgramViewTable no
dd_state!
2007-09-09 10:55:05.453 Did not find any new program data.


I am thinking it may have something to do with this line "2007-09-09 10:55:
05.453 DataDirect, Error: UpdateProgramViewTable no dd_state!" but I am not
sure what that means and I can't find much info on this error. This is
really frustrating as I now have no guide data as I stupidly emptied the
"Program" table of all its data. As I mentioned my schedulesdirect data was
working fine for about a week or so with no issues until sometime yesterday
as far as I can tell. Any help would be greatly appreciated.

Thanks,

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070909/1ae7517f/attachment.htm