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. I hope this helps someone. ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
