[mythtv] Is it normal to rerun the same select query every 8 seconds?

[Karl Dietz]

On 27.08.2012 18:13, Göran Uddeborg wrote:
> Execute   SELECT chanid, useonairguide, channel.sourceid FROM channel, dtv_multiplex WHERE serviceid        = 5620   AND       networkid        = 8945   AND       transportid      = 1021 AND       channel.mplexid  = dtv_multiplex.mplexid

...

> When I run some of the selections manually, I get an empty set all the
> time.  (I haven't tried all of them.)  Which makes me even more
> suspicious of this.
>
> Things do work.  The server is able to handle the work, and watching
> TV works as expected.  But it appears a bit strange, and I got a bit
> suspicious.  So I thought I could ask: is it really normal?  Does it
> make sense for MythTV to repeat these questions over and over?  Or
> could it be an indication of some bug that should be traced?  Either
> in MythTV or in my configuration?

Sounds like the active EIT scanner trying to find the channel for
received EIT data but failing. As there is no negative cache it is
trying over and over again.

Did you delete unwanted channels instead of marking them invisible?

http://code.mythtv.org/cgit/mythtv/tree/mythtv/libs/libmythtv/eithelper.cpp#n657

Looking at the code we don't cache channels that have useonairguide
disabled. Might be a nice optimization to cache these hits at least.

Regards,
Karl