[Tickets #10644] Activesync fails to sync events created while offline

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10644
------------------------------------------------------------------------------
  Ticket             | 10644
  Created By         | lp.allard.1 at gmail.com
  Summary            | Activesync fails to sync events created while offline
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


lp.allard.1 at gmail.com (2011-10-13 00:33) wrote:

I am again experiencing problems with AS but this time I know whats  
going on better.  Again, some events are not properly sync'ed and are  
duplicated.

I discovered the following facts:

-Events that were already in kronolith are kept OK.  No problem with them.
-Events that I CREATED on the mobile device while I was NOT online  
with my horde installation (out of range from my wifi LAN) are not  
properly sync'ed.  They are sync at the right moment (day, time) but  
duplicated.
-I am not sure about events that were modified on the mobile device  
and later sync'ed as I did not had a chance to try yet.
-Events that created/modified on the mobile device WHILE connected to  
the local network are sync'ed properly.

In other words, only  (SO FAR) events that are created from scratch  
offline are not properly sync'ed.

Attached is the AS log for today.  I deleted the entries that were  
dated prior to today, because the log was well over 5MB.

While removing my private data from the log, I've noticed 3 strange things:

1-The events that were duplicated by AS were in the log twice.  I  
marked them as:  !!!Faulty Event!!!
2-I did NOT change anything with my contacts since original sync (when  
I created the exchange account on the mobile dev) yet there is  
references to contact changes in the AS log.
3-One line caught my attention .  Not sure if it has anything to do  
with my problem:

2011-10-12T18:01:45-04:00 NOTICE: [Appl6Q109352A4S] Error saving state  
for synckey {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}11: SQLSTATE[23000]:  
Integrity constraint violation: 1062 Duplicate entry  
'{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}11' for key 'PRIMARY' -  
removing previous sync state and trying again.

Also if important to mention: I did not remove or delete anything  
dated 2011-10-12.
Help is appreciated.
Thanks to the staff!



lp.allard.1 at gmail.com (2011-10-13 00:33) uploaded: horde_activesync.log

http://bugs.horde.org/h/services/download/?module=whups&actionID=download_file&file=horde_activesync.log&ticket=10644&fn=%2Fhorde_activesync.log