[horde] constraint violation errors
chuck at horde.org
Sat Mar 20 22:58:41 UTC 2010
Seems like the right solution to me.
Steve Devine <sd at msu.edu> wrote:
>We recently had a database hiccup and as a result had to switch over
>to our backup db - this db was supposedly in sync with the master and
>for the most part is was, however we are getting lots of errors in our
>horde logs like this:
>DB Error: constraint violation: INSERT INTO imp_sentmail (sentmail_id,
>sentmail_who, sentmail_ts, sentmail_messageid, sentmail_action,
>sentmail_recipient, sentmail_success) VALUES (30932373, 'xxx',
>1269058002, '<20100320000642.11831989pjmi5fwy at mail.msu.edu>', 'reply',
>'xxxx at yahoo.com', 1) [nativecode=1062 ** Duplicate entry '30932373'
>for key 1] [pid 29912 on line 85 of
>I also see similar errors for the table horde_histories. Investigation
>reveals that the number in imp_sentmail_seq is about 3k less than the
>highest number for imp_sentmail.sentmail_id. The same disparity exists
>in the relationship between horde_histories_seq and horde_histories.
>So my inclination is to reset the number in imp_sentmail_seq
>to a value slightly higher than the highest current value of
>sentmail_id ... does this seem like a reasonable solution? Has anyone
>else seen this?
>Email & Storage
>Academic Technology Services
>Michigan State University
>Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: horde-unsubscribe at lists.horde.org
More information about the horde