Re: TOAST table (or index?) corruption on PITR replica

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: TOAST table (or index?) corruption on PITR replica
Дата
Msg-id 87hc26bw82.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на TOAST table (or index?) corruption on PITR replica  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:

> 14903 2009-02-28 22:22:02 EST kangaroo app 49a9fe2e.3a37 ERROR: index
> "pg_toast_42299_index" contains unexpected zero page at block 23768
>
> There were actually several different instances of the first error
> involving different toast values.

Do you know how big this table was when the backup was taken? Were these
blocks present then or were they added since then? My suspicion would lie with
the relation extension code where there have been bugs before, but I don't see
any found recently.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: TOAST table (or index?) corruption on PITR replica
Следующее
От: Zdenek Kotala
Дата:
Сообщение: Re: Additional DTrace Probes