Cannot read block 0

Поиск
Список
Период
Сортировка
От Toni Steinhauer
Тема Cannot read block 0
Дата
Msg-id 35DA349F.C705CF39@tsteinh.win.net
обсуждение исходный текст
Список pgsql-sql
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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Herouth Maoz
Дата:
Сообщение: Re: [GENERAL] The use of sequences
Следующее
От: Mark Dalphin
Дата:
Сообщение: Sub-select problem (or bug?)