From: Toni Steinhauer <tsteinh@tsteinh.win.net>
To: pgsql-sql@postgresql.org
Subject: Cannot read block 0
Date: Tue, 18 Aug 1998 22:12:47 -0400
Message-ID: <35DA349F.C705CF39@tsteinh.win.net> (raw)
I have a very small table called stdheader that contains 2 columns, the
first is an ID (int4) and the other is a text field. Periodically, the
data in the table is refreshed by deleting all of the existing records
and reloading the new data from a tab-delimited text file. The data
appeared to load fine, but this time when I do a select * from
stdheader; within psql, I get the following message:
ERROR: cannot read block 0 of stdheader
Failed Assertion("!(((*&(buf->io_in_progress_lock)) == 0)):", File:
"bufmgr.c", Line: 665)
!(((*&(buf->io_in_progress_lock)) == 0)) (0) [Illegal seek]
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to
terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
When I try to drop the table using:
drop table stdheader;
I get the message: broken pipe
Any clues? We are running version 6.3.1 of postgresql.
Thanks for any assistance
Toni Steinhauer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tsteinh@tsteinh.win.net
Subject: Re: Cannot read block 0
In-Reply-To: <35DA349F.C705CF39@tsteinh.win.net>
References: <35DA349F.C705CF39@tsteinh.win.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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