You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@spamassassin.apache.org by ML mail <ml...@yahoo.com> on 2015/01/29 12:17:23 UTC

duplicate key value violates unique constraint "bayes_seen_pkey"

Hi,

I am using SA on Debian 7 with all Debian standard packages as well as a PostgreSQL database to store all Bayes data. 


>From time to time I see the following error in the PostgreSQL log file:


2015-01-29 11:56:26 CET ERROR:  duplicate key value violates unique constraint "bayes_seen_pkey"
2015-01-29 11:56:26 CET DETAIL:  Key (id, msgid)=(1, 3698286ebfb6cf3d3a265947504be472593011dc@sa_generated) already exists.
2015-01-29 11:56:26 CET STATEMENT:  INSERT INTO bayes_seen (id, msgid, flag)
VALUES ($1,$2,$3)

Is this a normal behavior? Or is this a sign that something might be wrong in my SA config?

Regards
ML