[mythtvnz] Mythfilldatabase appears to be trying to retrieve Datadirect listings

[Stephen Worthington]

On Mon, 13 May 2013 12:42:39 +1200, you wrote:

>On Mon, 13 May 2013 12:35:51 +1200, Tim Westbrook <iondiode at gmail.com>  
>wrote:
>
>> On 13 May 2013 11:38, Paulgir <paulgir at gmail.com> wrote:
>>> On Mon, 13 May 2013 10:26:20 +1200, Tim Westbrook <iondiode at gmail.com>
>>> wrote:
>>>
>>>> On 13 May 2013 09:35, Paulgir <paulgir at gmail.com> wrote:
>>>>>
>>>>> On Mon, 13 May 2013 09:19:27 +1200, Nick Rout <nick.rout at gmail.com>
>>>>> wrote:
>>>>>
>>>>>
>>>>>
>>>>> On Mon, May 13, 2013 at 8:49 AM, Paulgir <paulgir at gmail.com> wrote:
>>>>>>
>>>>>>
>>>>>> On Mon, 13 May 2013 08:47:04 +1200, Nick Rout <nick.rout at gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, May 13, 2013 at 8:06 AM, Paulgir <paulgir at gmail.com> wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> After exiting Mythbackend setup yesterday,mythfilldatabase ran and I
>>>>>>> noticed the output was different.Towards the end the process hung
>>>>>>> waiting to
>>>>>>> retrieve Datadirect data:
>>>>>>>
>>>>>>> 2013-05-12 16:35:08.769091 I  Added logging to mythlogserver at
>>>>>>> TCP:35327
>>>>>>> 2013-05-12 16:35:08.809602 I  Grabber prefers method: allatonce
>>>>>>> 2013-05-12 16:35:08.810065 I  XMLTV config file is:
>>>>>>> /home/myth/.mythtv/freeview.xmltv
>>>>>>> 2013-05-12 16:35:08.910452 E  FillData: XMLTV grabber returned error
>>>>>>> code
>>>>>>> 2
>>>>>>> 2013-05-12 16:35:08.911101 E  Error in 1:1: unexpected end of file
>>>>>>> 2013-05-12 16:35:08.911167 I  IconData: Updating icons for  
>>>>>>> sourceid: 1
>>>>>>> 2013-05-12 16:35:08.911676 I  No programs found in data.
>>>>>>> 2013-05-12 16:35:08.912206 I  Updating source #2 () with grabber
>>>>>>> schedulesdirect1
>>>>>>> 2013-05-12 16:35:08.912346 I  No channels are configured to use
>>>>>>> grabber.
>>>>>>> 2013-05-12 16:35:08.912380 I
>>>>>>> 2013-05-12 16:35:08.912387 I  Checking day @ offset 0, date: Sun  
>>>>>>> May 12
>>>>>>> 2013
>>>>>>> 2013-05-12 16:35:08.913064 I  Data refresh needed because no data
>>>>>>> exists
>>>>>>> for day @ offset 0 from 8PM - midnight.
>>>>>>> 2013-05-12 16:35:08.913070 N  Refreshing data for Sun May 12 2013
>>>>>>> 2013-05-12 16:35:08.913114 I  New static DB connectionDataDirectCon
>>>>>>> 2013-05-12 16:35:08.913868 I  Retrieving datadirect data.
>>>>>>> 2013-05-12 16:35:08.913894 I  Grabbing data for Sun May 12 2013  
>>>>>>> offset
>>>>>>> 0
>>>>>>> 2013-05-12 16:35:08.913915 I  From 2013-05-12T00:00:00Z to
>>>>>>> 2013-05-13T00:00:00Z (UTC)
>>>>>>> 2013-05-12 16:35:08.913940 I  DataDirect: Grabbing listing data
>>>>>>> 2013-05-12 16:35:08.913986 I  Downloading DataDirect feed
>>>>>>> 2013-05-12 16:36:08.999789 E  DataDirect: Failed to get data:  
>>>>>>> Download
>>>>>>> error
>>>>>>> 2013-05-12 16:36:08.999798 E  Encountered error in grabbing data.
>>>>>>>
>>>>>>>
>>>>>>> This repeats a few times.I'm not using a grabber at the moment,as I  
>>>>>>> was
>>>>>>> unable to get tv_grab_nz-py to work,so I am using a bash script to
>>>>>>> update
>>>>>>> the schedule."Download Listings" in Mythbackend setup is not
>>>>>>> selected,although it was few weeks ago when I was trying to get  
>>>>>>> things
>>>>>>> working.
>>>>>>>
>>>>>>> Everything appears to work.I just wonder why it is doing this.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Possibly (and really ONLY) because you set it that way.
>>>>>>
>>>>>>
>>>>>> Would you like to suggest which setting that might be?
>>>>>>
>>>>>
>>>>> grabber in mythtv setup - I think in "video source"
>>>>>
>>>>>
>>>>>
>>>>> Grabber is set to 'none' was set to tv_grab_nz-py
>>>>> 'Run EIT scan' is unchecked
>>>>>
>>>>
>>>> These are the settings for source #2? Because that is the one the log
>>>> is complaining about. Did you accidentally add a new source when you
>>>> were in mythsetup?
>>>>
>>>> And it looks like you are still getting that weird script error when
>>>> mythfilldatabase runs the grabber.
>>>>
>>>>> This is why I don't understand why it is doing the Datadirect thing.
>>>>>
>>>>> Paul
>>>>>
>>> I just checked (I thought I was going mad).There is no #2 source listed  
>>> on
>>> the sources page.
>>> The page shows:
>>> Sources
>>> (new source)
>>> Delete all sources
>>> Freeview
>>>
>>> Freeview is the one I set up.
>>> Should I delete all sources and redo it?
>>>
>>>
>>> Paul
>>>
>>> _______________________________________________
>>> mythtvnz mailing list
>>> mythtvnz at lists.linuxnut.co.nz
>>> http://lists.ourshack.com/mailman/listinfo/mythtvnz
>>> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>>
>>
>> Well, If it isn't broken, unless you are really interested in getting
>> rid of that error message, I would leave it alone.
>>
>> It seems like mythfilldatabase "thinks" you have a second source, but
>> it is not giving you any listings, so shouldn't break any of your
>> current listings or the listings from the nz grabber.
>>
>> But in my experience, doing things in a broken area can cause
>> unexpected behaviour.
>>
>> YMMV
>>
>> Cheers,
>> Tim
>>
>The only thing that bothers me is that Mythfilldatabase hangs for a long  
>time (10 minutes or more,sometimes) trying to get data.Then eventually  
>gives an error.
>
>Paul

If you are up for a bit of SQL (having backed up your database first),
then this will show all your sources:

  select * from videosource;

And these will show any uses of sources other than sourceid=1 in other
parts of the database:

  select count(*) from cardinput where sourceid!=1;
  select count(*) from channel where sourceid!=1;
  select count(*) from dtv_multiplex where sourceid!=1;
  select count(*) from channelscan where sourceid!=1;

If there are any extra sources in videosource that are not referenced
in cardinput, channel or dtv_multiplex, then you can just delete them
like this:

  delete from videosource where sourceid=2;

Use of other sources in channelscan does not matter, so you can just
leave that data if there is any, or delete it:

  delete from channelscan where sourceid!=1;