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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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