[horde] ActiveSync SQL errors
Nels Lindquist
nlindq at maei.ca
Thu Jan 4 21:42:27 UTC 2018
-----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-----
More information about the horde
mailing list