Transaction Rollback Error: DeadLock Detected

From: subhan alimy <salimy2011(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction Rollback Error: DeadLock Detected
Date: 2016-02-16 07:44:36
Message-ID: 1455608676647-5887760.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2016-02-16 08:30:23 Re: Suggest note in index documentation about long running transactions
Previous Message Nikolai Zhubr 2016-02-16 00:52:48 Re: Actual row order in UPDATE and SELECT FOR UPDATE