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.
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 |