paul at nfg
May 8, 2008, 12:18 AM
Post #2 of 5
(217 views)
Permalink
|
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
> DBmail[at]dbmail.org
> 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
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
dbmailschema.sql
