[Tickets #13032] ActiveSync: Too many connections due to MySQL sleep processes

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/13032
------------------------------------------------------------------------------
  Ticket             | 13032
  Created By         | chrissi at amusing.de
  Summary            | ActiveSync: Too many connections due to MySQL sleep
                     | processes
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


chrissi at amusing.de (2014-03-11 10:58) wrote:

Hello,

today I updated my horde packages through pear. These are the updated  
packages:

upgrade ok: channel://pear.horde.org/Horde_Browser-2.0.5
upgrade ok: channel://pear.horde.org/Horde_Url-2.2.2
upgrade ok: channel://pear.horde.org/Horde_Mime-2.3.0
upgrade ok: channel://pear.horde.org/Horde_Group-2.0.3
upgrade ok: channel://pear.horde.org/Horde_Date-2.0.8
upgrade ok: channel://pear.horde.org/Horde_Css_Parser-1.0.4
upgrade ok: channel://pear.horde.org/Horde_Http-2.0.5
upgrade ok: channel://pear.horde.org/Horde_Vfs-2.2.0
upgrade ok: channel://pear.horde.org/Horde_Autoloader-2.1.0
upgrade ok: channel://pear.horde.org/Horde_Auth-2.1.2
upgrade ok: channel://pear.horde.org/Horde_SessionHandler-2.2.4
upgrade ok: channel://pear.php.net/File_Find-1.3.3
upgrade ok: channel://pear.php.net/Text_CAPTCHA-1.0.2
upgrade ok: channel://pecl.php.net/pecl_http-1.7.6
upgrade ok: channel://pear.horde.org/Horde_Db-2.1.0
upgrade ok: channel://pear.horde.org/Horde_Form-2.0.7
upgrade ok: channel://pear.horde.org/Horde_Editor-2.0.4
upgrade ok: channel://pear.horde.org/Horde_ActiveSync-2.13.1
upgrade ok: channel://pear.horde.org/Horde_Alarm-2.1.0
upgrade ok: channel://pear.horde.org/Horde_Timezone-1.0.5
upgrade ok: channel://pear.horde.org/Horde_Crypt-2.4.1
upgrade ok: channel://pear.horde.org/Horde_Imap_Client-2.19.0
upgrade ok: channel://pear.horde.org/Horde_Dav-1.0.4
upgrade ok: channel://pear.horde.org/horde-5.1.6
upgrade ok: channel://pear.horde.org/Horde_Share-2.0.5
upgrade ok: channel://pear.horde.org/imp-6.1.7
upgrade ok: channel://pear.horde.org/nag-4.1.4
upgrade ok: channel://pear.horde.org/ingo-3.1.4
upgrade ok: channel://pear.horde.org/kronolith-4.1.5
upgrade ok: channel://pear.horde.org/turba-4.1.4
upgrade ok: channel://pear.horde.org/gollem-3.0.2
upgrade ok: channel://pear.horde.org/mnemo-4.1.3
upgrade ok: channel://pear.horde.org/webmail-5.1.4

Soon after upgrading I got the error message
"Could not instantiate PDO with DSN  
"mysql:protocol=unix;dbname=horde". PDOException: SQLSTATE[HY000]  
[1040] Too many connections"
After restarting Apache it worked, but after some minutes the error  
reappeared.
So I had a look at the MySQL processes, there were many "Sleep"  
processes originating from horde, just like this:

| 165103 | horde     | localhost       | horde       | Sleep   |  256  
|       | NULL                  |

I had a look into the ActiveSync configuration and set  
"$conf[activesync][ping][heartbeatmax]" to 120 (default was 2700),  
after that the sleeping connections were terminated after 120 seconds  
and the "too many connections" error disappeared. After resetting it  
to 2700 the problem reappears.

I'm not sure if it is a problem with ActiveSync, maybe the updated  
Horde_Db package is responsible?
Is it a problem to set the heartbeatmax value to 120 seconds? What  
could be the cause of the connection problem?

Thanks a lot in advance,
Christian Hailer