Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hS22k-0002Le-Bk for pgsql-bugs@arkaria.postgresql.org; Sat, 18 May 2019 16:18:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hS22h-0007pN-F7 for pgsql-bugs@arkaria.postgresql.org; Sat, 18 May 2019 16:18:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hS22h-0007pG-7a for pgsql-bugs@lists.postgresql.org; Sat, 18 May 2019 16:18:39 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hS22f-0005es-EV for pgsql-bugs@lists.postgresql.org; Sat, 18 May 2019 16:18:38 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x4IGISGC028566; Sat, 18 May 2019 12:18:28 -0400 From: Tom Lane To: Michael Paquier cc: Andres Freund , Peter Eisentraut , Yuli Khodorkovskiy , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND In-reply-to: <20190518093522.GA19212@paquier.xyz> References: <4643.1557931189@sss.pgh.pa.us> <20190516013808.GA1415@paquier.xyz> <20190516021903.GB1415@paquier.xyz> <28927.1557977558@sss.pgh.pa.us> <20190516035617.GC1415@paquier.xyz> <20190516043618.GD1415@paquier.xyz> <31437.1557982294@sss.pgh.pa.us> <20190516060628.GE1415@paquier.xyz> <20190517042536.GM20887@paquier.xyz> <20190517202443.gw4zdfkpwgsjdel6@alap3.anarazel.de> <20190518093522.GA19212@paquier.xyz> Comments: In-reply-to Michael Paquier message dated "Sat, 18 May 2019 18:35:22 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <28564.1558196308.1@sss.pgh.pa.us> Date: Sat, 18 May 2019 12:18:28 -0400 Message-ID: <28565.1558196308@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Michael Paquier writes: > On Fri, May 17, 2019 at 01:24:43PM -0700, Andres Freund wrote: >> I don't think a windows-only patch is the same thing as a feature, one >> that makes debugging easier to boot, that's applicable to all >> platforms. > We are discussing here a set of problems which breaks the logging > collector to work on Windows, requiring mostly a Windows patch. And I > am not much willing to mess up with the area of shared memory handling > on Windows a couple of days before a beta. Yeah. I started digging around this finally, and I agree that the Windows side of it is a mess --- in particular, on Windows internal_forkexec() calls pgwin32_ReserveSharedMemoryRegion, which means we have a hard-wired assumption there that no postmaster child process is launched till after shared memory exists. EXEC_BACKEND on Unix will not reproduce that. At this point I agree with Michael that reverting 57431a911 is the most prudent thing to do for beta1. While it's probably not *that* hard to fix, it will require Windows-specific testing. Moreover, the fact that there are race conditions involved means that one person's testing might not catch everything. So I do not think we have enough time to get a trustworthy fix in place by Monday. And we do have other things to worry about. (I'm also getting annoyed that Peter, as the original author of this commit, isn't doing anything about the issue.) I wouldn't be totally opposed to un-reverting after beta1, if a better-tested patch emerges. But we don't have such a patch today and I don't see how we'll get there this weekend. regards, tom lane