Re: 7.4Beta1 hang?

On Sat, 09 Aug 2003 21:17:05 -0400
Tom Lane <tgl@sss.pgh.pa.us> said something like:

> Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> > [much data]
> 
> Could you supply the relation names corresponding to the relation OIDs
> appearing in pg_locks, so we can be sure who's processing what?
> 

Well, there appears to be a mail problem.  Not sure if it's on my end,
or somewhere else.

I dug around a little and I might have what you asked for. The relname
looks correct for what's currently being processed, but I don't know why
some of the relation wouldn't have a name.  Of course, I made this up,
so it may be verrrry wrong...

tassiv=# select relation, mode, relname from pg_locks left join pg_class
on ( pg_locks.relation = pg_class.relfilenode );relation |           mode           |      relname      
----------+--------------------------+-------------------    1259 | AccessShareLock          | pg_class   16759 |
AccessShareLock         | pg_locks   17835 | AccessShareLock          | groups   17835 | RowShareLock             |
groups  17844 | AccessShareLock          | pairs_pair_id_seq   17846 | AccessShareLock          | pairs   17846 |
RowShareLock            | pairs   17846 | RowExclusiveLock         | pairs   17855 | AccessShareLock          |
files_file_id_seq  17857 | AccessShareLock          | files   17857 | RowShareLock             | files   17857 |
RowExclusiveLock        | files   17879 | AccessShareLock          | fits   17879 | RowExclusiveLock         | fits
17912| AccessShareLock          | obs_id_seq   17971 | AccessShareLock          | obs_v   17971 | RowExclusiveLock
  | obs_v   17984 | AccessShareLock          | temp_obs_v   17984 | RowExclusiveLock         | temp_obs_v   17984 |
ShareLock               | temp_obs_v   17984 | AccessExclusiveLock      | temp_obs_v   18015 | ShareUpdateExclusiveLock
|obs_i   18015 | AccessShareLock          | obs_i   18015 | RowExclusiveLock         | obs_i   18015 |
ShareUpdateExclusiveLock| obs_i   18028 | AccessShareLock          | temp_obs_i   18028 | RowExclusiveLock         |
temp_obs_i  18028 | ShareLock                | temp_obs_i   18028 | AccessExclusiveLock      | temp_obs_i   18045 |
AccessShareLock         | imported   18045 | RowExclusiveLock         | imported   18096 | AccessExclusiveLock      |
obs_i_loc_index  18096 | AccessExclusiveLock      | obs_i_loc_index   18099 | ShareLock                |    18099 |
AccessExclusiveLock     |    18101 | ShareLock                |    18101 | AccessExclusiveLock      | 34526324 |
AccessShareLock         | 34526324 | ShareLock                | 34526324 | AccessExclusiveLock      | 34527019 |
ShareLock               | 34527019 | AccessExclusiveLock      | 34527020 | ShareLock                | 34527020 |
AccessExclusiveLock     |          | ExclusiveLock            |          | ExclusiveLock            |          |
ExclusiveLock           | 
 


-- 09:02:24 up 9 days,  1:47,  4 users,  load average: 2.01, 2.03, 2.00