Re: [GENERAL] Perl script is killed by SIGPIPE - Mailing list pgsql-general

From Vick Khera
Subject Re: [GENERAL] Perl script is killed by SIGPIPE
Date
Msg-id CALd+dce=18Ox2m45FBUBc87OBYazkbvw3TB+ByStGMS9AkD-uw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Perl script is killed by SIGPIPE  (Yogesh Sharma <yogeshraj95@gmail.com>)
List pgsql-general
On Mon, Sep 11, 2017 at 9:02 PM, Yogesh Sharma <yogeshraj95@gmail.com> wrote:
Dear All,

We have one perl script that is opening DB connection and performaing insert DB operation.When duplicate entry Comming in query,Postgres forecfully killing process itself and in Postgres log "unexpected EOF on client connection" error is Comming.
This issue is not Comming every time.
We have found child script is killed by signal 13 SIGPIPE. When duplicate key violates error occured, script is killed but not all time.


I'm going to bet that the SIGPIPE is totally unrelated to having a duplicate key violation. You will need to provide much more detail of what you observe to figure this out.
 

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] Joining 16 tables seems slow
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Joining 16 tables seems slow