[BUGS] BUG #14805: Issue with Duplicate entry

Поиск
Список
Период
Сортировка
От rani.renu@gmail.com
Тема [BUGS] BUG #14805: Issue with Duplicate entry
Дата
Msg-id 20170908032717.25640.1611@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14805: Issue with Duplicate entry  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14805
Logged by:          renu rani
Email address:      rani.renu@gmail.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)


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Wong, Yi Wen"
Дата:
Сообщение: Re: [BUGS] Old row version in hot chain become visible after a freeze
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [BUGS] BUG #14803: use receiverPtr as the endptr to callKeepLogSeg(endptr, &_logSegNo) in CreateRestartPoint