[horde] ActiveSync stops syncing mail with SQL error

[Michael J Rubinsky]

Quoting Michael J Rubinsky <mrubinsk at horde.org>:

> Quoting Michael Polenske <michael at polenske.net>:
>
>> On 02/19/2015 04:49 PM, Michael J Rubinsky wrote:
>>>
>>> Quoting Michael Polenske <m.polenske at web.de>:
>>>
>>>> On 19.02.2015 15:02, Michael J Rubinsky wrote:
>>>>>
>>>>> Quoting Michael Polenske <m.polenske at web.de>:
>>>>>
>>>>>> On 19.02.2015 12:31, Jan Schneider wrote:
>>>>>>>
>>>>>>> Zitat von Michael Polenske <m.polenske at web.de>:
>>>>>>>
>>>>>>>> Good morning,
>>>>>>>> since a few days I cannot see new mails on my mobile device  
>>>>>>>> (iphone). When I go to webinterface or use Outlook 2013  
>>>>>>>> everything seems to be fine. I activated logging für  
>>>>>>>> ActiveSync and can see a SQL error if I start to sync with my  
>>>>>>>> mobile device:
>>>>>>>> 2015-02-19T10:22:52+01:00 ERR: HORDE SQL QUERY FAILED:  
>>>>>>>> SQLSTATE[23000]: Integrity constraint violation: 1062  
>>>>>>>> Duplicate entry '{54e5ab5b-f94c-4ffb-911b-2d8ec0a82a03}3' for  
>>>>>>>> key 'PRIMARY'
>>>>>>>>     INSERT INTO horde_activesync_state (sync_key, sync_data,  
>>>>>>>> sync_devid,
>>>>>>>> [.....]
>>>>>>>>   }}', 1424337772) [pid 11662 on line 204 of  
>>>>>>>> "/usr/share/php5/PEAR/Horde/Db/Adapter/Pdo/Base.php"]
>>>>>>>> Calendar, Addressbook and also Mail-Subfolders are synced  
>>>>>>>> correctly, only the Main-Inbox-Folder stops syncronising.  
>>>>>>>> Horde was updated with "pear upgrade -a -B -c horde" to  
>>>>>>>> latest version.
>>>>>>>>
>>>>>>>> Any hint/advise ?
>>>>>>>
>>>>>>> See the ActiveSync FAQ
>>>>>>>
>>>>>>
>>>>>> Hi Jan,
>>>>>>
>>>>>> thanks for the hint, oversaw in first step the "KnownIssues"  
>>>>>> part at the end ;-) Good, the SQL-Error seems to be normal. But  
>>>>>> I'm stillö not able to sync newer mails on my mobile device.  
>>>>>> Since it works on Outlook2013 and in Webinterface, I assume  
>>>>>> that ActiveSync may not be the problem. Any other idea what can  
>>>>>> be the "showstopper" ? Which part of which log do you need to  
>>>>>> give me a hint where to find the problem ?
>>>>>
>>>>> Try recreating the activesync account on the client. If it still  
>>>>> persists, since I have no idea where your issue is, I would need  
>>>>> the entire sync log from the start of the new account creation,  
>>>>> up until the email stops syncing.
>>>>>
>>>>
>>>> Hi Michael,
>>>>
>>>> I deleted my account on the mobile and created a new one. Just  
>>>> enabled mail sync for last 3 days. In mobile I cannot see any  
>>>> mail in main inbox-folder. Created a clean logfile - shall I post  
>>>> it here or send you directly ?
>>>
>>> You can send it to me directly if you like.
>>>
>>>
>>>
>>
>> Hi Michael,
>> logfile attached.
>>
>> Many thanks - Michael
>>
>> -- 
>> ### gesendet mit meinem AtariXL ###
>
> What client is this? It looks *badly* broken.
>
> It is requesting to PING the sent mail collection before it  
> initializes it with the initial SYNC request. There appears to be  
> some other issue with the DEVICEINFORMATION request that I need to  
> look into, but I don't think that it's related.

This also looks like broken client behavior. It is sending a  
"DEVICEINFORMATION" node in the SETTINGS request but is using EAS  
version 14.1 - which requires the DEVICEINFORMATION to be sent only in  
PROVISION requests. Though, we don't currently block this data from  
being received in this case so there may be something wrong with the  
structure it is sending. I would need a wiretrace of the conversation  
to see what is being sent.


-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20150219/fc5fdcf2/attachment.bin>