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 <[EMAIL PROTECTED]> 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 > <[EMAIL PROTECTED]> 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. > > > > ----------------------- > > [EMAIL PROTECTED]:~/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 > > [email protected] > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > >
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
