A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=831 ====================================================================== Reported By: utada Assigned To: paul ====================================================================== Project: DBMail Issue ID: 831 Category: LMTP daemon Reproducibility: always Severity: major Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 21-Jan-10 11:24 CET Last Modified: 16-Jul-10 14:41 CEST ====================================================================== Summary: ERROR: duplicate key violates unique constraint "dbmail_headername_1" Description: MTA: Postfix 2.3.3 DataBase: PostgreSQL 8.1.11
When mail was sent, the header name is inserted to dbmail_headername table. But,If some addresses exist, the error occurs because same header name is doubly registered. The error doesn't occur if dbmail_headername table has already same headername. ====================================================================== ---------------------------------------------------------------------- (0002986) paul (administrator) - 21-Jan-10 11:45 http://www.dbmail.org/mantis/view.php?id=831#c2986 ---------------------------------------------------------------------- Please don't file bugs against old releases. This is a duplicate of bug http://www.dbmail.org/mantis/view.php?id=685 afaict which was fixed in 2.2.10. Feel free to re-open this bug if it still exists in the latest 2.2 release. ---------------------------------------------------------------------- (0002988) utada (reporter) - 22-Jan-10 09:56 http://www.dbmail.org/mantis/view.php?id=831#c2988 ---------------------------------------------------------------------- Thanks replay I tried the installation of dbmail-2.2.10. http://www.dbmail.org/download/2.2/dbmail-2.2.10.tar.gz But, the same problem occurs still. Do I have mistake? ---------------------------------------------------------------------- (0002989) paul (administrator) - 22-Jan-10 10:13 http://www.dbmail.org/mantis/view.php?id=831#c2989 ---------------------------------------------------------------------- I'm unable to reproduce this problem. Please file level5 logs and a message that will trigger this bug. Btw, why do you insist on using old versions? Please test 2.2.13 or use one of the downloads at: http://git.dbmail.eu/cgit/cgit.cgi/paul/dbmail/commit/?id=e00fbe2296f6969145aaf143f1e1412554f8fa7c so you can help test 2.2.14 ---------------------------------------------------------------------- (0002991) utada (reporter) - 22-Jan-10 14:32 http://www.dbmail.org/mantis/view.php?id=831#c2991 ---------------------------------------------------------------------- I tried the installation of dbmail-2.2.13 But, the same problem occurs still. I attached error log please check it and advice to me. ---------------------------------------------------------------------- (0003000) paul (administrator) - 27-Jan-10 21:12 http://www.dbmail.org/mantis/view.php?id=831#c3000 ---------------------------------------------------------------------- You should be able work around this problem by narrowing the lmtp pipeline from your MTA to dbmail-lmtpd. For postfix this would mean setting the maxproc value to 1 for lmtp: in master.cf change: lmtp unix - - - - - lmtp to: lmtp unix - - - - 1 lmtp so postfix won't try to deliver the same message concurrently for multiple local users. ---------------------------------------------------------------------- (0003007) utada (reporter) - 28-Jan-10 02:27 http://www.dbmail.org/mantis/view.php?id=831#c3007 ---------------------------------------------------------------------- Thanks paul I will try change to master.cf. I have doubt because it is not in README.postfix why should I change this parameter? Is it a problem of usually happening? ---------------------------------------------------------------------- (0003017) utada (reporter) - 01-Feb-10 01:24 http://www.dbmail.org/mantis/view.php?id=831#c3017 ---------------------------------------------------------------------- I changed lmtp in maser.cf But,the error occur. The error doesn't occur when I changed dbmail-lmtp unix - - - - - lmtp to dbmail-lmtp unix - - - - 1 lmtp The problem seems to solved. But,I don't understand why error occur in only my environment. ---------------------------------------------------------------------- (0003020) paul (administrator) - 02-Feb-10 09:40 http://www.dbmail.org/mantis/view.php?id=831#c3020 ---------------------------------------------------------------------- There must be something funny in your MTA setup. Normally, local users are resolved by DBMail. But in your case the exact same messages is being inserted twice concurrently by postfix. I'm guessing you have some kind of mysql alias_maps causing you grief. ---------------------------------------------------------------------- (0003023) tabrisnet (reporter) - 04-Feb-10 20:37 http://www.dbmail.org/mantis/view.php?id=831#c3023 ---------------------------------------------------------------------- I can confirm this occurring on another system, and no 'mysql alias maps' that I'm aware of being configured. We're just using LDAP for user resolution. ---------------------------------------------------------------------- (0003024) tabrisnet (reporter) - 04-Feb-10 20:54 http://www.dbmail.org/mantis/view.php?id=831#c3024 ---------------------------------------------------------------------- Oh, and for additional information, the message that was being delivered was going to at least a dozen people. ---------------------------------------------------------------------- (0003080) Steven Flintham (reporter) - 16-Jul-10 14:31 http://www.dbmail.org/mantis/view.php?id=831#c3080 ---------------------------------------------------------------------- I just saw what looks very much like this bug with dbmail 2.2.16 on *receiving* mail. I believe what happened is that two messages arrived simultaneously from a mailing list I had just subscribed to. It uses an "unusual" header which had probably not been seen before. One of the messages processed correctly, the other was bounced. I will attach a copy of the relevant part of syslog. If you need any more information please let me know. Thanks. Steve ---------------------------------------------------------------------- (0003081) Steven Flintham (reporter) - 16-Jul-10 14:41 http://www.dbmail.org/mantis/view.php?id=831#c3081 ---------------------------------------------------------------------- Sorry, just a thought - I guess one fix for this would be to make dbmail retry the failed insert in this case after a delay. Alternatively/as well, would it be possible to make dbmail indicate a temporary failure to postfix, causing it to queue the mail locally instead of rejecting it? Apologies if this is stupid, I just thought I'd mention it as a possibly easy fix. Issue History Date Modified Username Field Change ====================================================================== 21-Jan-10 11:24 utada New Issue 21-Jan-10 11:45 paul Note Added: 0002986 21-Jan-10 11:45 paul Status new => resolved 21-Jan-10 11:45 paul Resolution open => no change required 22-Jan-10 09:31 utada Issue Monitored: utada 22-Jan-10 09:37 utada Note Added: 0002988 22-Jan-10 09:37 utada Status resolved => feedback 22-Jan-10 09:37 utada Resolution no change required => reopened 22-Jan-10 09:56 utada Note Edited: 0002988 22-Jan-10 10:13 paul Note Added: 0002989 22-Jan-10 14:30 utada File Added: error_maillog.txt 22-Jan-10 14:32 utada Note Added: 0002991 22-Jan-10 15:06 paul Assigned To => paul 22-Jan-10 15:06 paul Status feedback => acknowledged 22-Jan-10 15:06 paul Resolution reopened => open 22-Jan-10 15:06 paul version 2.2.9 => 2.2.13 27-Jan-10 21:12 paul Note Added: 0003000 28-Jan-10 02:27 utada Note Added: 0003007 01-Feb-10 01:23 utada Note Added: 0003017 01-Feb-10 01:24 utada Note Edited: 0003017 02-Feb-10 09:40 paul Note Added: 0003020 04-Feb-10 20:37 tabrisnet Note Added: 0003023 04-Feb-10 20:54 tabrisnet Note Added: 0003024 16-Jul-10 14:31 Steven FlinthamNote Added: 0003080 16-Jul-10 14:35 Steven FlinthamFile Added: dbmail-syslog 16-Jul-10 14:37 Steven FlinthamIssue Monitored: Steven Flintham 16-Jul-10 14:41 Steven FlinthamNote Added: 0003081 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
