A NOTE has been added to this issue. ====================================================================== 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: 19-Jan-07 16:44 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. ====================================================================== ---------------------------------------------------------------------- aaron - 19-Jan-07 02:50 ---------------------------------------------------------------------- Dump out a couple of messages and their respective messageblks and attach them to the bug. The first easiest thing will be to re-insert your messageblks into another database and see if they still act up. Also, what version of GMime are you using? ---------------------------------------------------------------------- Anne - 19-Jan-07 16:44 ---------------------------------------------------------------------- I have the same problem. My errors also include the dbmail_subjectfield table. I get these errors sometimes when doing a daily dbmail-util -by Ok. Found [2] un-cached physmessages. Error [Duplicate entry '8127044-2007-01-16 09:13:32' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (8127044,'2007-01-16 09:13:32')] Error insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (8127044,'2007-01-16 09:13:32')] Error [Duplicate entry '8127044-Lang zullen ze lezen!' for key 2] [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (8127044,'Lang zullen ze lezen!')] Error insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (8127044,'Lang zullen ze lezen!')] .Error [Duplicate entry '8127043-2007-01-16 09:13:32' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (8127043,'2007-01-16 09:13:32')] Error insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (8127043,'2007-01-16 09:13:32')] Error [Duplicate entry '8127043-Lang zullen ze lezen!' for key 2] [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (8127043,'Lang zullen ze lezen!')] Error insert subjectfield failed [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (8127043,'Lang zullen ze lezen!')] . Issue History Date Modified Username Field Change ====================================================================== 07-Jan-07 21:07 zak New Issue 19-Jan-07 02:50 aaron Note Added: 0001735 19-Jan-07 16:44 Anne Note Added: 0001736 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
