[horde] horde and mysql - too many connections

[Jan Schneider]

Zitat von Tim Winders <twinders at southplainscollege.edu>:

> Hello -
>
> I recently started getting this error message in horde/imp
>
> [horde] DB Error: connect failed:
>     [nativecode=Link to server lost,
>      unable to reconnect] ** Array [on line 108 of
>     "/local/horde-2.2.5/lib/Prefs/sql.php"]
>
> I did some research and this is a mysql error indicating the server is out
> of connections.  Stopping / starting the mysql server process temporarily
> fixes the problem.
>
> If I look at 'SHOW PROCESSLIST' on the mysql server, I see hundreds of
> horde connections in the "Sleep" start with NULL info.
>
> I am running horde-2.2.5 with imp-3.2.4.
>
> I am thinking that we are not getting a mysql_close(); function being
> called somewhere, so the connection to mysql from horde stays open, but I
> am not sure where to look for this.
>
> Is this a problem with mysql or with horde?  Any ideas / suggestions on
> where to start with how to fix this?

Configure your SQL backends to *not* use persistent connections. You should
have found that in the mailing list archives.

Jan.

--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/