pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BufTableDelete: BufferLookup table corrupted
3+ messages / 2 participants
[nested] [flat]

* BufTableDelete: BufferLookup table corrupted
@ 2001-03-01 13:04  Blaise Carrupt <bc@mjtsa.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Blaise Carrupt @ 2001-03-01 13:04 UTC (permalink / raw)
  To: pgsql-sql

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



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

* Re: BufTableDelete: BufferLookup table corrupted
@ 2001-03-01 15:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Blaise Carrupt <bc@mjtsa.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2001-03-01 15:45 UTC (permalink / raw)
  To: Blaise Carrupt <bc@mjtsa.com>; +Cc: pgsql-sql

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



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

* Re: BufTableDelete: BufferLookup table corrupted
@ 2001-03-01 16:57  Blaise Carrupt <bc@mjtsa.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Blaise Carrupt @ 2001-03-01 16:57 UTC (permalink / raw)
  To: pgsql-sql

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



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


end of thread, other threads:[~2001-03-01 16:57 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-01 13:04 BufTableDelete: BufferLookup table corrupted Blaise Carrupt <bc@mjtsa.com>
2001-03-01 15:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-03-01 16:57 Re: BufTableDelete: BufferLookup table corrupted Blaise Carrupt <bc@mjtsa.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