Josh, Please send a schema dump (mysqldump -d dbmail)
Sounds like your foreign key constraints aren't in place. Josh Marshall wrote: > Hi all, > > When running > > /usr/sbin/dbmail-util -ay > > each night, I get a lot of messages deleted: > > Deleting messages with DELETE status... > Ok. [18657] messages deleted. > > > It has some problems with repairing cached header values: > > Repairing DBMAIL for cached header values... > Ok. Found [20] un-cached physmessages. > May 08 01:54:50 mail1 dbmail-util[5754]: Error:[sql] > dbmysql.c,db_query(+290): [Duplicate entry '2894446-1970-01-01 00:00:00' > for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield) > VALUES (2894446,'1970-01-01 00:00:00')] > May 08 01:54:50 mail1 dbmail-util[5754]: Error:[message] > dbmail-message.c,insert_field_cache(+1105): insert datefield failed > [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES > (2894446,'1970-01-01 00:00:00')] > .... > > And has a lot of messages set each night for deletion: > > Setting DELETE status for deleted messages... > Ok. [164698] messages set for deletion. > > I'm using the Debian packages by Paul Stevens on Debian Etch, Version: > 2.2.10-1 > > > Is there something I've got wrong in my settings? It'd be nice if I > could actually get rid of those deleted emails, my database is getting > big (43Gb compressed mysql-dump) > > Thanks, > Josh. > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
