[mythtv-users] mythfilldatabase does not complete

John Kondis jkondis at yahoo.com
Sun Mar 13 20:41:42 UTC 2005


I don't know if you are having the same problem, but a
couple of months ago my database was corrupted and I
got error messages something like these.  (I can't
remember if they were the same, though.)

I fixed it by running the command "mysqlcheck -r -u
<username> -p<password> mythconverg".  (Repairs a
corrupted database.)  I now have this command run
regularly through crond and I haven't had any problems
since.

...J

--- Roy Murphy <roy.murphy at gmail.com> wrote:

> 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
> 
=== message truncated ===>
_______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 



More information about the mythtv-users mailing list