Hello.
A memory fault in a trigger left my database
in a corrupted state:

- A temporary table listed in pg_class
was not accessible with a select

- I could not DROP it

- I deleted the record from pg_class

- I can't create temporary tables anymore
(restart/vacuum full don't help)
ERROR: cache lookup failed for relation 1250714

Any hint?

--strk;

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

strk wrote:
> Hello.
> A memory fault in a trigger left my database
> in a corrupted state:
>

> - I can't create temporary tables anymore
> (restart/vacuum full don't help)
> ERROR: cache lookup failed for relation 1250714

*What* is giving this error? Something seems to be holding onto a
reference to (at a guess) your temporary table. Can you identify what?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

On Wed, Mar 23, 2005 at 01:48:11PM +0000, Richard Huxton wrote:
> strk wrote:
> >Hello.
> >A memory fault in a trigger left my database
> >in a corrupted state:
> >
>
> > - I can't create temporary tables anymore
> > (restart/vacuum full don't help)
> > ERROR: cache lookup failed for relation 1250714
>
> *What* is giving this error? Something seems to be holding onto a
> reference to (at a guess) your temporary table. Can you identify what?

Whatever is called from create temp table ..

strk=# create temp table test1(a int);
ERROR: cache lookup failed for relation 1250714
strk=# create temp table test2(a int);
ERROR: cache lookup failed for relation 1250714

PostgreSQL 8.0.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian)

--strk;

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

strk wrote:
> On Wed, Mar 23, 2005 at 01:48:11PM +0000, Richard Huxton wrote:
>
>>strk wrote:
>>
>>>Hello.
>>>A memory fault in a trigger left my database
>>>in a corrupted state:
>>>
>>
>>> - I can't create temporary tables anymore
>>> (restart/vacuum full don't help)
>>> ERROR: cache lookup failed for relation 1250714
>>
>>*What* is giving this error? Something seems to be holding onto a
>>reference to (at a guess) your temporary table. Can you identify what?
>
>
> Whatever is called from create temp table ..
>
> strk=# create temp table test1(a int);
> ERROR: cache lookup failed for relation 1250714
> strk=# create temp table test2(a int);
> ERROR: cache lookup failed for relation 1250714

Have you disconnected/reconnected since deleting the temp table?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Wed, Mar 23, 2005 at 02:49:53PM +0000, Richard Huxton wrote:
> strk wrote:
> >On Wed, Mar 23, 2005 at 01:48:11PM +0000, Richard Huxton wrote:
> >
> >>strk wrote:
> >>
> >>>Hello.
> >>>A memory fault in a trigger left my database
> >>>in a corrupted state:
> >>>
> >>
> >>> - I can't create temporary tables anymore
> >>> (restart/vacuum full don't help)
> >>> ERROR: cache lookup failed for relation 1250714
> >>
> >>*What* is giving this error? Something seems to be holding onto a
> >>reference to (at a guess) your temporary table. Can you identify what?
> >
> >
> >Whatever is called from create temp table ..
> >
> >strk=# create temp table test1(a int);
> >ERROR: cache lookup failed for relation 1250714
> >strk=# create temp table test2(a int);
> >ERROR: cache lookup failed for relation 1250714
>
> Have you disconnected/reconnected since deleting the temp table?

Yes. And vacuum full'd. And pg_ctl stop/start.
--strk;

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

strk <strk@keybit.net> writes:
> On Wed, Mar 23, 2005 at 01:48:11PM +0000, Richard Huxton wrote:
>> *What* is giving this error? Something seems to be holding onto a
>> reference to (at a guess) your temporary table. Can you identify what?

> Whatever is called from create temp table ..

"\set VERBOSITY verbose" might help.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)