[horde] Integrity constraint

[Michael J Rubinsky]

Quoting Simon Wilson <simon at simonandkate.net>:

> 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.

Getting these occasionally is normal. It happens when, for whatever  
reason, the device did not accept the last sent set of changes along  
with the new synckey. The next request will then contain the same  
synckey as the previous reqeuest so when the "new" sync key is  
generated and saved it already exists in the state table. You will see  
this in the sync log with a notice that it is removing the previous  
state and trying again.

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2200 bytes
Desc: PGP Public Key
URL: <http://lists.horde.org/archives/horde/attachments/20130612/ccfe32f6/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6062 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130612/ccfe32f6/attachment-0003.bin>