Update on the status of my findings relating to the bug below:
rafiq(at)rafiq ~/scratch/ $ echo "select tablename from pg_tables where
tablename like 'pg_%'" | psql -U <user> <db> > pg_tables.txt
rafiq(at)rafiq ~/scratch/ $ for i in `cat pg_tables.txt`; do echo
"==$i=="; echo "select * from $i"| psql -U <user> <db> | grep 54881296; #
273090 | _ipt_replication_logtrigger_114 | 54881296 | 29 | t
| f |
| 0 | f | f | 3 | |
16412 | 54881725 | 0 | 1255 | 54881296 | 0 | n
Which to me looks very slonny related. It seems like the OID related to a
Has anyone seen this before, with regard to slonny? I'm thinking of
removing and readding slonny associations. Is this best way forward?
On Thu, 17 May 2007, Raf wrote:
> 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
> 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.
> pg: postgresql v 8.0.1-r4
> os: Gentoo Linux/Kernel 126.96.36.199 #1
> Any help would be of value?
In response to
pgsql-admin by date
|Next:||From: Ritu Khetan||Date: 2007-05-17 11:27:37|
|Subject: Error while running Postgres 8.1 as a service|
|Previous:||From: Khan, Mahmood Ahram||Date: 2007-05-17 11:12:57|
|Subject: WAL FILES|