BUG #7643: Issuing a shutdown request while server startup leads to server hang

From: haribabu(dot)kommi(at)huawei(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7643: Issuing a shutdown request while server startup leads to server hang
Date: 2012-11-08 18:15:02
Message-ID: E1TWWd4-0008AD-9E@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7643
Logged by: Haribabu
Email address: haribabu(dot)kommi(at)huawei(dot)com
PostgreSQL version: 9.2.1
Operating system: Suse Linux 10.2
Description:

Problem Reproduction:
1. Add recovery.conf to the database directory.
2. Start the server
3. Issue the shutdown request
and the shutdown request timing should be such that below server logs should
print.

Log:

./postgres -D data -p 3335
LOG: database system was shut down in recovery at 2012-11-08 19:42:42 IST
LOG: entering standby mode
LOG: received fast shutdown request
LOG: consistent recovery state reached at 0/17D0700
LOG: record with zero length at 0/17D0700

Problem reproduced in 9.3 head.

I think the following things are leading to the problem:

1. The postmaster is queued up with the following signals in the order of
SIGINT (shutdown) and SIGUSR1 (Here we create bgwriter and checkpoint) and
the current state of postmaster is PM_STARTUP.

we are creating the bgwriter and checkpoint after processing the shutdown
request, because of this reason no one is there is to send the SIGTERM to
bgwriter and checkpoint.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2012-11-09 06:03:32 Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown
Previous Message Sergey 2012-11-08 17:28:49 Re: BUG #7641: ERROR: must specify relation and object name when function contains DROP TRIGGER