Re: pg7.3b1

I am so glad that postgres now keeps track of relationships between rule,
views, functions, tables, etc. I've had to re-do all my creation and drop
scripts but this is definitely for the better.

During my testing of my scripts, I have come across this message:
psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0

What does this indicate?

Thanks,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
-----------------------------------
NextBus say:
Riders prefer to arrive just minute
before bus than just minute after.

On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
>
> I am so glad that postgres now keeps track of relationships between rule,
> views, functions, tables, etc. I've had to re-do all my creation and drop
> scripts but this is definitely for the better.
>
> During my testing of my scripts, I have come across this message:
> psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0
>
> What does this indicate?

Someone (probably me) made a mistake and forgot to release a cache
handle.

Do you happen to have a sequence of commands that can reproduce this?

--
Rod Taylor

I'll see if I can pare down my scripts (they are long) to reproduce this
easier.

L.
On 26 Sep 2002, Rod Taylor wrote:

> On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
> >
> > I am so glad that postgres now keeps track of relationships between rule,
> > views, functions, tables, etc. I've had to re-do all my creation and drop
> > scripts but this is definitely for the better.
> >
> > During my testing of my scripts, I have come across this message:
> > psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0
> >
> > What does this indicate?
>
> Someone (probably me) made a mistake and forgot to release a cache
> handle.
>
> Do you happen to have a sequence of commands that can reproduce this?
>
>

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
-----------------------------------
NextBus say:
Riders prefer to arrive just minute
before bus than just minute after.

Ok, finally had time to narrow this down.

Here's the simplified script that will reproduce this (this sequence
reroduces on my system using 7.3b2):

\echo BEGIN tst.sql

create table pp
( x integer
, i text
);

create view p as
select * from pp where i is null;

comment on view p is
'This is a comment.';

create rule p_ins as on insert to p do instead
insert into pp
values ( new.x
, null
);

comment on rule p_ins is 'insert to p goes to pp';

\echo END tst.sql

On 26 Sep 2002, Rod Taylor wrote:

> On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
> >
> > I am so glad that postgres now keeps track of relationships between rule,
> > views, functions, tables, etc. I've had to re-do all my creation and drop
> > scripts but this is definitely for the better.
> >
> > During my testing of my scripts, I have come across this message:
> > psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0
> >
> > What does this indicate?
>
> Someone (probably me) made a mistake and forgot to release a cache
> handle.
>
> Do you happen to have a sequence of commands that can reproduce this?
>
>

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
------------------------------
Do you know where your bus is?

Same rule patch, right email this time :)

Lock on the rule relation wasn't removed after adding the comment.

On Wed, 2002-10-02 at 19:03, Laurette Cisneros wrote:
> Ok, finally had time to narrow this down.
>
> Here's the simplified script that will reproduce this (this sequence
> reroduces on my system using 7.3b2):
>
> \echo BEGIN tst.sql
>
> create table pp
> ( x integer
> , i text
> );
>
> create view p as
> select * from pp where i is null;
>
> comment on view p is
> 'This is a comment.';
>
> create rule p_ins as on insert to p do instead
> insert into pp
> values ( new.x
> , null
> );
>
> comment on rule p_ins is 'insert to p goes to pp';
>
> \echo END tst.sql
>
>
> On 26 Sep 2002, Rod Taylor wrote:
>
> > On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
> > >
> > > I am so glad that postgres now keeps track of relationships between rule,
> > > views, functions, tables, etc. I've had to re-do all my creation and drop
> > > scripts but this is definitely for the better.
> > >
> > > During my testing of my scripts, I have come across this message:
> > > psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0
> > >
> > > What does this indicate?
> >
> > Someone (probably me) made a mistake and forgot to release a cache
> > handle.
> >
> > Do you happen to have a sequence of commands that can reproduce this?
> >
> >
>
> --
> Laurette Cisneros
> The Database Group
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> ------------------------------
> Do you know where your bus is?
>
>
--
Rod Taylor

Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Rod Taylor wrote:
> Same rule patch, right email this time :)
>
> Lock on the rule relation wasn't removed after adding the comment.
>
> On Wed, 2002-10-02 at 19:03, Laurette Cisneros wrote:
> > Ok, finally had time to narrow this down.
> >
> > Here's the simplified script that will reproduce this (this sequence
> > reroduces on my system using 7.3b2):
> >
> > \echo BEGIN tst.sql
> >
> > create table pp
> > ( x integer
> > , i text
> > );
> >
> > create view p as
> > select * from pp where i is null;
> >
> > comment on view p is
> > 'This is a comment.';
> >
> > create rule p_ins as on insert to p do instead
> > insert into pp
> > values ( new.x
> > , null
> > );
> >
> > comment on rule p_ins is 'insert to p goes to pp';
> >
> > \echo END tst.sql
> >
> >
> > On 26 Sep 2002, Rod Taylor wrote:
> >
> > > On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
> > > >
> > > > I am so glad that postgres now keeps track of relationships between rule,
> > > > views, functions, tables, etc. I've had to re-do all my creation and drop
> > > > scripts but this is definitely for the better.
> > > >
> > > > During my testing of my scripts, I have come across this message:
> > > > psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0
> > > >
> > > > What does this indicate?
> > >
> > > Someone (probably me) made a mistake and forgot to release a cache
> > > handle.
> > >
> > > Do you happen to have a sequence of commands that can reproduce this?
> > >
> > >
> >
> > --
> > Laurette Cisneros
> > The Database Group
> > (510) 420-3137
> > NextBus Information Systems, Inc.
> > www.nextbus.com
> > ------------------------------
> > Do you know where your bus is?
> >
> >
> --
> Rod Taylor

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Patch applied with Tom's fix for heap_close(NoLock). Thanks.

---------------------------------------------------------------------------

Rod Taylor wrote:
> Same rule patch, right email this time :)
>
> Lock on the rule relation wasn't removed after adding the comment.
>
> On Wed, 2002-10-02 at 19:03, Laurette Cisneros wrote:
> > Ok, finally had time to narrow this down.
> >
> > Here's the simplified script that will reproduce this (this sequence
> > reroduces on my system using 7.3b2):
> >
> > \echo BEGIN tst.sql
> >
> > create table pp
> > ( x integer
> > , i text
> > );
> >
> > create view p as
> > select * from pp where i is null;
> >
> > comment on view p is
> > 'This is a comment.';
> >
> > create rule p_ins as on insert to p do instead
> > insert into pp
> > values ( new.x
> > , null
> > );
> >
> > comment on rule p_ins is 'insert to p goes to pp';
> >
> > \echo END tst.sql
> >
> >
> > On 26 Sep 2002, Rod Taylor wrote:
> >
> > > On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
> > > >
> > > > I am so glad that postgres now keeps track of relationships between rule,
> > > > views, functions, tables, etc. I've had to re-do all my creation and drop
> > > > scripts but this is definitely for the better.
> > > >
> > > > During my testing of my scripts, I have come across this message:
> > > > psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation "positions" has refcnt 1 instead of 0
> > > >
> > > > What does this indicate?
> > >
> > > Someone (probably me) made a mistake and forgot to release a cache
> > > handle.
> > >
> > > Do you happen to have a sequence of commands that can reproduce this?
> > >
> > >
> >
> > --
> > Laurette Cisneros
> > The Database Group
> > (510) 420-3137
> > NextBus Information Systems, Inc.
> > www.nextbus.com
> > ------------------------------
> > Do you know where your bus is?
> >
> >
> --
> Rod Taylor

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073