Re: failed to re-find parent key in index "22723655" for split pages 370836/370837

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: failed to re-find parent key in index "22723655" for split pages 370836/370837
Дата
Msg-id 7753.1291075332@sss.pgh.pa.us
обсуждение исходный текст
Ответ на failed to re-find parent key in index "22723655" for split pages 370836/370837  (Anderson Valadares <andervalbh@gmail.com>)
Ответы Re: failed to re-find parent key in index "22723655" for split pages 370836/370837  (Anderson Valadares <andervalbh@gmail.com>)
Список pgsql-admin
Anderson Valadares <andervalbh@gmail.com> writes:
>  I am facing problems starting the database. Following is the error message.
> Can anyone help me?

> 2010-11-29 18:12:41 BRST [] - [5011]: [14-1] FATAL:  XX000: failed to
> re-find parent key in index "22723655" for split pages 370836/370837

The only way you're going to get out of that is with pg_resetxlog,
which is a fairly blunt instrument :-(.  It's possible that you will
have database corruption afterwards.  I'd recommend doing a dump and
reload to see if any problems appear.  It'd also be a good idea to save
a tarball copy of the $PGDATA file tree beforehand, so at least you can
get back to where you are in case things turn into a complete mess.

Can you tell us anything about how you got into this state?

            regards, tom lane

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

Предыдущее
От: Michael Holt
Дата:
Сообщение: Diagnosing Postgres Segfault
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Diagnosing Postgres Segfault