[Tickets #13022] Exceptions to events break ActiveSync synchronization

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/13022
------------------------------------------------------------------------------
  Ticket             | 13022
  Created By         | arjen+horde at de-korte.org
  Summary            | Exceptions to events break ActiveSync synchronization
  Queue              | Kronolith
  Version            | 4.1.4
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


arjen+horde at de-korte.org (2014-03-07 15:52) wrote:

I have several Android devices where the Calendar stopped  
synchronizing after a while (e-mail and tasks are still synchronized).  
It turns out this probably has something to do with exceptions to  
recurring events. After a recurring event is created and an exception  
is created (by removing one of the recurrences), the calendar on the  
device will no longer be synchronized. In the horde.log, a message as  
follows is logged:

2014-03-07T16:03:58+01:00 ERR: horde [horde] SQL QUERY FAILED:  
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry  
'{5319cacf-9574-43ab-9b49-57e2c0a8010a}129' for
         INSERT INTO horde_activesync_state (sync_key, sync_data, sync_devid,
           sync_mod, sync_folderid, sync_user, sync_pending, sync_timestamp)
           VALUES ('{5319cacf-9574-43ab-9b49-57e2c0a8010a}129',
            
'C:34:"Horde_ActiveSync_Folder_Collection":88:{{"s":[],"f":"@Calendar@
           ","c":"Calendar","lsd":1392989648,"sd":1394199248,"i":true,"v":1}}',
           'ANDROID1325376003337', 8864, '@Calendar@', 'test', 'a:0:{}',
           1394204638) [pid 25266 on line 200 of  
"/usr/share/php5/PEAR/Horde/Db/Adapter/Pdo/Base.php"]

Importing the attached .ics file into an empty calendar results in  
similar behavior (the calendar is no longer synchronized and a message  
about the duplicate entry is logged). After removing the lines  
starting with 'EXDATE' from the .ics file and importing it will  
successfully synchronize to the device however, so it looks like the  
device doesn't like the exceptions. Strangely enough, if the exception  
is created on the device, the change is propagated to Horde without  
problems and the calendar on the device remains synchronized.

The device I tested this with is running Android 4.2.2 with Google  
Agenda (version 201308023).



arjen+horde at de-korte.org (2014-03-07 15:52) uploaded: Event-breaks-sync.ics

http://bugs.horde.org/h/services/download/?app=whups&actionID=download_file&file=Event-breaks-sync.ics&ticket=13022&fn=%2FEvent-breaks-sync.ics