Re: ANALYZE locks pg_listener in EXCLUSIVE for long - Mailing list pgsql-hackers

At 02:54 PM 3/05/2004, Tom Lane wrote:
>I don't believe any of this.

mail=# select * from pg_locks where not granted; relation | database | transaction |  pid  |        mode         |
granted
----------+----------+-------------+-------+---------------------+---------    16414 |    17149 |             |  7847 |
AccessExclusiveLock| f    16414 |    17149 |             | 51015 | AccessExclusiveLock | f    16414 |    17149 |
    | 51149 | AccessExclusiveLock | f    16414 |    17149 |             | 51024 | AccessExclusiveLock | f    16414 |
17149|             | 48838 | AccessExclusiveLock | f    16414 |    17149 |             | 57670 | AccessExclusiveLock |
f   16414 |    17149 |             | 54535 | AccessExclusiveLock | f    16414 |    17149 |             | 57756 |
AccessExclusiveLock| f    16414 |    17149 |             | 25894 | AccessExclusiveLock | f    16414 |    17149 |
    | 55813 | AccessExclusiveLock | f    16414 |    17149 |             | 18181 | AccessExclusiveLock | f    16414 |
17149|             | 57846 | AccessExclusiveLock | f    16414 |    17149 |             | 44827 | AccessExclusiveLock |
f   16414 |    17149 |             | 52352 | AccessExclusiveLock | f    16414 |    17149 |             | 51239 |
AccessExclusiveLock| f    16414 |    17149 |             | 14610 | AccessExclusiveLock | f    16414 |    17149 |
    | 88549 | AccessExclusiveLock | f    16414 |    17149 |             | 36939 | AccessExclusiveLock | f    16414 |
17149|             | 57120 | AccessExclusiveLock | f    16414 |    17149 |             | 89107 | AccessExclusiveLock |
f   16414 |    17149 |             | 48915 | AccessExclusiveLock | f    16414 |    17149 |             | 74102 |
AccessExclusiveLock| f    16414 |    17149 |             | 51029 | AccessExclusiveLock | f    16414 |    17149 |
    | 51100 | AccessExclusiveLock | f    16414 |    17149 |             | 57865 | AccessExclusiveLock | f    16414 |
17149|             | 45777 | AccessExclusiveLock | f    16414 |    17149 |             | 22288 | AccessExclusiveLock |
f   16414 |    17149 |             | 52006 | AccessExclusiveLock | f    16414 |    17149 |             | 44829 |
AccessExclusiveLock| f    16414 |    17149 |             | 49073 | AccessExclusiveLock | f    16414 |    17149 |
    | 52827 | AccessExclusiveLock | f    16414 |    17149 |             | 21003 | AccessExclusiveLock | f    16414 |
17149|             | 50204 | AccessExclusiveLock | f
 
mail=# select * from pg_class where oid=16414;   relname   | relnamespace | reltype | relowner | relam | relfilenode |

relpages | reltuples | reltoastrelid | reltoastidxid | relh
asindex | relisshared | relkind | relnatts | relchecks | reltriggers | 
relukeys | relfkeys | relrefs | relhasoids | relhaspkey | rel
hasrules | relhassubclass |   relacl

-------------+--------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+-----

--------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+----
---------+----------------+------------ pg_listener |           11 |   16415 |        1 |     0 |       16414 
|        0 |         0 |             0 |             0 | f        | f           | r       |        3 |         0 |
    0 
 
|        0 |        0 |       0 | f          | f          | f         | f              | {=r/pgsql}
(1 row)

mail=# select * from pg_locks where granted and relation=16414; relation | database | transaction |  pid  |      mode
   | granted
 
----------+----------+-------------+-------+-----------------+---------    16414 |    17149 |             | 56399 |
AccessShareLock| t
 
(1 row)

mail=# \q
[~] root@beast>ps ax | grep 56399;
56399  ??  D      0:03.41 postmaster: pgsql mail 127.0.0.1 ANALYZE (postgres)
[~] root@beast>kill -TERM 56399
[~] root@beast>ps ax | grep 56399;
[~] root@beast>psql -p5443 -U pgsql mail
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help on internal slash
commands      \g or terminate with semicolon to execute query       \q to quit
 

mail=# select * from pg_locks where granted and relation=16414; relation | database | transaction | pid | mode |
granted
----------+----------+-------------+-----+------+---------
(0 rows)

mail=# select * from pg_locks where not granted; relation | database | transaction |  pid  |   mode    | granted
----------+----------+-------------+-------+-----------+---------          |          |    65738548 | 72279 | ShareLock
|f          |          |    65738548 | 40479 | ShareLock | f          |          |    65738548 | 46830 | ShareLock | f
       |          |    65738478 | 20762 | ShareLock | f
 
(4 rows)

mail=# select * from pg_locks where not granted; relation | database | transaction | pid | mode | granted
----------+----------+-------------+-----+------+---------
(0 rows)



----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 03 5330 3172          |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                 |    --________--
PGP key available upon request,  |  /
and from pgp.mit.edu:11371       |/