Re: BUG #10888: application is getting hanged in the poll() function of libpq.so.

Mitu Verma <mitu(dot)verma(at)ericsson(dot)com> writes:
> I am not sure if it is a postgres issue or not, so need your help in that.

Well, it looks like you've got two concurrent transactions trying to
insert the exact same data:

> 16384 | fm_db_CollectCCN | 20714 | 16391 | mmsuper | | ::1 | | 19540
> | 2014-07-07 19:10:09.295565+02 | 2014-07-07 19:10:09.311701+02 | 2014-07-07 19:10:09.311701+02 | f | INSERT INTO ev
> entLogEntry (object, method, bgwUser, time, realUser, host, application, tableIndex ) VALUES (E'Server', E'Start', E'bgw'
> , E'20140512122404', NULL, NULL, NULL, 539 )
> 16384 | fm_db_CollectCCN | 20819 | 16391 | mmsuper | | ::1 | | 19602
> | 2014-07-07 19:10:45.18688+02 | 2014-07-07 19:10:45.202903+02 | 2014-07-07 19:10:45.202903+02 | f | INSERT INTO ev
> entLogEntry (object, method, bgwUser, time, realUser, host, application, tableIndex ) VALUES (E'Server', E'Start', E'bgw'
> , E'20140512122404', NULL, NULL, NULL, 539 )

Presumably this is falling foul of a unique index on the table.
The second one is going to block until the first one either
commits or rolls back.

regards, tom lane