[horde] ActiveSync SQL errors

[Nels Lindquist]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 2018/01/03 8:33 PM, Michael J Rubinsky wrote:
> From: Nels Lindquist <nlindq at maei.ca>
>> 
>> I'm seeing intermittent errors like this for a user whose Outlook
>> EAS profile has reset and re-downloaded all mail a couple of
>> times.  Any suggestions?
>> 
>> Jan  3 11:28:29 mail3 HORDE: SQL QUERY FAILED: SQLSTATE[23505]:
>> Unique violation: 7 ERROR:  duplicate key value violates unique
>> constraint "horde_activesync_state_pkey"#012DETAIL:  Key 
>> (sync_key)=({5a4ceddc-5cac-4989-afb5-66b6423361e2}51) already
>> exists. #012#011INSERT INTO "horde_activesync_state"
>> ("sync_key", "sync_data",#012#011  "sync_devid", "sync_mod",
>> "sync_folderid", "sync_user",#012#011 "sync_pending",
>> "sync_timestamp") VALUES (?, :binary0, ?, ?, ?, ?, ?,#012#011  ?)
>> [pid 12915 on line 282 of 
>> "/usr/share/pear/Horde/Db/Adapter/Pdo/Base.php"]
> 
> Check the activesync log output for that device.

I've enabled per-device logging for that domain and verified that
device logs are being generated.  I'm not seeing any obvious errors
showing up for the affected device; anything in particular I should be
looking for?

- ----
Nels Lindquist
<nlindq at maei.ca>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlpOn8MACgkQh6z5POoOLgRNOwCfZtCu4CT5H8s4GtsapY1x/0ua
KOkAnR4+W0x1MOUIUYvRpJ2T2V5jJZON
=2JxC
-----END PGP SIGNATURE-----