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: 28-Jan-10 02:27 CET ====================================================================== 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? 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 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev