Transaction Rollback Error: DeadLock Detected - Mailing list pgsql-general

From subhan alimy
Subject Transaction Rollback Error: DeadLock Detected
Date
Msg-id 1455608676647-5887760.post@n5.nabble.com
Whole thread Raw
Responses Re: Transaction Rollback Error: DeadLock Detected
List pgsql-general
Hello Everyone,


Here I have got and error of concurrent update,
Transaction Rollback Error: deadlock detected
process 4801 waits for sharelock on transaction 944461 blocked by process
4700.
process 4700 waits for sharelock on transaction 9444665 blocked by process
4801.
by default PostgreSQL server has to abort one transaction and proceed the
other one, in my case it did not.


Solutions will highly appreciated



--
View this message in context: http://postgresql.nabble.com/Transaction-Rollback-Error-DeadLock-Detected-tp5887760.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Suggest note in index documentation about long running transactions
Next
From: TROY Didier
Date:
Subject: ORA2PG HP-UX11i23 Itanium