The following issue has been CLOSED ====================================================================== http://dbmail.org/mantis/view.php?id=1039 ====================================================================== Reported By: ALyarskiy Assigned To: ====================================================================== Project: DBMail Issue ID: 1039 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: closed target: Resolution: won't fix Fixed in Version: ====================================================================== Date Submitted: 24-Jan-14 09:39 CET Last Modified: 28-Feb-14 09:21 CET ====================================================================== Summary: Insert of relation between physmessage, header name and header value does not check already existing relations. Description: Postgres log contains errors: ERROR: duplicate key value violates unique constraint "dbmail_header_pkey"
Full log attached. ====================================================================== ---------------------------------------------------------------------- (0003629) paul (administrator) - 24-Jan-14 13:58 http://dbmail.org/mantis/view.php?id=1039#c3629 ---------------------------------------------------------------------- this will only happen if a message has duplicate headers. That just doesn't seem to justify the added roundtrip for an additional query. ---------------------------------------------------------------------- (0003630) ALyarskiy (reporter) - 27-Jan-14 08:44 http://dbmail.org/mantis/view.php?id=1039#c3630 ---------------------------------------------------------------------- In this case it is unnecessary surcharge. But those headers are being inserted almost one by one in a row, so if we have adequate cache it is possible to check if such header already inserted or not. This operation would be much more "cheap" than db query. ---------------------------------------------------------------------- (0003650) paul (administrator) - 28-Feb-14 09:21 http://dbmail.org/mantis/view.php?id=1039#c3650 ---------------------------------------------------------------------- Closing this ticket. Issue History Date Modified Username Field Change ====================================================================== 24-Jan-14 09:39 ALyarskiy New Issue 24-Jan-14 09:39 ALyarskiy File Added: headers_duplicate_keys.postgres.log 24-Jan-14 13:58 paul Note Added: 0003629 27-Jan-14 08:44 ALyarskiy Note Added: 0003630 28-Feb-14 09:21 paul Note Added: 0003650 28-Feb-14 09:21 paul Status new => closed 28-Feb-14 09:21 paul Resolution open => won't fix ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
