The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=486 ====================================================================== Reported By: zak Assigned To: ====================================================================== Project: DBMail Issue ID: 486 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 07-Jan-07 21:07 CET Last Modified: 07-Jan-07 21:07 CET ====================================================================== Summary: Many duplicate key errors from MySQL running "dbmail-util -by" Description: I have just attempted an upgrade from dbmail 2.0.11 to 2.2.1 on a fairly low-volume system, and (after running the migrate_from_2.0_to_2.2.mysql.gz script) I now get the lots of the following errors every time I run "dbmail-util -by":
... Error insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1976,'1970-01-01 00:00:00')] .Error [Duplicate entry '1975-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1975,'1970-01-01 00:00:00')] Error insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1975,'1970-01-01 00:00:00')] .Error [Duplicate entry '1974-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1974,'1970-01-01 00:00:00')] Error insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1974,'1970-01-01 00:00:00')] .Error [Duplicate entry '1973-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (1973,'1970-01-01 00:00:00')] ... All the dates are '1970-01-01 00:00:00'. However, the IMAP daemon has started and appears to be functioning fine. I'm using MySQL 4.1.21. I'm not sure what additional information might be useful in tracking this down, but I'm happy to provide any that is likely to help. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 07-Jan-07 21:07 zak New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
