Re: [HACKERS] WARNING: relcache reference leak: relation "p1" notclosed - Mailing list pgsql-hackers

From Amit Langote
Subject Re: [HACKERS] WARNING: relcache reference leak: relation "p1" notclosed
Date
Msg-id 5e9dda6d-5d63-2e76-1bbb-c7ba75e4f6ad@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] WARNING: relcache reference leak: relation "p1" not closed  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] WARNING: relcache reference leak: relation "p1" not closed  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On 2017/03/07 7:28, Tom Lane wrote:
> Kevin Grittner <kgrittn@gmail.com> writes:
>> With e434ad39ae7316bcf35fd578dd34ad7e1ff3c25f I did a `make world`,
>> `make install-world`, a fresh default initdb, a start with default
>> config, `make installcheck`, connected to the regression database
>> with psql as the initial superuser, and ran:
> 
>> regression=# vacuum freeze analyze;
>> WARNING:  relcache reference leak: relation "p1" not closed
>> VACUUM
> 
> p1 is a partitioned table.  (BTW, could I lobby for people not to use such
> generic, collision-prone names for tables that will be left behind after
> the regression tests?)  Also, I find that "vacuum analyze" is sufficient,
> or even just "analyze", or "analyze p1".  I think it's highly likely this
> was introduced by 3c3bb99330aa9b4c2f6258bfa0265d806bf365c3.  Certainly
> that failed to add appropriate regression test cases, or we would have
> noticed this already.

That's right, sorry about that.  Attached patch fixes the relcache leak
and adds tests in vacuum.sql and truncate.sql.

Thanks,
Amit

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: [HACKERS] Small fix to postgresql.conf.sample's comment on max_parallel_workers
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] WARNING: relcache reference leak: relation "p1" not closed