Re: failed assertion and panic in standby mode

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: failed assertion and panic in standby mode
Дата
Msg-id 4BDA7A28.70902@enterprisedb.com
обсуждение исходный текст
Ответ на failed assertion and panic in standby mode  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: failed assertion and panic in standby mode
Список pgsql-hackers
Jaime Casanova wrote:
> i was trying recent HS and get this when trying to start the standby,
> actually i was expecting a crash because i use full_page_writes=off
> and i guess it won't work.
> Maybe we could say full_page_writes=off and wal_level=hot_standby are
> conflicting and avoid such setup?

It's supposed to work.

> PANIC:  btree_redo: unknown op code 208
> CONTEXT:  xlog redo UNKNOWN

Hmm, I see a bug in btree_redo handling of XLOG_BTREE_REUSE_PAGE. If hot
standby is not enabled in the standby, it chokes on that record type.
It's missing from btree_desc too.

Fixed.

This demonstrates that there really has been little testing of warm
standby with hot standby disabled :-).

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: failed assertion and panic in standby mode
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_migrator to /contrib in a later 9.0 beta