Обсуждение: BufTableDelete: BufferLookup table corrupted

Hi all !

I'm working with PostgreSQL 7.0.2, and I may have a little problem : my database 
seems to be corrupted.

When I connect to database (with psql, e.g.), I receive the message 'FATAL 1: 
BufTableDelete: BufferLookup table corrupted'.

If I insist, I can enter the database. But then, a couple of things doesn't work 
any more : \dt, to display tables, tells me 'ERROR: SearchSysCache: recursive 
use of cache 17'.

Statements seem to work, but I'm afraid the problem could extend.

So, is it so bad it seems to be ? Does someone has an idea how I can fix that 
problem without loosing all ?

Thanks in advance.

_____________
B. Carrupt

I restarted Postmaster and it works now ! Thanks.

The only thing I can say about it is that I was in the middle of a transaction 
executed in background, using 100% CPU, and I killed the postmaster forked for 
my transaction (I work under HP-UX). Maybe I shouldn't do this... :)

___________
B. Carrupt

Blaise Carrupt <bc@mjtsa.com> writes:
> When I connect to database (with psql, e.g.), I receive the message
> 'FATAL 1: BufTableDelete: BufferLookup table corrupted'.

Try restarting the postmaster.  AFAICS your problems are just with
datastructures in shared memory, so a postmaster restart should clean
them up.

If you can figure out the sequence of actions that produced this state
in the first place, please file a bug report with details ...
        regards, tom lane