Re: 7.4b4 undetected deadlock? - Mailing list pgsql-bugs

From Robert Creager
Subject Re: 7.4b4 undetected deadlock?
Date
Msg-id 20031005184325.25f4f783.Robert_Creager@LogicalChaos.org
Whole thread Raw
In response to Re: 7.4b4 undetected deadlock?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.4b4 undetected deadlock?
List pgsql-bugs
When grilled further on (Sun, 05 Oct 2003 20:34:15 -0400),
Tom Lane <tgl@sss.pgh.pa.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4b4 undetected deadlock?
Next
From: Tom Lane
Date:
Subject: Re: 7.4b4 undetected deadlock?