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)
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 |