Re: Postgres error when adding new page

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres error when adding new page
Дата
Msg-id 24057.1349102522@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgres error when adding new page  (Marco Craveiro <marco.craveiro@gmail.com>)
Ответы Re: Postgres error when adding new page  (Marco Craveiro <marco.craveiro@gmail.com>)
Список pgsql-general
Marco Craveiro <marco.craveiro@gmail.com> writes:
> We're experiencing a lot of errors when using CDash on PostgreSQL 9.1,
> hosted on Mac OSX 10.6.8. The actual error message is as follows:

> SQL error in Cannot insert test:
> utility/asserter/assert_file_returns_true_for_empty_files into the
> database():ERROR:  failed to add old item to the right sibling while
> splitting block 191 of index "crc323"<br>

> I'm a bit stuck from here on. Is the likely reason for this problem
> filesystem corruption or am I barking at the wrong tree?

This definitely looks like index corruption, but blaming it on the
filesystem might be premature.  I'm wondering if this could be an
artifact of the WAL-replay bug fixed in 9.1.6.  I'd suggest updating
and then reindexing the index ...

            regards, tom lane


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

Предыдущее
От: pfote
Дата:
Сообщение: strange hot_standby behaviour
Следующее
От: Marco Craveiro
Дата:
Сообщение: Re: Postgres error when adding new page