[mythtv-users] mythfilldatabase does not complete

Sun Mar 13 19:50:36 UTC 2005

No help from anyone? How can I find the specific SQL atatements which
are failing when I get this error message from mythfilldatabase:

error resceduling id -1 in ScheduledRecording::signalChange

On Sat, 5 Mar 2005 23:09:00 -0500, Roy Murphy <roy.murphy at gmail.com> wrote:
> 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
> >
>