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
Ответ на
Re: Some 9.5beta2 backend processes not terminating
properly? (Andres Freund)
Список
Дерево обсуждения
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 по дате отправления
От: Andres Freund
Дата: