Thread: BufferLookup table corrupted

BufferLookup table corrupted

From
"William Meloney"
Date:
Hello, pgsql-admin,

Can you tell me what occurred?  How can I determine if the BufferLookup table is still corrupted?

pg_dump: ERROR:  BufTableDelete: BufferLookup table corrupted
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "l3feedflows" failed: PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY "l3feedflows" TO stdout;

The l3feedflows table is one in which records are inserted and then subsequently updated.  Would the BufferLookup table
bechanging during the update, perhaps as the pg_dump is occurring? 


Best regards.

William Meloney
bmeloney@mindspring.com
2002-05-10



Re: BufferLookup table corrupted

From
Tom Lane
Date:
"William Meloney" <bmeloney@mindspring.com> writes:
> pg_dump: ERROR:  BufTableDelete: BufferLookup table corrupted

Oh yeah?  Can you reproduce this from a standing start?

The buffer table lives in shared memory, so a postmaster restart will
reinitialize it.  But if you can reproduce the problem after a restart
then I'd sure like to see the sequence that does it.  I can't recall
any prior reports of this error message.

            regards, tom lane