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