The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=688 ====================================================================== Reported By: m2000 Assigned To: ====================================================================== Project: DBMail Issue ID: 688 Category: Database layer Reproducibility: sometimes Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 10-Mar-08 19:55 CET Last Modified: 10-Mar-08 19:55 CET ====================================================================== Summary: re 0000486: duplicate key errors in dbmail_datefield Description: Repairing DBMAIL for cached header values... Ok. Found [1] un-cached physmessages. Mar 10 19:38:21 pigeon dbmail-util[22372]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate entry '728249-1970-01-01 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (728249,'1970-01-01 00:00:00')] Mar 10 19:38:21 pigeon dbmail-util[22372]: Error:[message] dbmail-message.c,insert_field_cache(+1100): insert datefield failed [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (728249,'1970-01-01 00:00:00')]
mysql> SELECT * FROM dbmail_datefield WHERE physmessage_id=728249; +----------------+--------+---------------------+ | physmessage_id | id | datefield | +----------------+--------+---------------------+ | 728249 | 728221 | 1970-01-01 00:00:00 | +----------------+--------+---------------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM dbmail_physmessage WHERE id=728249; +--------+-------------+---------+---------------------+ | id | messagesize | rfcsize | internal_date | +--------+-------------+---------+---------------------+ | 728249 | 410805 | 416350 | 2004-11-22 02:10:24 | +--------+-------------+---------+---------------------+ 1 row in set (0.00 sec) ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 10-Mar-08 19:55 m2000 New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
