[horde] ActiveSync stops syncing mail with SQL error

[Michael Polenske]

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 ?!?!

Cheers - Michael