[horde] duplicate key value violates unique constraint "horde_activesync_state_pkey"

[Michael J Rubinsky]

Quoting Sebastian Arcus <s.arcus at open-t.co.uk>:

> I'm on Horde 5.2.17 with Lighttpd 1.4.49, PHP 5.6.35 and Postgresql 9.2.24
>
> I get lots of the above errors in the logs and most of the 8 iPhones  
> can't sync or download emails for several hours at a time, then they  
> work again, they they stop again - and so on. The full error message  
> is:
>
> 2018-05-14T09:11:11+01:00 ERR: HORDE SQL QUERY FAILED:  
> SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value  
> violates unique constraint "horde_activesync_state_pkey"
> DETAIL:  Key (sync_key)=({5acb7873-baa4-4ea3-8f69-3d9bc0a83c02}1527)  
> already exists.
> 	INSERT INTO "horde_activesync_state" ("sync_key", "sync_data",
> 	  "sync_devid", "sync_mod", "sync_folderid", "sync_user",
> 	  "sync_pending", "sync_timestamp") VALUES (?, :binary0, ?, ?, ?, ?, ?,
> 	  ?) [pid 11736 on line 282 of "/usr/lib/php/Horde/Db/Adapter/Pdo/Base.php"]
>
> I would really appreciate some guidance on this please - as the mail  
> downloading on the iPhones is really erratic and it drives users  
> bonkers - and in turn they are driving me up the wall :)

The unique violation is explained in the sync log, it happens when the  
client either does not receive or does not understand the response it  
was sent, so it issues the same sync request again. This can happen  
from time to time under normal circumstances, but should not happen as  
often as you state or prevent sync for hours at a time unless there is  
something else going on.

I would need to see the sync log for a device that is experiencing  
this behavior to help you debug the issue further.


> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
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: not available
Type: application/pgp-keys
Size: 9272 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/horde/attachments/20180514/743018e7/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 821 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/horde/attachments/20180514/743018e7/attachment-0001.bin>