deadlock while re-indexing table

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: deadlock while re-indexing table
Date: 2008-02-12 13:24:53
Message-ID: 2C988D2A-0927-409F-B925-1DD46AA8C877@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

reindex table user_profile;
ERROR: deadlock detected
DETAIL: Process 32450 waits for AccessExclusiveLock on relation
194689112 of database 163880909; blocked by process 31236.
Process 31236 waits for AccessShareLock on relation 194689110 of
database 163880909; blocked by process 32450.
jnj=# select * from pg_class where oid = 194689112;
relname | relnamespace | reltype | relowner | relam |
relfilenode | reltablespace | relpages | reltuples | reltoastrelid |
reltoastidxid | relhasindex | relisshared | relkind | relnatts |
relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids |
relhaspkey | relhasrules | relhassubclass | relfrozenxid | relacl |
reloptions
-------------------+--------------+---------+----------+-------
+-------------+---------------+----------+-------------+---------------
+---------------+-------------+-------------+---------+----------
+-----------+-------------+----------+----------+---------+------------
+------------+-------------+----------------+--------------+--------
+------------
user_profile_pkey | 2200 | 0 | 16384 | 403 |
293905914 | 0 | 6004 | 2.18844e+06 | 0
| 0 | f | f | i | 1
| 0 | 0 | 0 | 0 | 0 | f
| f | f | f | 0 | |
(1 row)

jnj=# select * from pg_class where oid = 194689110;
relname | relnamespace | reltype | relowner | relam |
relfilenode | reltablespace | relpages | reltuples | reltoastrelid |
reltoastidxid | relhasindex | relisshared | relkind | relnatts |
relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids |
relhaspkey | relhasrules | relhassubclass | relfrozenxid | relacl |
reloptions
-----------------------+--------------+---------+----------+-------
+-------------+---------------+----------+-------------+---------------
+---------------+-------------+-------------+---------+----------
+-----------+-------------+----------+----------+---------+------------
+------------+-------------+----------------+--------------+--------
+------------
user_profile_name_key | 2200 | 0 | 16384 | 403
| 293905879 | 0 | 8746 | 2.18843e+06 | 0
| 0 | f | f | i | 1
| 0 | 0 | 0 | 0 | 0 | f
| f | f | f | 0 | |

This is 100% repeatable ....

Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-02-12 14:21:35 Query using cursors using 100% CPU
Previous Message Alban Hertroys 2008-02-12 12:37:46 Re: type casting in 8.3