Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: SpamAssassin: devel

[Bug 4642] concurrency problem in the PostgreSQL specific Bayes-module

 

 

SpamAssassin devel RSS feed   Index | Next | Previous | View Threaded


bugzilla-daemon at bugzilla

Oct 15, 2009, 11:15 AM

Post #1 of 1 (211 views)
Permalink
[Bug 4642] concurrency problem in the PostgreSQL specific Bayes-module

https://issues.apache.org/SpamAssassin/show_bug.cgi?id=4642

--- Comment #1 from Mark Martinec <Mark.Martinec [at] ijs> 2009-10-15 11:15:58 UTC ---
> However the approach used is subject to a racecondition in the case of multiple
> clients learning mails with similiar tokens (multiple spamds or sa-learns),
> because it might happen that a new token gets inserted(and commited) after the
> function got called but before it tries the insert resulting in the following
> error message in the postgresql log:

Btw, the same problem occurs in SQL-based AWL backend: process A does a SELECT
and does not find any entries, meanwhile process B does the same and INSERTs
its record, and when later process A tries to do its own INSERT (instead of
UPDATE), the SQL operation fails due to a key constraint.

--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

SpamAssassin devel RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.