Re: Some 9.5beta2 backend processes not terminating properly?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Some 9.5beta2 backend processes not terminating properly?
Дата
Msg-id
12844.1451765502@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Amit Kapila <amit.kapila16@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Amit Kapila <amit.kapila16@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Amit Kapila <amit.kapila16@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Shay Rojansky <roji@roji.org>
Re: Some 9.5beta2 backend processes not terminating properly? Petr Jelinek <petr@2ndquadrant.com>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Petr Jelinek <petr@2ndquadrant.com>
Re: Some 9.5beta2 backend processes not terminating properly? Amit Kapila <amit.kapila16@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Petr Jelinek <petr@2ndquadrant.com>
Re: Some 9.5beta2 backend processes not terminating properly? Amit Kapila <amit.kapila16@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Brar Piening <lists@piening.info>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Petr Jelinek <petr@2ndquadrant.com>
Re: Some 9.5beta2 backend processes not terminating properly? Amit Kapila <amit.kapila16@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Magnus Hagander <magnus@hagander.net>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Robert Haas <robertmhaas@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Robert Haas <robertmhaas@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Robert Haas <robertmhaas@gmail.com>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Tom Lane <tgl@sss.pgh.pa.us>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Re: Some 9.5beta2 backend processes not terminating properly? Andres Freund <andres@anarazel.de>
Andres Freund  writes:
> I found a few more resources confirming that FD_CLOSE is edge
> triggered. Which probably doesn't just make our code buggy when waiting
> twice on the same socket, but probably also makes it very timing
> dependent: As the event is only triggered when the close actually occurs
> it's possible that we don't have any event associated with that socket:
> We only do so for shorts amount of time in WaitLatchOrSocket() and
> pgwin32_waitforsinglesocket().

Does the timing dependence explain why we've not been able to trigger this
by killing psql?

If the bug only occurs when the client connection drops when we're not
waiting for input, that would likely explain why nobody noticed it for
ten months.
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Andres Freund
Дата:
FAQ