Re: could not read block 77 of relation 1663/16385/388818775

Поиск
Список
Период
Сортировка
От Darren Reed
Тема Re: could not read block 77 of relation 1663/16385/388818775
Дата
Msg-id 49A13732.6030704@fastmail.net
обсуждение исходный текст
Ответ на could not read block 77 of relation 1663/16385/388818775  (Alexandra Nitzschke <an@clickware.de>)
Ответы Re: could not read block 77 of relation 1663/16385/388818775
Список pgsql-bugs
As another data point, I upgraded from 8.2.6 to 8.3.6
and I saw those corruption messages after restoring
pg_dump files back into the database with psql and
inserting a bunch of data (some duplicate records
got rejected.) The insertion of new data is via
perl's DBI interface.

This was after the upgrade, so there had been no
dirty stops, etc.

Thinking that it might be an index problem, I've tried
reindexing the entire database - no errors but neither
does the problem go away. Nor does it stop the database
from starting up.

Where it pops up seems to be random (going from the errors
on postgres's log from earlier starts.) At the moment,
it's stopping me from creating a new table or dropping an
existing table (where I first ran into the error.) But
accessing all of the tables is fine...

I suppose the logical thing for me to do is go back to 8.2.6.

Darren

ERROR:  could not read block 1 of relation 1664/0/1233: read only 0 of
8192 bytes

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

Предыдущее
От: "Peter Woodward"
Дата:
Сообщение: BUG #4671: Cluster Initialisation Fails on FreeBSD
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: could not read block 77 of relation 1663/16385/388818775