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: 8490DCB9-7D9B-47E5-B5A6-A0FD52C30C59@kevinkempterllc.com (view raw or flat)
Thread:
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 "StatsParser.py", 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.
  

Responses

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-2014 The PostgreSQL Global Development Group