[horde] Integrity constraint

Simon Wilson simon at simonandkate.net
Wed Jun 12 11:06:44 UTC 2013


Can anyone assist with why am I getting these occasionally:

2013-06-12T18:08:23+10:00 ERR: HORDE [horde] SQL QUERY FAILED:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'{51b6a6d1-d398-49a4-a337-28ebc0a801e6}84' for key 'PRIMARY' INSERT INTO
horde_activesync_state (sync_key, sync_data, sync_devid, sync_time,
sync_folderid, sync_user, sync_pending) VALUES
('{51b6a6d1-d398-49a4-a337-28ebc0a801e6}84',
'C:28:"Horde_ActiveSync_Folder_Imap":1444:{a:5:{s:1:"s";a:3:{s:13:"hig
hestmodseq";i:0;s:7:"uidnext";s:5:"49894";s:11:"uidvalidity";s:10:"123
8677126";}s:1:"m";a:27:{i:48791;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;
}i:48843;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:48902;a:2:{s:4:"read
";i:1;s:7:"flagged";i:0;}i:48980;a:2:{s:4:"read";i:1;s:7:"flagged";i:0
;}i:48981;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:48982;a:2:{s:4:"rea
d";i:1;s:7:"flagged";i:0;}i:48993;a:2:{s:4:"read";i:1;s:7:"flagged";i:
0;}i:49004;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:49032;a:2:{s:4:"re
ad";i:1;s:7:"flagged";i:0;}i:49046;a:2:{s:4:"read";i:1;s:7:"flagged";i
:0;}i:49106;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:49107;a:2:{s:4:"r
ead";i:1;s:7:"flagged";i:0;}i:49155;a:2:{s:4:"read";i:1;s:7:"flagged";
i:0;}i:49216;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:49260;a:2:{s:4:"
read";i:1;s:7:"flagged";i:0;}i:49447;a:2:{s:4:"read";i:1;s:7:"flagged"
;i:0;}i:49590;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:49758;a:2:{s:4:
"read";i:1;s:7:"flagged";i:0;}i:49789;a:2:{s:4:"read";i:1;s:7:"flagged
";i:0;}i:49812;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:49814;a:2:{s:4
:"read";i:1;s:7:"flagged";i:0;}i:49843;a:2:{s:4:"read";i:1;s:7:"flagge
d";i:0;}i:49847;a:2:{s:4:"read";i:1;s:7:"flagged";i:0;}i:49862;a:2:{s:
4:"read";i:1;s:7:"flagged";i:0;}i:49871;a:2:{s:4:"read";i:1;s:7:"flagg
ed";i:0;}i:49892;a:2:{s:4:"read";i:0;s:7:"flagged";i:0;}i:49893;a:2:{s
:4:"read";i:0;s:7:"flagged";i:0;}}s:1:"f";s:5:"INBOX";s:1:"c";s:5:"Ema
il";s:1:"v";i:1;}}', 'SEC10D1C297BE813', 1371024503, 'd2a04fc5', 'simon',
'a:0:{}') [pid 12778 on line 553 of
"/usr/share/pear/Horde/Db/Adapter/Base.php"]

And how can I fix them?

Doesn't appear to be breaking anything, I just get the occasional  
errors, about 5 to 10 a day.


Simon.

--
Simon Wilson
M: 0400 12 11 16
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 1339 bytes
Desc: PGP Public Key
URL: <http://lists.horde.org/archives/horde/attachments/20130612/6e2a9d65/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: PGP Digital Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130612/6e2a9d65/attachment-0001.bin>


More information about the horde mailing list