pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
[OT] Flushing Postgres Function Cache
2+ messages / 1 participants
[nested] [flat]

* [OT] Flushing Postgres Function Cache
@ 2007-05-17 08:36  Raf <rafiq@joshua.dreamthought.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Raf @ 2007-05-17 08:36 UTC (permalink / raw)
  To: pgsql-admin

Greetings,

In the face of shabby google results, I hoped that someone hear might know 
something about the postgres function cache.  We have a server which 
reports an error of the form "cache lookup failed for function <oid>."

Initially, I'd hoped to resolve this without a restart (which didn't do 
the trick either), and had been searching for some way to clear postgres' 
internal function cache - I think it stores plans/hints/compiled-version 
relating to stored proc's?

I tried to select the reported oid out of pg_proc, which resulted in an 
empty set.

I then went on to explicitly drop the function and recreate it.  This was 
interspersed with numerous postgres restarts and dropping of all client 
connections.  In spite of this I still get the same error from our client 
which still reports the same OID; which doesn't exist in pg_proc.

In any case, I can't seem to find any documentation which tells me how 
to clear this cache.

Versions:

pg: postgresql v 8.0.1-r4
os: Gentoo Linux/Kernel 2.6.12.5 #1

Any help would be of value?

Cheers,

Raf






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [OT] Flushing Postgres Function Cache
@ 2007-05-17 11:27  Raf <rafiq@joshua.dreamthought.com>
  parent: Raf <rafiq@joshua.dreamthought.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Raf @ 2007-05-17 11:27 UTC (permalink / raw)
  To: pgsql-admin

Update on the status of my findings relating to the bug below:

I did:

rafiq@rafiq ~/scratch/ $ echo "select tablename from pg_tables where 
tablename like 'pg_%'" | psql -U <user> <db> > pg_tables.txt
rafiq@rafiq ~/scratch/ $ for i in `cat pg_tables.txt`; do echo 
"==$i=="; echo "select * from $i"| psql -U <user> <db> | grep 54881296; # 
the-oid;  done;

And got:

...
==pg_trigger==
    273090 | _ipt_replication_logtrigger_114 | 54881296 |     29 | t 
| f              | 
|            0 | f            | f              |       3 |        | 
_ipt_replication\000114\000vvvvvvkkkkvvv\000
...
==pg_depend==
    16412 | 54881725 |        0 |       1255 | 54881296 |           0 | n
...


Which to me looks very slonny related.  It seems like the OID related to a 
slonny trigger.

Has anyone seen this before, with regard to slonny?  I'm thinking of 
removing and readding slonny associations.  Is this best way forward?

Cheers,

Raf


On Thu, 17 May 2007, Raf wrote:

> Greetings,
>
> In the face of shabby google results, I hoped that someone hear might know 
> something about the postgres function cache.  We have a server which reports 
> an error of the form "cache lookup failed for function <oid>."
>
> Initially, I'd hoped to resolve this without a restart (which didn't do the 
> trick either), and had been searching for some way to clear postgres' 
> internal function cache - I think it stores plans/hints/compiled-version 
> relating to stored proc's?
>
> I tried to select the reported oid out of pg_proc, which resulted in an empty 
> set.
>
> I then went on to explicitly drop the function and recreate it.  This was 
> interspersed with numerous postgres restarts and dropping of all client 
> connections.  In spite of this I still get the same error from our client 
> which still reports the same OID; which doesn't exist in pg_proc.
>
> In any case, I can't seem to find any documentation which tells me how to 
> clear this cache.
>
> Versions:
>
> pg: postgresql v 8.0.1-r4
> os: Gentoo Linux/Kernel 2.6.12.5 #1
>
> Any help would be of value?
>
> Cheers,
>
> Raf
>
>
>
>



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-05-17 11:27 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-17 08:36 [OT] Flushing Postgres Function Cache Raf <rafiq@joshua.dreamthought.com>
2007-05-17 11:27 ` Raf <rafiq@joshua.dreamthought.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox