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
> 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 Schwarze||Date: 2008-05-13 19:30:48|
|Subject: Re: Deadlocks ?|
|Previous:||From: Robert Lor||Date: 2008-05-13 17:14:08|
|Subject: Re: Postgres Cluster on Solaris|