On 29.09.2011 11:14, Erwan David wrote: > On 15/09/11 21:57, Erwan David wrote: >> On 09/09/11 18:38, Erwan David wrote: >>> I use dspam from debian wheezy with a postgresql backend, yesterday I >>> upgraded postgresql from 9.0 to 9.1, since then I cannot retrain mails. >>> When I try to do it (from web interface) mail still appears as innocent. >>> >>> There where sql errors >>> [09/09/2011 13:32:34] 2674: : SELECT >>> coalesce(substring(split_part(split_part(version(),' ',2),'.',3) FROM >>> E'\\d+')::int2,0) >>> >>> untill I restarted dspam and postgresql >>> >>> However retraining still seems to not work. >> I found this in postgresql log: >> 2011-09-15 21:55:42 CEST ERROR: duplicate key value violates unique >> constraint "dspam_token_data_uid_token_key" >> 2011-09-15 21:55:42 CEST DETAIL: Key (uid, token)=(1, >> 3908037574888045901) already exists. >> 2011-09-15 21:55:42 CEST STATEMENT: PREPARE dspam_update_plan (bigint) >> AS UPDATE dspam_token_data SET >> last_hit=CURRENT_DATE,innocent_hits=innocent_hits+1 WHERE uid=1 AND >> token=$1;PREPARE dspam_insert_plan (bigint,int,int) AS INSERT INTO >> dspam_token_data (uid,token,spam_hits,innocent_hits,last_hit) VALUES >> (1,$1,$2,$3,CURRENT_DATE); >> >> DOes this mean something to someone ? >> >> > It seems like a monologue, but here are latest news : > > it is indeed a bug in dspam postgresql driver, but which was not seen > before 9.1 because of a different default setting > > (see > http://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3413998&group_id=250683) > > workaround is to set default setting to former one waiting for new > version of postgresql driver. Could you try the latest GIT version of DSPAM and tell me if the problem still exists?
> I hope this helps someone. > > > ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
