Hey guys, so I just moved from hash driver to PostgreSQL because the hash database are getting corrupt now and then because I'm running DSPAM in daemon mode.
The PostgreSQL setup was very straight forward with no problems and it's working fine. The only thing is that my PostgreSQL logfile size is already over 100 mb because of an error which repeats all the time. That's the error message: ---------------------------------------------------------------------- ERROR: duplicate key value violates unique constraint "dspam_token_data_uid_token_key" DETAIL: Key (uid, token)=(2965, -8557963846520988205) already exists. STATEMENT: PREPARE dspam_update_plan (bigint) AS UPDATE dspam_token_data SET last_hit=CURRENT_DATE,innocent_hits=innocent_hits+1 WHERE uid=2965 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 (2965,$1,$2,$3,CURRENT_DATE); ---------------------------------------------------------------------- I can't really tell when the error occurs but the hole log file is full of it (token and other values are different). Is that something serious? I don't really now what's going on there. Can I ignore that message or can I get rid of it? Would be nice if someone can help me out. I'm using a self compiled dspam-3.10.2 and also postgresql-9.2.1 Thanks, Hanno ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
