[Tickets #13032] Re: 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
  Updated By         | chrissi at amusing.de
  Summary            | ActiveSync: Too many connections due to MySQL sleep
                     | processes
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


chrissi at amusing.de (2014-03-12 09:30) wrote:

Hello Michael,

I did a litte debugging by myself and stumbled across a diff in the  
Horde/ActiveSync/SyncCache.php file:

165c165
<             ($cache['lasthbsyncstarted'] >  
$this->_data['lasthbsyncstarted'])) {
---
>             (!empty($cache['lastsyncstarted']) &&  
> $cache['lasthbsyncstarted'] > $this->_data['lasthbsyncstarted'])) {

When I use the line form the previous version

($cache['lasthbsyncstarted'] > $this->_data['lasthbsyncstarted'])) {

everything works like a charm, I tested it for 3 hours. As soon as I  
use the line from the latest version

(!empty($cache['lastsyncstarted']) && $cache['lasthbsyncstarted'] >  
$this->_data['lasthbsyncstarted'])) {

5 minutes after restarting the webserver the connection pool hits the  
150 connections limit again.

I hope this information is useful to you!

Regards, Christian