[Tickets #12640] violates unique constraint "horde_active sync_state_pkey"

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/12640
------------------------------------------------------------------------------
  Ticket             | 12640
  Created By         | michael at bigmichi1.de
  Summary            | violates unique constraint "horde_active
                     | sync_state_pkey"
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


michael at bigmichi1.de (2013-08-29 09:23) wrote:

i added today some new devices to use active sync and now my log is  
flooded by such messages:

SQL QUERY FAILED: SQLSTATE[23505]: Unique violation: 7 ERROR:   
duplicate key value violates unique constraint "horde_active
sync_state_pkey"
DETAIL:  Key (sync_key)=({521f109b-2678-4563-a524-1914bc286502}2)  
already exists.
         INSERT INTO horde_activesync_state (sync_key, sync_data, sync_devid,
           sync_mod, sync_folderid, sync_user, sync_pending, sync_timestamp)
           VALUES ('{521f109b-2678-4563-a524-1914bc286502}2',
...


i tried to clear all active_sync tables and when all devices trie to  
refresh the messages appear again