[horde] constraint violation errors

[Chuck Hagenbuch]

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  
>"/...../ssl-htdocs/horde-webmail-1.2.5/imp/lib/Sentmail/sql.php"]
>
>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?
>
>Thanks
>
>Steve Devine
>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