[horde] ActiveSync stops syncing mail with SQL error

Sun Feb 22 07:32:06 UTC 2015

On 02/19/2015 10:08 PM, Michael J Rubinsky wrote:
>
> 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.
>
>
>
Good morning,

Yesterday I played around a lot with the system - strange results ...

- made a factory reset to Iphone5, start to connect to webmail with a 
clean phone - no emails in rootfolder, subfolders are okay. Set 
sync-time from one week (default) to one month - okay, see mails in root 
folder until February 9th.
- Grabbed my old Iphone3S (IOS 6), factory reset, same result above.
- Setup VirtualPC with Windows7 and Outlook2013 - everything is fine, 
see all mails, no problems.
- Factory reset of an old HTC Y300, install a custom rom on this (CM 11) 
- also this device is able to sync everything without problems.

Very strange.

- Okay, grab Iphone 4 (also 8.1.3) of my wife (she is still able to 
sync) - setup my account on her phone - none of my Mails since February 
9th on this phone...
- create an account for my wife on Iphone 3 and 5 ... everything okay, 
with her account I can sync anything, only MY account will not sync on 
all Apple-Phone.

Try to move / delete one of the last mails in my folder on the iphone 
(just to be sure if maybe one of the mails are broken) - cannot move, 
get strange errors (sorry, forgot to make screenshots). With webmail abd 
Outlook I was able to move the last 20 emails to a subfolder - but on 
Iphone I still see the last mails.

So, for the moment I assume that not the phone is the problem, there 
must be something in database that blocks all of the Apple Devices for 
this one account. I cannot be a general problem, otherwise my wifes 
account cannot work. Because I have no deeper knowledge of the 
ActiveSync mechanism I have really NO idea what the exact problem could 
be ...

I created logs for all of the devices - is it okay if I send this to 
you, Michael ?

Have a nice Sunday - Michael