Home > mailing lists

session hang for same row update - Mailing list pgsql-general

From	AI Rumman
Subject	session hang for same row update
Date	December 1, 2011 14:10:32
Msg-id	CAGoODpdnxsSr6OtC78=SyHs+OGjb8dyZiqXOX=grFqdSK3TYUg@mail.gmail.com Whole thread Raw
Responses	Re: session hang for same row update (Adrian Klaver <adrian.klaver@gmail.com>)
List	pgsql-general

Could anyone please tell me why the session 2 is hanging?

I am using Postgresql 9.1.

show deadlock_timeout ;

deadlock_timeout

------------------

(1 row)

select * from t2;

i | nam

---+-----

2 | t4

1 | t3

Session 1:

BEGIN

update t2 set nam = 't3' where i=2;

UPDATE 1

Session 2:

BEGIN

update t2 set nam = 't3' where i=2;

hanged

From: Magnus Hagander
Date: 01 December 2011, 13:56:06
Subject: Re: Streaming Replication Over SSL

From: Adrian Klaver
Date: 01 December 2011, 14:23:48
Subject: Re: session hang for same row update