Re: 7.4b4 undetected deadlock?

When grilled further on (Sun, 05 Oct 2003 20:34:15 -0400),
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> confessed:

>
> Almost certainly, that guy is holding the lock REINDEX wants. The
> VACUUM is probably backed up behind the REINDEX. If you want to
> convince me it's a deadlock, you'll need to exhibit pg_locks contents.
>

tassiv=# select relname, pg_locks.* from pg_locks left join pg_class on (
pg_locks.relation = pg_class.oid );
relname | relation | database | transaction | pid | mode
| granted
-------------------+----------+----------+-------------+-------+---------------
-----------+---------
fits | 50033492 | 50032754 | | 29304 | AccessShareLock
| t
fits | 50033492 | 50032754 | | 29304 |
RowExclusiveLock | t
files | 50033470 | 50032754 | | 29304 | AccessShareLock
| t
files | 50033470 | 50032754 | | 29304 | RowShareLock
| t
files | 50033470 | 50032754 | | 29304 |
RowExclusiveLock | t
temp_obs_v | 50033589 | 50032754 | | 29335 |
RowExclusiveLock | t
files_file_id_seq | 50033468 | 50032754 | | 29304 | AccessShareLock
| t
groups | 50033448 | 50032754 | | 29335 | AccessShareLock
| t
groups | 50033448 | 50032754 | | 29335 | RowShareLock
| t
files_file_id_seq | 50033468 | 50032754 | | 29335 | AccessShareLock
| t
obs_id_seq | 50033525 | 50032754 | | 29304 | AccessShareLock
| t
pg_locks | 16759 | 50032754 | | 30797 | AccessShareLock
| t
pairs_pair_id_seq | 50033457 | 50032754 | | 29335 | AccessShareLock
| t
obs_id_seq | 50033525 | 50032754 | | 29335 | AccessShareLock
| t
temp_obs_v | 50033589 | 50032754 | | 29304 | AccessShareLock
| t
temp_obs_v | 50033589 | 50032754 | | 29304 |
RowExclusiveLock | t
imported | 50033638 | 50032754 | | 29304 | AccessShareLock
| t
imported | 50033638 | 50032754 | | 29304 |
RowExclusiveLock | t
pairs_pair_id_seq | 50033457 | 50032754 | | 29304 | AccessShareLock
| t
temp_obs_i | 50033625 | 50032754 | | 29335 |
RowExclusiveLock | t
temp_obs_i | 50033625 | 50032754 | | 29335 |
AccessExclusiveLock | f
imported | 50033638 | 50032754 | | 29335 | AccessShareLock
| t
imported | 50033638 | 50032754 | | 29335 |
RowExclusiveLock | t
| 65952259 | 50032754 | | 29304 |
AccessExclusiveLock | t
| | | 841262 | 29549 | ExclusiveLock
| t
| | | 841339 | 30797 | ExclusiveLock
| t
pairs | 50033459 | 50032754 | | 29304 | AccessShareLock
| t
pairs | 50033459 | 50032754 | | 29304 | RowShareLock
| t
pairs | 50033459 | 50032754 | | 29304 |
RowExclusiveLock | t
temp_obs_i | 50033625 | 50032754 | | 29549 |
ShareUpdateExclusiveLock | f
pairs | 50033459 | 50032754 | | 29335 | AccessShareLock
| t
pairs | 50033459 | 50032754 | | 29335 | RowShareLock
| t
pairs | 50033459 | 50032754 | | 29335 |
RowExclusiveLock | t
groups | 50033448 | 50032754 | | 29304 | AccessShareLock
| t
groups | 50033448 | 50032754 | | 29304 | RowShareLock
| t
| | | 841207 | 29304 | ExclusiveLock
| t
| | | 841234 | 29335 | ExclusiveLock
| t
files | 50033470 | 50032754 | | 29335 | AccessShareLock
| t
files | 50033470 | 50032754 | | 29335 | RowShareLock
| t
files | 50033470 | 50032754 | | 29335 |
RowExclusiveLock | t
temp_obs_i | 50033625 | 50032754 | | 29304 | AccessShareLock
| t
temp_obs_i | 50033625 | 50032754 | | 29304 |
RowExclusiveLock | t
pg_class | 1259 | 50032754 | | 30797 | AccessShareLock
| t
fits | 50033492 | 50032754 | | 29335 | AccessShareLock
| t
fits | 50033492 | 50032754 | | 29335 |
RowExclusiveLock | t
(45 rows)

--
18:41:49 up 65 days, 11:11, 4 users, load average: 2.20, 2.06, 2.07