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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
