Thank you!
Applied the fixes. now seeing the following error:
ERROR: invalid byte sequence for encoding "UTF8": 0xa0
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
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)
On Mon, 2015-09-28 at 22:53 +0300, Peter C. Ndikuwera wrote:
> This was fixed upstream. See here:
>
>
> https://github.com/akissa/baruwa2/issues/52
>
>
> --
> Evolution (n): A hypothetical process whereby infinitely improbable
> events occur with alarming frequency, order arises from chaos, and no
> one is given credit.
>
> On 28 September 2015 at 22:32, Raymond <[email protected]> wrote:
> 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
>
>
> _______________________________________________
> http://pledgie.com/campaigns/12056
_______________________________________________
http://pledgie.com/campaigns/12056
