Re: auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)
Дата
Msg-id 4EA6E237.5000802@enterprisedb.com
обсуждение исходный текст
Ответ на auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)  (bricklen <bricklen@gmail.com>)
Ответы Re: auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)
Список pgsql-bugs
On 25.10.2011 18:42, bricklen wrote:
> Tried on both
> PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc
> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
> and
> PostgreSQL 9.0.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc
> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
>
> shared_preload_libraries = 'pg_stat_statements,auto_explain'
> custom_variable_classes = 'auto_explain'
> auto_explain.log_min_duration = '10s'
> auto_explain.log_analyze = true
> auto_explain.log_buffers = true
>
> I was testing to see if any of the settings above got applied after
> issuing a "pg_ctl reload" rather than a restart, and I was surprised
> to see that I could crash my db cluster. I realize that the docs say
> to issue a restart, but the crash seems a tad user-unfriendly.
>
> Any other details I should provide?

A backtrace from the core dump would be help a lot. Can you get one?
More precise instructions on how to reproduce this would also be nice.

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

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #6269: Anomaly detection
Следующее
От: Greg Johnson
Дата:
Сообщение: Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin