Re: pg_ctl -m fast failing?
Ed L. <pgsql@bluepolka.net>
From: "Ed L." <pgsql@bluepolka.net>
To: josh@agliodbs.com, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
Date: 2003-03-07T20:19:08Z
Lists: pgsql-general
On Friday March 7 2003 11:56, Josh Berkus wrote: > Tom, > > > No, I'd not expect the second stop to fail; and I can't reproduce any > > such problem here. > > I've had it happen once. I've seen this many times when a bug like that described below was in play during shutdown. It's never been convenient to pin it down. > > The known bug might cause the *first* stop to fail; it basically > > triggers if you have a client that sits idle for a long time (while > > other sessions are doing work) and still remains idle after the > > shutdown command comes. > > So ... the workaround for 7.2.4 would be to have a server-side script > hunt for idle connections after shutdown and kill -9 them? There's a very small patch posted recently that fixes the problem, assuming you can apply it. Ed