Bariwa 2.1, Centos 6.2
I am attempting to run the database maintenance scripts via paster and
did not see any progress in reducing my message count, so checked the
postgres logs for today.
I found the logs loaded full of statements like this:
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)
ERROR: duplicate key value violates unique constraint
"ix_messages_messageid"
Is there a way to find a fix for this?
_______________________________________________
http://pledgie.com/campaigns/12056
