Re: SIGTERM does not stop backend postgres processes immediately

I just ran 'make check' for postgres and all 76 tests passed.

The problem I'm seeing, where a postgres backend process doesn't react
immediately to SIGTERM, occurs even when there is only one such
backend process, so this may be a different problem from the one
described in those earlier threads and recently fixed in CVS.

I'm seeing this problem as I test my patch for running postgres as an
NT service. But I just tried running postmaster directly from the
shell and I see the same problem.

Here's a scenario.

BASH WINDOW 1
| BASH WINDOW 2
| | BASH WINDOW 3
v v v

postmaster -i -D /usr/local/pgsql/data.test/ -d 1
### database comes up to "production state"

psql -h localhost template1
### starts up OK and prompts for a command

ps -ef
### 2 postgres processes (one is actually the
### postmaster) and 1 psql process

pg_ctl -D /usr/local/pgsql/data.test/ -m fast stop
### reports "waiting" and many dots

### "Fast Shutdown request" message appears

### times out and reports "failed"

[nothing more happens (which is the problem to be solved) until I do ...]

\d
### [Any command to the backend would do.]
### "connection terminated" message appears

### "database system is shut down" appears.

ps -ef
### the postgres processes are gone.

I know from inserting printfs into the backend code that the SIGTERM
signal handler function is not being called right after the stop
request. Rather, it is called only after the backend gets some data
over its input socket connection, from that "\d" in did in pg_ctl in
this case. It seems that the recv() call deep in the backend code
does not get interrupted by the SIGTERM.

On Tue, May 08, 2001 at 10:05:19PM -0400, Jason Tishler wrote:
> However, I have not built PostgreSQL with Cygwin 1.3.1 -- I have only run
> it against Cygwin 1.3.1. What happens when you run make check? Does the
> postmaster exit cleanly at the end of the regression test as expected?

I'm a little confused about the distinction you're making between
"Cygwin 1.3.1" and "Cygwin 1.3.1". ;-) Anyway, "make check"
completes without any errors. No apparent hangs.

--
Fred Yankowski fred(at)OntoSys(dot)com tel: +1.630.879.1312
Principal Consultant www.OntoSys.com fax: +1.630.879.1370
OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA