[mythtv-users] Very Slow EPG - Need to restore (or delete) all channel icons

[Noel Murphy]

I just wanted to add some to this.

I took Michael's suggestion about wiping the paths out of the  
database, (sql: UPDATE channel SET icon = 'none';) and sure enough  
that solved the problem for about a 24 hour period. Probably until  
mythfillDB ran again.

As for running the backend as root vs. a different user, this is  
where my newbie linux knowledge shines. How do I change which user  
starts up a process when it is started up automatically at bootup? I  
just followed Jarod's guide to get where I am.

Also, what I've noticed is that in the database, all the icon path  
entries are pointing to the mythuser directory (not the root one):

ex. //.mythtv/channels/ae.jpg

So you were right in that the problem just came back after an update.  
Here's the one thing that I can think of that changed with 18.1 to  
19, in terms of my setup.

I used to run mythfillDB from a cron job (again, from Jarod's guide),  
but with 19, I turned on the option to let myth call mythfillDB. I  
did this to take advantage of letting the listings service dictate  
when my next update time was, instead of my cron job always running  
at the same time.

I can turn this option off and switch back for a bit to see if that  
is in fact the issue.

In any case, why can I never actually get the images? I don't have  
them in either my root user folder OR my mythuser folder. Just the  
paths in the DB to files that don't exist?

Noel




On 6-Mar-06, at 4:56 PM, Michael T. Dean wrote:

> On 03/06/2006 02:44 PM, Noel Murphy wrote:
>> So I almost never bring up the EPG but I did on the weekend. This is
>> the first time since the upgrade to .19
>>
>> It was unusable slow. I looked at the logs and see that it trying to
>> find the channel icons and they don't exist. They used to, but don't
>> anymore. A couple things here confuse me.
>>
>> 1. They used to be in /home/mythuser/.mythv/channels/, but the logs
>> are looking in /root/.mythtv/channels. They've never been in the root
>> folder. They used to be in the mythuser folder. The channels folder
>> is still there, but it is empty. The root/.mythtv folder doesn't even
>> have the empty channels folder.
>>
>
> You are starting mythbackend as the root user, so the HOME environment
> variable refers to /root.  You should start mythbackend as the  
> mythuser
> user so that HOME refers to /home/mythuser.
>
> The only location mythfilldatabase will use when updating icons is
> $HOME/.mythtv/channels.  However, if you have icons already (even if
> they're in another location), mfdb should not be updating them.   
> Someone
> else mentioned mfdb always trying to update his icons--even when they
> already exist--in another thread (
> http://www.gossamer-threads.com/lists/mythtv/users/187266#187266 ),  
> but
> I've never seen this behavior, so I haven't made time to look into it.
> I have 13 channels through DISH network, and the only time mfdb ever
> tries to update channel icons is when TMS adds new channels to my  
> lineup
> (like once or twice a week) and only for the new channels.
>
>> 2. Using the tip from Jarod's site, I thought I'd restore my channel
>> icons. The first line worked (the perl script that creates
>> iconmap.xml) and sets all the url files in the /tmp folder, but the
>> 2nd line does not. It tries to connect to the database and then I get
>> this:
>>
>> ===============================================================
>> | Attempting to contact the master backend for rescheduling.  |
>> | If the master is not running, rescheduling will happen when |
>> | the master backend is restarted.                            |
>> ===============================================================
>>
>> But I know the backend is running. Any thoughts? I've tried this as
>> mythuser and I tried to sudo it, in case that was the issue.
>>
>
> This message is always shown.  It is not an error or a warning, just
> information explaining what's happening.  This does not mean the
> mythfilldatabase command is failing,
>
>> 3. I'd be willing to do without the icons even. Is there a way to
>> blanket delete them all from the Database, using the UI? (I can run
>> an SQL statement if required, but I'd feel more comfortable not)
>
> No.  You could do an
>
> UPDATE channel SET icon = 'none';
>
> Although, if your machine always replaces the icons--like Tom said his
> does--you'll have the same problem again after the next run of mfdb...
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users