A NOTE has been added to this issue. ====================================================================== http://www.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: new target: ====================================================================== Date Submitted: 24-Jan-14 09:39 CET Last Modified: 27-Jan-14 08:44 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://www.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://www.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. 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 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
