Postgres Pro
Downloads
Home   >   mailing lists

Re: deadlock problem in Ad serving.. - Mailing list pgsql-admin

From Bhuvan A
Subject Re: deadlock problem in Ad serving..
Date
Msg-id Pine.LNX.4.44.0301201527090.11065-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to deadlock problem in Ad serving..  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Responses Re: deadlock problem in Ad serving..  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Re: deadlock problem in Ad serving..  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: deadlock problem in Ad serving..  ("Christian Brink" <cb@onsitetech.com>)
List pgsql-admin
Tree view 
> ~~~~~~~~~~~~~~~~~~~~~~
> Error: DBD::Pg::st execute failed: ERROR:  deadlock detected at
> /usr/local/perlapache/lib/perl/Banner.pm line 71, <GEN1> line 7.
> ~~~~~~~~~~~~~~~~~~~~~~

It is a genuine error, occurs while two or more transaction process tries
to update/delete a same record simultaneously. You can overcome this by
locking the table in share row exclusive mode also. More details can be
found in the lock command documentation.

regards,
bhuvaneswaran

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: deadlock problem in Ad serving..
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: deadlock problem in Ad serving..