Skip site navigation (1) Skip section navigation (2)

Re: 7.4b4 undetected deadlock?

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To:
Cc: PGBugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: 7.4b4 undetected deadlock?
Date: 2003-10-06 00:43:25
Message-ID: 20031005184325.25f4f783.Robert_Creager@LogicalChaos.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2003-10-06 03:22:45
Subject: Re: 7.4b4 undetected deadlock?
Previous:From: Tom LaneDate: 2003-10-06 00:34:15
Subject: Re: 7.4b4 undetected deadlock?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group