Return-Path: X-Original-To: apmail-spamassassin-users-archive@www.apache.org Delivered-To: apmail-spamassassin-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7FE2F177D8 for ; Thu, 29 Jan 2015 11:17:58 +0000 (UTC) Received: (qmail 86683 invoked by uid 500); 29 Jan 2015 11:17:52 -0000 Delivered-To: apmail-spamassassin-users-archive@spamassassin.apache.org Received: (qmail 86653 invoked by uid 500); 29 Jan 2015 11:17:52 -0000 Mailing-List: contact users-help@spamassassin.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list users@spamassassin.apache.org Received: (qmail 86639 invoked by uid 99); 29 Jan 2015 11:17:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2015 11:17:52 +0000 X-ASF-Spam-Status: No, hits=1.0 required=10.0 tests=FORGED_YAHOO_RCVD,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mlnospam@yahoo.com designates 216.109.114.139 as permitted sender) Received: from [216.109.114.139] (HELO nm41-vm10.bullet.mail.bf1.yahoo.com) (216.109.114.139) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2015 11:17:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1422530244; bh=C0tPSKkkWgCWeZjVV8O0kWlxiTQaJovFbiLHw/K3YII=; h=Date:From:Reply-To:To:Subject:From:Subject; b=HEKgbT8fxyPqB32Xg37zXImlMnxC+W+xtVoW1ayN4MSxcm2ZOwYqUnlSo21b1/j3sg9LTzsUdLCKOSc0i4liOEPoYYkW/AB4WCGZ+Snc9ifpJtqJzfDChI3Y0h75MbEd3IZIFjPqQ/v8sBTyQ5YMnW+0yhLFHTsLMnhY/m53nq/6dKYXdGQhgJy6wHOzho4k0ug1gYR7zcnSs5QeR/pkkZWrSdEY841PjjvUh8cXl1WgiMAh6j84li3MEgM4mVQfhYu9tGI7nh0JplyNn69fZfA0VaeMCCOq+zwc3FIpaP1QzlLfEE0S9+VBIvNmh+ouzLyiAwzQ+cCkZHMfD/ktZQ== Received: from [98.139.215.141] by nm41.bullet.mail.bf1.yahoo.com with NNFMP; 29 Jan 2015 11:17:24 -0000 Received: from [98.139.212.211] by tm12.bullet.mail.bf1.yahoo.com with NNFMP; 29 Jan 2015 11:17:24 -0000 Received: from [127.0.0.1] by omp1020.mail.bf1.yahoo.com with NNFMP; 29 Jan 2015 11:17:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 426555.64386.bm@omp1020.mail.bf1.yahoo.com X-YMail-OSG: XtuzzjUVM1l1c4M9mNgVLmCXZOmqj1XAwA97o8_PaLU6mrzsxYhcSyw71cTDiGH uC18RBvPv3R8yEe5R6K6UxLcFJdkq0j694XL.cIlilBiqzRYN9o.gvc6wDVjXucq36FzOLIUuQcd lOpBZ2nZQg1xTKpRV1FMlxyGCko4bUXbk2KIzBbZ0YiDjzwnTrFly1r1hb5VgiqyhBPqV5vD7SF9 qMeuUWr9a.TXWut6sLw9C8A3iYb0EBVA8DyJQnu6q_qnlK588GcuxHflwWEZo0A.S2Jxa.a2VyMn zSt3qQlLie9AJIPc.R28XWY68n4OpJ5BUJ8LWC_Oy1592.rF8z4YQsZ0CwDN6ox8OmtpY_zPFs6D JD4nNaL34Akdezw8EdrPNPrxn2G9v3YCgudgHpciAKvF5vY40StahzSGoQOJ5TjTN8hrt8v3cVXf sRtLBM.SPq1QAvqGYDKDlQjQqZpGo33XlbSwMWU1RO.YzyccoYXk5BNVqItopBkxXOPlWmM33Dfq V4EkdExQ- Received: by 66.196.81.114; Thu, 29 Jan 2015 11:17:24 +0000 Date: Thu, 29 Jan 2015 11:17:23 +0000 (UTC) From: ML mail Reply-To: ML mail To: "users@spamassassin.apache.org" Message-ID: <1122639021.2339361.1422530243469.JavaMail.yahoo@mail.yahoo.com> Subject: duplicate key value violates unique constraint "bayes_seen_pkey" MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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