Re: refcount leak warnings - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: refcount leak warnings
Date
Msg-id 20060627140852.GB16840@svana.org
Whole thread Raw
In response to refcount leak warnings  (Thomas Hallgren <thomas@tada.se>)
List pgsql-hackers
On Tue, Jun 27, 2006 at 03:55:06PM +0200, Thomas Hallgren wrote:
> I have a PL/Java user that performs some lengthy operations. Eventually,
> he get warnings like:
>
> WARNING: buffer refcount leak: [779] (rel=1663/16440/52989, blockNum=3,
> flags=0x27, refcount=1 2)

I think the comment about failing to clean up is correct. AIUI, if
you've done a heap_open without a heap_close, or an index_open without
an index_close, you'll get warnings like this. Maybe using SPI without
clearing everything.

Obviously something didn't get cleaned up somewhere, but what? Maybe
identifying the rel and looking at that block might help identify the
issue.

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Non-transactional pg_class, try 2
Next
From: Tom Lane
Date:
Subject: Re: refcount leak warnings