BUG #14805: Issue with Duplicate entry

From: rani(dot)renu(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: rani(dot)renu(at)gmail(dot)com
Subject: BUG #14805: Issue with Duplicate entry
Date: 2017-09-08 03:27:17
Message-ID: 20170908032717.25640.1611@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14805
Logged by: renu rani
Email address: rani(dot)renu(at)gmail(dot)com
PostgreSQL version: 9.3.1
Operating system: Linux ( red hat 6)
Description:

We have one perl script that is opening DB connection and performing insert
into database . When duplicate entry coming in the query , Postgre
forcefully killing process itself and in postgre log " unexpected EOF on
client connection" error is coming.
This issue in not coming every time.

Below is the log data for reference.

<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> ERROR: duplicate key violates
unique constraint "abc_pkey"
<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> STATEMENT: insert into ab (id,
patch) values ('AB0202', 'V3.2.1-N904')
<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> LOG: unexpected EOF on client
connection
<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> DEBUG: proc_exit(0)
<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> DEBUG: shmem_exit(0)
<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> LOG: disconnection: session
time: 0:00:01.44 user=renu database=hydrastordb host=xxx.0.0.1 port=xxxx
<127.0.0.1(32851)%2009-01-20 04:05:07 GMT> DEBUG: exit(0)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2017-09-08 07:32:18 Re: BUG #14803: use receiverPtr as the endptr to call KeepLogSeg(endptr, &_logSegNo) in CreateRestartPoint
Previous Message Wong, Yi Wen 2017-09-07 20:02:34 Re: Old row version in hot chain become visible after a freeze