This is a bug as far as I know. I believe a patch has been written for Baruwa enterprise editions .. now we must wait for the patch to trickle down to the community edition.
https://www.baruwa.org/blog/2013/08/03/baruwa-2.0.2-enterprise-edition-update-released/ 3rd up from the bottom ? -- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Valbuena, Angelo Sent: Wednesday, August 7, 2013 6:21 PM To: [email protected] Subject: [Baruwa] Error in postgresql log Getting this constantanly in the postresgql-xxx.log on a new install. Everything looks ok and mail is being scanned and stopped correctly but this error is constant in log with tail -f command. Is there a psql command to fix the database? ERROR: duplicate key value violates unique constraint "ix_messages_messageid" STATEMENT: INSERT INTO messages ( messageid,actions,clientip,date,from_address,from_domain, headers,hostname,highspam,rblspam,saspam,spam, nameinfected,otherinfected,isquarantined,isarchived, sascore,scaned,size,blacklisted,spamreport,whitelisted, subject,time,timestamp,to_address,to_domain, virusinfected ) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28) Angelo _______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056
