Mailing List Archive: mythfilldatabas error/problem

On Wednesday 06 November 2002 06:42 pm, Calvin Harrigan wrote:
> Hi all, I was going through the archive today tracking the problem we've
> been having with mythfilldatabase. I just wanted to add that if
> unchecked, pronounced left it running all night, it will use a lot of
> disk space. The actual file is mysql.log file in /var/log/mysql
> directory. I've included a snippet of what's repeated in the log, just
> in case it's usefull to Isaac or anyone else:
>
> I am currently updating to the current cvs and will try it again...

As Robert Kulagowski confirmed last night, its fixed.

> This is continuously repeated from 0-128 up to 1.8 GB!!!
>

> 21 Query SELECT channum,callsign,icon FROM channel WHERE channum = 0
> 21 Query SELECT channum,callsign,icon FROM channel WHERE channum = 128

These queries don't come from mythfilldatabase. They're from a pre-August
29th version of the guidegrid -- that's only place such a query would loop
like that. The mythfilldatabase looping issue would produce quries like:

SELECT channum FROM channel where chanid = x;

But that doesn't really matter, as it's been fixed.

Isaac