| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Shay Rojansky <roji(at)roji(dot)org> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Some 9.5beta2 backend processes not terminating properly? |
| Date: | 2015-12-30 17:42:14 |
| Message-ID: | 20151230174214.fi7eckx4n7xrgfft@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2015-12-30 19:38:23 +0200, Shay Rojansky wrote:
> > Hm. So that seems to indicate that, on windows, we're not properly
> > recognizing dead sockets in the latch code. Could you check, IIRC with
> > netstat or something like it, in what state the connections are?
> netstat shows the socket is in FIN_WAIT_2.
> > Any chance you could single-step through WaitLatchOrSocket() with a
> > debugger? Without additional information this is rather hard to
> > diagnose.
> >
>
> Uh I sure can, but I have no idea what to look for :) Anything
> specific?
Things that'd be interesting:
1) what are the arguments passed to WaitLatchOrSocket(), most
importantly wakeEvents and sock
2) are we busy looping, or is WaitForMultipleObjects() blocking
endlessly
3) If you kill -9 (well, terminate in the task manager) a client, while
stepping serverside in WaitLatchOrSocket, does
WaitForMultipleObjects() return? If so, what paths are we taking?
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-12-30 17:44:40 | Re: rows estimate in explain analyze for the BRIN index |
| Previous Message | Tom Lane | 2015-12-30 17:41:56 | Re: Some 9.5beta2 backend processes not terminating properly? |