[horde] duplicate key value violates unique constraint "horde_activesync_state_pkey"
Sebastian Arcus
s.arcus at open-t.co.uk
Mon May 14 08:23:09 UTC 2018
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 :)
More information about the horde
mailing list