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

Re: Hanging locks?

From: Kresimir Tonkovic <z-el(dot)tonkovic(at)chipoteka(dot)hr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Hanging locks?
Date: 2006-10-23 14:31:54
Message-ID: 453CD25A.20801@chipoteka.hr (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Kresimir Tonkovic <z-el(dot)tonkovic(at)chipoteka(dot)hr> writes:
>   
>> I have a situation regarding locks that nobody seems to own:
>>     
>
> The only way pid can be null in a pg_locks entry is if the lock is held
> by a prepared transaction.  See pg_prepared_xacts view.
>
> 			regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>   
So i did
Chipoteka=> select * from pg_prepared_xacts;
 transaction |            gid            |           prepared            
| owner | database
-------------+---------------------------+-------------------------------+-------+-----------
     4202257 | 257_a3Jlc28vMTg4NDQ4_Mg== | 2006-10-20 12:22:08.72175+02  
| jboss | Chipoteka
     4518229 | 257_a3Jlc28vNTY3MzE3_Mg== | 2006-10-20 16:53:32.002687+02 
| jboss | Chipoteka
     4518231 | 257_a3Jlc28vNTY3MzI2_Mg== | 2006-10-20 16:53:32.036318+02 
| jboss | Chipoteka

and then:

Chipoteka=> commit prepared '257_a3Jlc28vMTg4NDQ4_Mg==';
COMMIT PREPARED
Chipoteka=> commit prepared '257_a3Jlc28vNTY3MzE3_Mg==';
COMMIT PREPARED
Chipoteka=> commit prepared '257_a3Jlc28vNTY3MzI2_Mg==';
COMMIT PREPARED

and I'm free! :-)

Thanks!

-- 
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


In response to

pgsql-bugs by date

Next:From: Thomas H.Date: 2006-10-23 16:21:34
Subject: Re: BUG #2712: could not fsync segment: Permission denied
Previous:From: Tom LaneDate: 2006-10-23 14:09:08
Subject: Re: Hanging locks?

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