[horde] ActiveSync stops syncing mail with SQL error

[Michael J Rubinsky]

Quoting Michael Polenske <m.polenske at web.de>:

> On 02/19/2015 07:32 PM, Michael J Rubinsky wrote:
>>
>> 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.
>>
>>
>>
>>
>
> Hmm, if it helps I can setup an seperate WLAN-AP and do a  
> wireshark-trace ?!?!

It might help.

I have access to several devices running iOS 8.1.x, including a 5  
(though it's a newer S) and can't reproduce. The device id is also  
very strange for an older iPhone. ALL of the iPhone logs I have seen  
have something similar to APPLxxxxx as the id. The only other iPhone I  
saw with that kind of device id was a 6 Plus.

-- 
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/22537a0d/attachment.bin>