[horde] ActiveSync stops syncing mail with SQL error

[Michael Polenske]

On 02/19/2015 07:36 PM, Michael J Rubinsky wrote:
>
> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>> 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.
>
> Nevermind. I see that it's an iPhone. Must be one of the new 
> generations, as the device id format has changed. I can test more 
> later, when I have access to an iPhone 6.
>
>
>
>
>

Hi Michael,

sorry, it's an older Iphone 5 (non-S), latest IOS (8.1.3 I guess), and 
since last Saturday it worked without any problems.

Funny thing is that subfolders are syncronized correctly, also Calendar, 
Adressbook etc.

Hmmm, strange.

Cheers - Michael