[mythtv-users] mythfilldatabase does not complete

Sun Mar 6 04:09:00 UTC 2005

I'm seeing a lot of messages like this one from Feb 11th on this list
without a lot of responses. Is this a common error I should be
ignoring?

When I run mythfilldatabase, it seems to be working and, peeking with
mysql, the programs table is getting filled with data, but the run
inevatably ends as follows:

--11:00:42--  http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
           => `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com[206.18.98.160]:80... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to datadirect.webservices.zap2it.com[206.18.98.160]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    [  <=>                                ] 15,637        11.80K/s

11:00:44 (11.80 KB/s) - `-' saved [15637]

Connection timed out.
You probably should modify the Master Server settings
in the setup program and set the proper IP address.
error resceduling id -1 in ScheduledRecording::signalChange

I've checked the Master Server settings. The IP addresses are
correct.. This machine is/will be the Master Server. Mysql runs here.
I've granted priviliges to mythtv@<this machine> where <this machine>
is represented by localhost,  by ip and by hostname.

On Fri, 11 Feb 2005 16:10:28 -0700, Teruel de Campo
<chusty at attglobal.net> wrote:
> ref:
> -mythtv-0.17
> -mysql  Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64)
> -ivtv-0.3.2b
> -Server and client in the same machine
> -amd64
> 
> Problem: after ./setup and run mythfilldatabase, it does not complete. Everything else is working ok.
> 
> Before run mythfilldatabase I am sure that mysql is running. I check mythconverg and it is ok.  I have reviewd almost everything I can find
> and I have followed the instructions one by one and it is always the same  problem. This is not due to mythtv 0.17
> because the same happened with 0.16. I was hopping that the new version would it solve it but....
> Please give any direction where to look at it. I am sure that some of you went through the same problem.
> 
> -----------------------
> tdec at amd64:~/multimedia/mythtv-0.17/setup> mythfilldatabase
> Refreshing Tomorrow's data
> Retrieving datadirect data...
> Grabbing data for Fri Feb 11 2005 offset 1
>  From : Sat Feb 12 07:00:00 2005 To : Sun Feb 13 07:00:00 2005 (UTC)
> --15:28:31--  http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
>             => `-'
> Resolving datadirect.webservices.zap2it.com... 206.18.98.160
> Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
> HTTP request sent, awaiting response... 401 Unauthorized
> Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
> HTTP request sent, awaiting response... 200 OK
> Length: unspecified [text/xml]
> 
>      [                   <=>               ] 164,335       37.44K/s
> 
> 15:28:38 (29.91 KB/s) - `-' saved [164,335]
> 
> Your subscription expires on 04/02/2005 11:00:10 PM
> Grab complete.  Actual data from Sat Feb 12 07:00:00 2005 to Sun Feb 13 07:00:00
>   2005 (UTC)
> Clearing data for source...
> Clearing from Sat Feb 12 00:00:00 2005 to Sun Feb 13 00:00:00 2005 (localtime)
> Data for source cleared...
> Main temp tables populated.  Updating myth channels...
> Updating icons for sourceid: 1
> Channels updated..  Updating programs...
> Fetching data for Fri Feb 11 2005
> Retrieving datadirect data...
> Grabbing data for Fri Feb 11 2005 offset 0
>  From : Fri Feb 11 07:00:00 2005 To : Sat Feb 12 07:00:00 2005 (UTC)
> --15:28:41--  http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
>             => `-'
> Resolving datadirect.webservices.zap2it.com... 206.18.98.160
> Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
> HTTP request sent, awaiting response... 401 Unauthorized
> Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80... connected.
> HTTP request sent, awaiting response... 200 OK
> Length: unspecified [text/xml]
> 
>      [                         <=>         ] 186,462       38.36K/s
> 
> 15:28:48 (30.91 KB/s) - `-' saved [186,462]
> 
> Your subscription expires on 04/02/2005 11:00:10 PM
> Grab complete.  Actual data from Fri Feb 11 07:00:00 2005 to Sat Feb 12 07:00:00
>   2005 (UTC)
> Clearing data for source...
> Clearing from Fri Feb 11 00:00:00 2005 to Sat Feb 12 00:00:00 2005 (localtime)
> Data for source cleared...
> Main temp tables populated.  Updating myth channels...
> Updating icons for sourceid: 1
> Channels updated..  Updating programs...
> DB Error (Inserting into program table):
> Query was:
> INSERT IGNORE INTO program (chanid, starttime, endtime, title, subtitle, descrip
> tion, showtype, category, category_type, airdate, stars, previouslyshown, stereo
> , subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalaird
> ate, colorcode, syndicatedepisodenumber, programid) SELECT chanid, starttime, en
> dtime, title, subtitle, description, showtype, dd_genre.class, category_type, ai
> rdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumb
> er, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd
> _v_program.programid FROM dd_v_program LEFT JOIN dd_genre ON (dd_v_program.progr
> amid = dd_genre.programid AND dd_genre.relevance = '0');
> Driver error was [2/2013]:
> QMYSQL3: Unable to execute query
> Database error was:
> Lost connection to MySQL server during query
> 
> DB Error (Inserting into programrating table):
> Query was:
> INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT chan
> id, starttime, 'MPAA', mpaarating FROM dd_v_program WHERE mpaarating != '';
> Driver error was [2/2002]:
> QMYSQL3: Unable to execute query
> Database error was:
> Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (
> 111)
> 
> ......................other days and the finishes....................................
> ata is already present for Thu Feb 24 2005, skipping
> Adjusting program database end times...
> fix_end_times:  SELECT chanid, starttime, endtime FROM program WHERE (DATE_FORMAT(endtime,"%H%i") = "0000") ORDER BY chanid, starttime; failed!
> fix_end_times failed!
> DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> Driver error was [2/2002]:
> QMYSQL3: Unable to execute query
> Database error was:
> Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
> 
> Marking repeats...found -1
> Unmarking repeats from grabber that fall within our new episode window...found 4
> 2005-02-11 15:28:51.847 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
> Connection timed out.
> You probably should modify the Master Server settings
> in the setup program and set the proper IP address.
> error resceduling id -1 in ScheduledRecording::signalChange
> 
> TIA
> 
> -=terry(Denver)=-
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>