pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBufTableDelete: BufferLookup table corrupted
3+ messages / 2 participants
[nested] [flat]
* BufTableDelete: BufferLookup table corrupted
@ 2001-03-01 13:04 Blaise Carrupt <bc@mjtsa.com>
2001-03-01 15:45 ` Re: BufTableDelete: BufferLookup table corrupted Tom Lane <tgl@sss.pgh.pa.us>
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 13:04 BufTableDelete: BufferLookup table corrupted Blaise Carrupt <bc@mjtsa.com>
@ 2001-03-01 15:45 ` Tom Lane <tgl@sss.pgh.pa.us>
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