On 01-10-11 11:53, Stevan Bajic wrote: > 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? >
Changes seem to work as intended when used with postgresql 9.0.5 with standard_conforming_strings=on -- Tom ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
