Skip site navigation (1) Skip section navigation (2)

commit after dead lock

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: commit after dead lock
Date: 2004-01-30 00:25:40
Message-ID: 4019A484.5010509@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all,
is it normal that postgres dont complain
doing a commit after a deadlock ?

kalman=# select * from test where a = 5 for update;
ERROR:  deadlock detected
DETAIL:  Process 4144 waits for ShareLock on transaction 40180; blocked 
by process 4141.
Process 4141 waits for ShareLock on transaction 40181; blocked by 
process 4144.
kalman=# commit;
COMMIT
kalman=#


Regards
Gaetano Mendola


Responses

pgsql-admin by date

Next:From: Mark HarrisonDate: 2004-01-30 01:00:27
Subject: hung postmaster when client machine dies?
Previous:From: scott.marloweDate: 2004-01-29 23:52:31
Subject: Re: Forcing connections closed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group