Re: Some 9.5beta2 backend processes not terminating properly?

From: Shay Rojansky <roji(at)roji(dot)org>
To: Andres Freund <andres(at)anarazel(dot)de>
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:47:11
Message-ID: CADT4RqAkrMmBr8Bx3AvzMxpPjMsdwpKk6YnLCZq8q1cpT7m3AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> > > 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?
>

The process definitely isn't busy looping - zero CPU usage.

I'll try to set up debugging, it may take some time though (unfamiliar with
PostgreSQL internals and Windows debugging techniques).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stas Kelvich 2015-12-30 17:49:34 Re: Tsvector editing functions
Previous Message Andres Freund 2015-12-30 17:44:54 Re: Some 9.5beta2 backend processes not terminating properly?