From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Mitu Verma <mitu(dot)verma(at)ericsson(dot)com> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #10888: application is getting hanged in the poll() function of libpq.so. |
Date: | 2014-07-07 18:35:11 |
Message-ID: | 28443.1404758111@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Moshe Jacobson | 2014-07-08 14:04:21 | LEFT JOINs not optimized away when not needed |
Previous Message | Mitu Verma | 2014-07-07 17:34:14 | Re: BUG #10888: application is getting hanged in the poll() function of libpq.so. |