[imp] IMP/Horde crashing help

Robert Misior misior at salem.edu
Tue May 2 10:28:36 PDT 2006


Hello,

I have a big problem with IMP/Horde crashing. The symptoms I'm 
experiencing are almost identical to this message thread: 
http://groups.google.com/group/mailing.www.horde-imp/browse_thread/thread/db7a7d2d1083c9a2/7cbe7d3af8c53e88?lnk=st&q=%5Bemergency%5D+%5Bhorde%5D+DB+Error%3A+connect+failed&rnum=2&hl=en#7cbe7d3af8c53e88 
<http://groups.google.com/group/mailing.www.horde-imp/browse_thread/thread/db7a7d2d1083c9a2/7cbe7d3af8c53e88?lnk=st&q=%5Bemergency%5D+%5Bhorde%5D+DB+Error%3A+connect+failed&rnum=2&hl=en#7cbe7d3af8c53e88>

My system will run fine for few days and then suddenly the memory usage 
will go up the system will start swapping like crazy and becomes  
unusable.  I'm using MySql database.
First I had the db running on the local server when this happen in my 
/tmp/horde.log file I would see messages like this:

*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"]

I decided to move db to another remote server and use TCP connections, 
when the slowdown would happen again I would see in the /tmp/horde.log 
messages like this:
May 02 08:17:10 HORDE [emergency] [horde] DB Error: connect failed:  
[nativecode=Lost connection to MySQL server during query] ** Array [on 
line 1616 of "/var/www/html/horde/lib/Horde/DataTree/sql.php"]
May 02 08:31:53 HORDE [emergency] [horde] DB Error: connect failed:  
[nativecode=Too many connections] ** Array [on line 1615 of 
"/var/www/html/horde/lib/Horde/DataTree/sql.php"]

On the remote server  with MySQL DB I see a lot of  messages like this 
in the log files:
060502 12:25:55 [Warning] Aborted connection 335 to db: 'horde' user: 
'horde' host: `webmail' (Got an error reading communication packets)

Is there a bug? That causes too many connections to the db?

All of this started happening after upgrade, form older version of 
IMP/Horde to the new version, here is more information about my system:

Horde: 3.1.1
Forwards: H3 (3.0)
Gollem: H3 (1.0.2)
Horde: 3.1.1
Imp: H3 (4.1.1)
Ingo: H3 (1.1)
Kronolith: H3 (2.1.1)
Mnemo: H3 (2.1)
Nag: H3 (2.1)
Passwd: H3 (3.0)
Turba: H3 (2.1)
Vacation: H3 (3.0-RC1)

PHP Version: 4.3.9
PHP Major Version: 4.3
PHP Minor Version: 9
PHP Version Classification: release
**
The OS is Linux  CentOS release 4.3, the authentication is done by IMAP, 
this server is only used as the email client no email is stored on it.

Any help or suggestions are highly welcome.
I already increased amount of maximum MySQL connections from 100 to 250 
but  I don't think that will resolve this issue.

Thanks,
Robert



More information about the imp mailing list