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