[mythtv-users] Live TV being hammered by channel change commands

Bill Meek keemllib at gmail.com
Tue Oct 4 17:38:05 UTC 2011


On 10/04/2011 03:14 AM, Wayne Thomas wrote:
...
>   Would it be worth clearing this table of all the old detritus
> (and maybe some others) or not?

Hi,

A very database-savvy-developer once mentioned on this list that; even
he didn't make changes via SQL. So I don't (nor do I recommend it.)
At least not without doing a backup and knowing not to run on those
changes, but rather to restore the backup after testing.

I believe the NETWORK_CONTROL CHANID message is an /event/ being sent
from:

   libs/libmythtv/mhi.cpp

not the Network Control we've beaten to death verifying is turned
off in your database.

I modified this query from the file above (please try it):

   SELECT networkid, transportid, serviceid
      FROM channel, dtv_multiplex
          WHERE chanid = 3035 AND
              channel.mplexid  = dtv_multiplex.mplexid;

Are your/were you in BBC land and have/had some special tuning program?
I'm looking at the log with:

   GetBootInfo ResidentProgram is not implemented
   SI_TuneIndexInfo ResidentProgram is not implemented

and: http://code.mythtv.org/trac/ticket/9867 (its too new, but a hint.)
I don't know how this is set up. Perhaps just -v mheg logging will be a
clue.

Since you already deleted all cards & channels and rescanned, my next
step would to be more logging, as in -v all (or all,debug if that exists
in 0.22) looking for more hints. And that would be for both mythbackend
and mythfrontend.  With vi or less, look at the output and search for
3035. See if there's a query result that shows the table being accessed
etc.

Good luck,

Bill


More information about the mythtv-users mailing list