Skip site navigation (1) Skip section navigation (2)

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

From: bricklen <bricklen(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)
Date: 2011-10-25 15:42:35
Message-ID: CAGrpgQ8ERvmy3q6JBjyn8Nq2+000c7A4uRrsGsdKNqtxmRbcYw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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?

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-10-25 16:10:38
Subject: Re: BUG #6269: Anomaly detection
Previous:From: Evgeniy GalkinDate: 2011-10-25 15:37:59
Subject: BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group