From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Luke Koops <luke.koops@entrust.com>
Cc: Pg Bugs <pgsql-bugs@postgresql.org>
Subject: Re: BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram
Date: Thu, 06 Sep 2012 16:58:11 -0400
Message-ID: <2172.1346965091@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+Tgmobza1jgS2tw9m1QmM-nDyUKoc21Lw9sVv_Y7bHOOfKjyg@mail.gmail.com>
References: <200907311459.n6VExuSa036743@wwwmaster.postgresql.org>
<CA+TgmoZheGK5AvR8Nw0WPwwxzvfpzFENdCbP_2ennJSBnraEnA@mail.gmail.com>
<1410.1344363743@sss.pgh.pa.us>
<CA+TgmobQ0sLjzHdEQZr9QG7n2r-BKej+UTH7rcPPh09doMvUDg@mail.gmail.com>
<1345576064-sup-7145@alvh.no-ip.org>
<9323.1345581034@sss.pgh.pa.us>
<CA+TgmoanozBPOBL0qB4OzP4Jn3xJHYaunwwfmRrT1sBZhnSgew@mail.gmail.com>
<28583.1345688651@sss.pgh.pa.us>
<CA+Tgmobza1jgS2tw9m1QmM-nDyUKoc21Lw9sVv_Y7bHOOfKjyg@mail.gmail.com>
Robert Haas <robertmhaas@gmail.com> writes:
> Well, bad news. Dave built an installer off the 9.1 tip, we provided
> it to the customer, and they can still reproduce the problem. It's
> not clear whether we've narrowed the scope of the problem without
> eliminating it, or whether that fix just didn't help at all. But they
> still can't reproduce it on 9.2. This suggests that there's some
> other difference between 9.1 and 9.2 that is relevant here, but I'm
> not sure what. Any ideas?
I guess that's reassuring, in a way: it means that all the thrashing
about we did to get the latch-ified stats collector logic to work on
Windows actually brought us to a better place.
However, for the purposes of fixing the older branches, it's not so
nice. I think it means that we'd have to back-port some or all of the
latch-related changes in pgstat.c:
commit 966970ed636586b80739c0d21aec7561f0fafedd
commit f1ca51549e9e7045a2db95a61744334f1dbb4d64
commit d461d0502b6e20c6d4ec326ba2faec8212fd5dee
commit 9b63e9869ffaa4d6d3e8bf45086a765d8f310f1c
and maybe even some of these fixes in win32_latch.c:
commit e42a21b9e6c9b9e6346a34b62628d48ff2fc6ddf
commit f40022f1adaeff85b01d98fea38cf5aa16814aa7
commit 8ebc908c575b3378c9d4096412d16d91d107311c
At least, that's where I'd go looking if I were responsible for fixing
this, which is a responsibility I disclaim. Looking through this
history reminds me how much time I've already wasted on that miserable
excuse for an operating system.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, robertmhaas@gmail.com, alvherre@2ndquadrant.com, luke.koops@entrust.com
Subject: Re: BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram
In-Reply-To: <2172.1346965091@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox