[horde] Sweating Bullets!! Help!

[Chris]

Thank Eric,

Pardon the in-line response... but it is just clearer this way...



Eric Jon Rostetter wrote:

>Quoting Chris <grooveman at comcast.net>:
>
>  
>
>>Okay --  My horde.log is now filling up with:
>>
>>---------------------------------------------------------------
>>Mar 28 20:03:21 HORDE [emergency] [horde] DB Error: connect failed:
>>[nativecode=Can't connect to local MySQL server through socket
>>'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
>>"/htdocs/horde/lib/Horde/DataTree/sql.php"]
>>    
>>
>
>Okay, you have some choices here...
>
>1) You have fewer mysql connections allowed than you have apache
>children allowed.  Apache/php is using persistent connections (one
>permanent connection to the DB for each apache child) and you are
>running out of available processes.
>
>Solution: Configure Horde not to use persistent connections (not
>recommended) or configure mysql to allow at least as many connections
>as apache can spawn children.
>
>  
>
I have increased max_connections to 250... wayyyyy more than httpd children.

>2) Your mysql server is getting hosed and hung.  Can you query it via
>another means when this is happening?
>
>Solution: unknown.
>
>  
>
Yes, I can query it just fine using mysql.

>3) Something else on your system is hosing the mysql socket.
>
>Solution: fix whatever is broken.
>  
>
The socket looks fine, I have destroyed and recreated it a dozen times
now.. the perms are appropriate as well..

>4) Your horde history table has hit critical mass and needs to be trimed.
>  
>
I have cleared out everything in horde_datatree where
group_id=horde.history (717 items).

>Solution: Update, trim, or empty your horde history table.
>
>  
>
>>This error was present, then when I restored the db it disappeared.  Now
>>it is back again.  The restore was from 2 days ago... there were no
>>problems two days ago, so I am confused.  Why am I seeing this again?
>>    
>>
>
>You say it runs great for a few minutes after restarting apache.  That would
>be before apache spawns off a lot of children.  Once apache gets enough
>children, you could run out of mysql connections...
>  
>
I don't think so, and certainly not with the max_connections=250
variable set.  I am the only on on right now, and that is only one
connection....

>  
>
>>Any ideas?
>>    
>>
>
>I'd bet you need more mysql connections, but then again, I don't
>even run mysql, so what do I know.
>
>  
>
>>>The machine is a Pentum IV 3.0ghz machine with 2 gigs of ram.  I have
>>>been watching Top for hours now, and the CPU never spikes above 5%.  The
>>>processes at the top are httpd and perl, and they are at 0%.
>>>      
>>>
>
>There is absolutely no perl in Horde, so I'm not sure why you see perl
>at all, since you said the machine runs nothing else.
>  
>
Yes, that much is probably true, but I do have smtp-vilter and clamd
running.  They may.

So, unfortunately, I have done all you mention here, and the problem
persists...

I don't know what else I can do... am I screwed here?



-- 
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,

Chris