Postgresql error in log ix_messages_messageid

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

Postgresql error in log ix_messages_messageid

Valbuena, Angelo
I am getting this in my postgresql logs. I think it was something that was going to be patched in the community version at a later date. Does anyone know if a patch is available yet?

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
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql error in log ix_messages_messageid

jeremymcs
http://baruwa-users-list.963389.n3.nabble.com/Error-in-postgresql-log-td4026887.html
Has not been back ported yet.

--
Jeremy McSpadden
Flux Labs | http://www.fluxlabs.net | Endless Solutions
Office : <a href="tel:850-250-5590;101" x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" x-apple-data-detectors-result="2" style="font-size: 12px;">850-250-5590x101 | Cell : <a href="tel:850-890-2543" x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" x-apple-data-detectors-result="3" style="font-size: 12px;">850-890-2543 | Fax : <a href="tel:850-254-2955" x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" x-apple-data-detectors-result="4" style="font-size: 12px;">850-254-2955

On Jan 29, 2014, at 5:35 PM, Valbuena, Angelo <[hidden email]> wrote:

I am getting this in my postgresql logs. I think it was something that was going to be patched in the community version at a later date. Does anyone know if a patch is available yet?

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
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql error in log ix_messages_messageid

Andrew Colin Kissa
Administrator

On 30 Jan 2014, at 2:02 AM, Jeremy McSpadden <[hidden email]> wrote:

> Has not been back ported yet.

Sorry i have not gotten to this yet, should do it soon.


_______________________________________________
http://pledgie.com/campaigns/12056

signature.asc (858 bytes) Download Attachment
--
Baruwa - www.baruwa.org