Received: from ns1.win.net (ns1.win.net [204.215.209.3]) by hub.org (8.8.8/8.7.5) with ESMTP id WAA28907 for ; Tue, 18 Aug 1998 22:09:36 -0400 (EDT) Received: from tsteinh.win.net (wnpop01-121.louisville-nap.net [24.235.30.121]) by ns1.win.net (8.8.7/8.6.9) with ESMTP id WAA01062 for ; Tue, 18 Aug 1998 22:09:27 -0400 (EDT) Message-ID: <35DA349F.C705CF39@tsteinh.win.net> Date: Tue, 18 Aug 1998 22:12:47 -0400 From: Toni Steinhauer X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Cannot read block 0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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