Re: Hanging locks?

Tom Lane wrote:
> Kresimir Tonkovic <z-el.tonkovic@chipoteka.hr> writes:
>=20=20=20
>> I have a situation regarding locks that nobody seems to own:
>>=20=20=20=20=20
>
> 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
>
>
>=20=20=20
So i did
Chipoteka=3D> select * from pg_prepared_xacts;
 transaction |            gid            |           prepared=20=20=20=20=
=20=20=20=20=20=20=20=20
| owner | database
-------------+---------------------------+-------------------------------+-=
------+-----------
     4202257 | 257_a3Jlc28vMTg4NDQ4_Mg=3D=3D | 2006-10-20 12:22:08.72175+02=
=20=20
| jboss | Chipoteka
     4518229 | 257_a3Jlc28vNTY3MzE3_Mg=3D=3D | 2006-10-20 16:53:32.002687+0=
2=20
| jboss | Chipoteka
     4518231 | 257_a3Jlc28vNTY3MzI2_Mg=3D=3D | 2006-10-20 16:53:32.036318+0=
2=20
| jboss | Chipoteka

and then:

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

and I'm free! :-)

Thanks!

--=20
Kre=C5=A1imir Tonkovi=C4=87
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.tonkovic@chipoteka.hr