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

Re: deadlock detected when calling function (Callfunction_name)

From: "Sachchida Ojha" <sojha(at)secure-elements(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Andreas Tille" <tillea(at)rki(dot)de>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: deadlock detected when calling function (Callfunction_name)
Date: 2007-07-31 16:38:51
Message-ID: E099DB9EF394534CBA0F62ED03CF3BBF0596FE43@EXVS01.IceMAIL.com (view raw or flat)
Thread:
Lists: pgsql-performance
8.2.3

Thanks
Regards
Sachchida N Ojha
sojha(at)secure-elements(dot)com
Secure Elements Incorporated
198 Van Buren Street, Suite 110
Herndon Virginia 20170-5338 USA
http://www.secure-elements.com/
800-709-5011 Main
703-709-2168 Direct
703-709-2180 Fax
This email message and any attachment to this email message is intended
only for the use of the addressee(s) named above. If the reader of this
message is not the intended recipient or the employee or agent
responsible for delivering the message to the intended recipient(s),
please note that any distribution or copying of this communication is
strictly prohibited.  If you have received this email in error, please
notify me immediately and delete this message.  Please note that if this
email contains a forwarded message or is a reply to a prior message,
some or all of the contents of this message or any attachments may not
have been produced by the sender.

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com] 
Sent: Tuesday, July 31, 2007 11:28 AM
To: Sachchida Ojha
Cc: Andreas Tille; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] deadlock detected when calling function
(Callfunction_name)

Sachchida Ojha wrote:
> 
> Hello,
> I am getting following error from my application. Can any body tell me
> how to find the process name and transaction details when the deadlock
> occurred? 
> 
> This problem did not occur consistently. 
> 
> Error log
> 
> 2007-07-30 19:09:12,140 ERROR [se.em.asset.persistence.AssetUpdate]
> SQLException calling procedure{? = call
update_asset_dependents(?,?,?)}
> for asset id 36
> 
> org.postgresql.util.PSQLException: ERROR: deadlock detected
> 
>   Detail: Process 21172 waits for ShareLock on transaction 5098759;
> blocked by process 21154.
> Process 21154 waits for ShareLock on transaction 5098760; blocked by
> process 21172.

What Postgres version is this?

-- 
Alvaro Herrera
http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-performance by date

Next:From: Bruce MomjianDate: 2007-07-31 18:22:50
Subject: Re: Semantics of PostgreSQL Server Log Stats
Previous:From: Merlin MoncureDate: 2007-07-31 16:16:38
Subject: Re: disk filling up

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