A NOTE has been added to this issue. ====================================================================== 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: 12-Mar-08 22:32 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) ====================================================================== ---------------------------------------------------------------------- paul - 12-Mar-08 22:32 ---------------------------------------------------------------------- Is this problem persistent? If so, try clearing out all cache tables for the physmessages involved in the duplicate key errors. If a physmessage doesn't have any entries in the headervalue table it is assumed not to have been cached at all. If a physmessage is missing from the headervalue table, but _does_ have entries in one of the other tables, such duplicate key collisions are to be expected. Regarding the problem with your replication: what do you mean by never seeing the messae on the US side? Are you looking in the tables, or looking from IMAP? Anyway it's unrelated. Issue History Date Modified Username Field Change ====================================================================== 10-Mar-08 19:55 m2000 New Issue 12-Mar-08 22:32 paul Note Added: 0002510 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
