Tom Lane wrote:
So i didKresimir Tonkovic <[EMAIL PROTECTED]> 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 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: [EMAIL PROTECTED] |
- [BUGS] Hanging locks? Kresimir Tonkovic
- Re: [BUGS] Hanging locks? Kresimir Tonkovic
- Re: [BUGS] Hanging locks? Tom Lane
- Re: [BUGS] Hanging locks? Kresimir Tonkovic