[Tickets #13043] Timeouts during as_state_map cleanup

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/13043
------------------------------------------------------------------------------
  Ticket             | 13043
  Created By         | hannes.brunssen at ewetel.de
  Summary            | Timeouts during as_state_map cleanup
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


hannes.brunssen at ewetel.de (2014-03-12 16:38) wrote:

We just found an ActiveSync-state with over 120k entries in the table  
horde_activesync_map. These entries could not be removed, because the  
garbage collector function tries to build a huge query which searches  
120k times for the same sync_key. The webserver processes were running  
at 100% for several minutes and finished with segfaults.

The attached patch fixes this problem by using DISTINCT in the query.



hannes.brunssen at ewetel.de (2014-03-12 16:38) uploaded: as_map_distinct.patch

http://bugs.horde.org/h/services/download/?app=whups&actionID=download_file&file=as_map_distinct.patch&ticket=13043&fn=%2Fas_map_distinct.patch