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
