[horde] Sweating Bullets!! Help!

Tue Mar 28 17:57:17 PST 2006

Hi bill,

I posted this already... but here it is again (so it shows in this
branch of the thread):

---------------------------------------------------------------
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"]
Mar 28 20:03:39 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"]
Mar 28 20:03:39 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"]
Mar 28 20:03:40 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"]
Mar 28 20:03:40 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"]
Mar 28 20:03:40 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"]
Mar 28 20:03:51 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"]
--------------------------------------------------------------------------------

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?

Any ideas?

Thanks.

Chris

Bill Graham wrote:

> How about /tmp/  ?
>
> Like horde log
>
> Bill
>
>
> Quoting Chris <grooveman at comcast.net>:
>
>>
>>
>> Craig White wrote:
>>
>>> On Tue, 2006-03-28 at 19:31 -0500, Chris wrote:
>>>
>>>
>>>> Hello everyone,
>>>>
>>>> I am in trouble here.  I have had horde up and running beautifully for
>>>> about 3 months now.  Now, all-of-a-sudden, it has become extremely
>>>> slow.  Every time a page needs to load, it takes like 6 or 7 minutes!
>>>> This is bad news!
>>>>
>>>> I am running Openbsd 3.8.  I am using horde 3.0.9 with Imp 4.0.4, Ingo
>>>> 1.0.2, Gollem 1.0.1(sql backend), Kronolith2.0.6, Turba 2.0.5 and
>>>> Nag 2.0.4.
>>>>
>>>> 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%.
>>>>
>>>> The hard drive is running great.  fsck comes back with no errors, and
>>>> throughput is smokin'.
>>>>
>>>> I have ruled-out imap, as I have configured a few mail clients, and it
>>>> works very smoothly and quickly.  SMTP is likewise functioning
>>>> normally.
>>>>
>>>> The problem only occurs when hitting it from the web interface.  I
>>>> have
>>>> tried this on a machine directly next to this one, plugged into the
>>>> same
>>>> switch and machines across the Internet -- no difference in
>>>> performance.  All other servers on the same segment are performing as
>>>> normal.  Not a network issue.
>>>>
>>>> I had a small db error in my horde.log, but I restored my db, the
>>>> error
>>>> is gone, but the problems persist.
>>>>
>>>> This all started today without warning.  No one has touched this
>>>> box in
>>>> over a month.  All log files I can think of look nominal.  No
>>>> significant errors.  I cannot find anything that could account for
>>>> this!
>>>>
>>>> I have rebooted, restarted apache a million times, restarted the db,
>>>> deleted and recreated the unix socket, cleared the tmp directory and
>>>> restored the database.  Nothing seems to make a difference.
>>>>
>>>> If I restart apache, I get about 20 seconds of normal behaviour on the
>>>> web client, after that, it suddenly degrades to 6-7 minutes lag per
>>>> page.
>>>>
>>>> HELP!  I'm totally at a loss!
>>>>
>>>>
>>> ----
>>> big log files...they can really slow things down.
>>>
>>> check the syslogs, apache logs, horde.log...
>>>
>>> serving other web pages or db's out of that server? Check the speed on
>>> them.
>>>
>>> Craig
>>>
>>>
>>>
>> I have scrapped all the log files in /var/www/tmp, /var/log and
>> /var/www/logs.  I have run mysqlcheck with the --auto-repair switch as
>> well.  No improvement.
>>
>> There are no other databases on this server other than the horde
>> database.  No other websites than the horde interface.
>>
>> Anything else you can think of 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
>>
>> -- 
>> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>
>
>
>

-- 
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