Quantcast

Database errors

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Database errors

Raymond Norton
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Database errors

Peter C. Ndikuwera
This was fixed upstream. See here:


--
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Database errors

Raymond Norton
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 <[hidden email]> 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
Loading...