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

Hanging locks?

From: Kresimir Tonkovic <z-el(dot)tonkovic(at)chipoteka(dot)hr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Hanging locks?
Date: 2006-10-23 09:15:48
Message-ID: 453C8844.5040705@chipoteka.hr (view raw or flat)
Thread:
Lists: pgsql-bugs
I have a situation regarding locks that nobody seems to own:

using psql:

Chipoteka=> select pg_class.relname,pg_locks.* from pg_class,pg_locks 
where pg_class.relfilenode=pg_locks.relation;
   relname    | locktype | database | relation | page | tuple | 
transactionid | classid | objid | objsubid | transaction | pid  |      
mode       | granted
--------------+----------+----------+----------+------+-------+---------------+---------+-------+----------+-------------+------+-----------------+---------
 valuta       | relation |   366513 |   366657 |      |       
|               |         |       |          |     4518231 |    | 
AccessShareLock | t
 jezik        | relation |   366513 |   366567 |      |       
|               |         |       |          |     4202257 |    | 
AccessShareLock | t
 jezik        | relation |   366513 |   366567 |      |       
|               |         |       |          |     4518231 |    | 
AccessShareLock | t
 serverconfig | relation |   366513 |   375491 |      |       
|               |         |       |          |     4518231 |    | 
AccessShareLock | t
 mjesto       | relation |   366513 |   366584 |      |       
|               |         |       |          |     4518231 |    | 
AccessShareLock | t
 drzava       | relation |   366513 |   366550 |      |       
|               |         |       |          |     4518231 |    | 
AccessShareLock | t
 orgjed       | relation |   366513 |   366596 |      |       
|               |         |       |          |     4202257 |    | 
AccessShareLock | t
 serverconfig | relation |   366513 |   375491 |      |       
|               |         |       |          |     4202257 |    | 
AccessShareLock | t
 serverconfig | relation |   366513 |   375491 |      |       
|               |         |       |          |     4518229 |    | 
AccessShareLock | t
 drzava       | relation |   366513 |   366550 |      |       
|               |         |       |          |     4202257 |    | 
AccessShareLock | t
 valuta       | relation |   366513 |   366657 |      |       
|               |         |       |          |     4518229 |    | 
AccessShareLock | t
 jezik        | relation |   366513 |   366567 |      |       
|               |         |       |          |     4518229 |    | 
AccessShareLock | t
 valuta       | relation |   366513 |   366657 |      |       
|               |         |       |          |     4202257 |    | 
AccessShareLock | t
 pg_class     | relation |   366513 |     1259 |      |       
|               |         |       |          |     4658945 | 5709 | 
AccessShareLock | t
 orgjed       | relation |   366513 |   366596 |      |       
|               |         |       |          |     4518231 |    | 
AccessShareLock | t
 pg_locks     | relation |   366513 |    10342 |      |       
|               |         |       |          |     4658945 | 5709 | 
AccessShareLock | t
 drzava       | relation |   366513 |   366550 |      |       
|               |         |       |          |     4518229 |    | 
AccessShareLock | t
 mjesto       | relation |   366513 |   366584 |      |       
|               |         |       |          |     4202257 |    | 
AccessShareLock | t
 orgjed       | relation |   366513 |   366596 |      |       
|               |         |       |          |     4518229 |    | 
AccessShareLock | t
 mjesto       | relation |   366513 |   366584 |      |       
|               |         |       |          |     4518229 |    | 
AccessShareLock | t
(20 rows)

from the shell:

kresot(at)kreso:~$ ps auxw|grep post
postgres  1388  0.0  0.4 151980  6304 ?        S    09:16   0:00 
/usr/lib/postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/main 
-c unix_socket_directory=/var/run/postgresql -c 
config_file=/etc/postgresql/8.1/main/postgresql.conf -c 
hba_file=/etc/postgresql/8.1/main/pg_hba.conf -c 
ident_file=/etc/postgresql/8.1/main/pg_ident.conf -c 
external_pid_file=/var/run/postgresql/8.1-main.pid
postgres  1390  0.0  5.7 152128 89944 ?        S    09:16   0:00 
postgres: writer process  
postgres  1391  0.0  0.1  10728  1884 ?        S    09:16   0:00 
postgres: stats buffer process  
postgres  1392  0.0  0.0  10016  1424 ?        S    09:16   0:00 
postgres: stats collector process  
kresot    5699  0.0  0.0   3224   636 pts/0    S+   11:11   0:00 grep post

The situation is the same after I restart postgres.

My environment: postgres 8.1.4 on debian.

Is this a bug, or am I doing something wrong?

-- 
Krešimir Tonković
Z-el d.o.o.
Industrijska cesta 28, 10360 Sesvete, Croatia
Tel: +385 1 2022 758
Fax: +385 1 2022 741
Web: www.chipoteka.hr
e-mail: z-el(dot)tonkovic(at)chipoteka(dot)hr




Responses

pgsql-bugs by date

Next:From: Kresimir TonkovicDate: 2006-10-23 09:35:49
Subject: Re: Hanging locks?
Previous:From: Tom LaneDate: 2006-10-23 02:07:21
Subject: Re: BUG #2712: could not fsync segment: Permission denied

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