Mailing List Archive: [DBMail 0001039]: Insert of relation between physmessage, header name and header value does not check already existing relations.

[DBMail 0001039]: Insert of relation between physmessage, header name and header value does not check already existing relations.

bugtrack at dbmail

Jan 24, 2014, 12:39 AM

Post #1 of 3 (1510 views)

Permalink

The following issue has been SUBMITTED.
======================================================================
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: 24-Jan-14 09:39 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.
======================================================================

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

======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

[DBMail 0001039]: Insert of relation between physmessage, header name and header value does not check already existing relations. [ In reply to ]

bugtrack at dbmail

Jan 24, 2014, 4:58 AM

Post #2 of 3 (1484 views)

Permalink

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: 24-Jan-14 13:58 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.

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
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

[DBMail 0001039]: Insert of relation between physmessage, header name and header value does not check already existing relations. [ In reply to ]

bugtrack at dbmail

Jan 26, 2014, 11:44 PM

Post #3 of 3 (1472 views)

Permalink

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