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

Deadlocks ?

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Deadlocks ?
Date: 2008-05-13 19:18:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi All;

we seem to be getting deadlock quite a lot. We have a python process  
that does the following and we keep getting deadlocks. Is this a real  
deadlock or maybe a wait condition? Any help in debugging / resolving  
this would be much appreciated.

Thanks in advance

cursor.execute("lock player_log_uuid in share update exclusive mode")

> Traceback (most recent call last):
>   File "", line 740, in InsertData
>     cursor.execute("lock player_log_uuid in share update exclusive  
> mode")
> ProgrammingError: deadlock detected
> DETAIL:  Process 23098 waits for ShareUpdateExclusiveLock on  
> relation 428126 of database 427376; blocked by process 23916.
> Process 23916 waits for ShareLock on transaction 46802680; blocked  
> by process 23098.


pgsql-admin by date

Next:From: Tino SchwarzeDate: 2008-05-13 19:30:48
Subject: Re: Deadlocks ?
Previous:From: Robert LorDate: 2008-05-13 17:14:08
Subject: Re: Postgres Cluster on Solaris

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