Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VbVBY-0000XY-Ty for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Oct 2013 12:47:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VbVBY-0005qV-E8 for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Oct 2013 12:47:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VbVBX-0005qJ-5U for pgsql-hackers@postgresql.org; Wed, 30 Oct 2013 12:47:43 +0000 Received: from moutng.kundenserver.de ([212.227.17.9]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VbVBR-0001w0-Ek for pgsql-hackers@postgresql.org; Wed, 30 Oct 2013 12:47:42 +0000 Received: from anarazel.de (p5DDC7045.dip0.t-ipconnect.de [93.220.112.69]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0M1QSH-1VvMJr3ckb-00tEoH; Wed, 30 Oct 2013 13:47:35 +0100 Received: by anarazel.de (Postfix, from userid 1000) id 1CA69104792; Wed, 30 Oct 2013 13:47:34 +0100 (CET) Date: Wed, 30 Oct 2013 13:47:34 +0100 From: Andres Freund To: Robert Haas Cc: Tom Lane , Andrew Dunstan , "pgsql-hackers@postgresql.org" Subject: Re: Something fishy happening on frogmouth Message-ID: <20131030124734.GA11429@awork2.anarazel.de> References: <6557.1383073940@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Provags-ID: V02:K0:ZRClnpqN2vAqyDRO3JE34zL5y3PoQs+MfS3X4rehcrK 80pZbhQuwxz5+0qFWHbmjfFx8D6lhAl7tzVk4uLA2+piA2pULr Kfa0SuQSJC3cpsOdD3klmSxgda09PfO+wjvZlBxUkqt06hxLjQ ACv5YMhvut+c+dEdE+Ok1zwIq2rzxZ3j7Tod/6HFG5JZ8kJgni lJFB1OjKnZSiwweJHuC/Ftkdu5L3w8X1ViS2PWrAYJjhmasLl3 vXzBFBBCTY8ImLyKdNRAkdKI9yEzBjlHIVJ7+iUoknVnHoxeC9 73KMGBMikvPgJqMx4rFGa4EEbfhBffodSQFtOC/4Ln4jzrSVif 51Pd/GDkDDApgXP0/kdwGWF+1xMryExifgUB/zWFg X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2013-10-30 08:45:03 -0400, Robert Haas wrote: > If I'm reading this correctly, the last three runs on frogmouth have > all failed, and all of them have failed with a complaint about, > specifically, Global/PostgreSQL.851401618. Now, that really shouldn't > be happening, because the code to choose that number looks like this: > > dsm_control_handle = random(); > > One possibility that occurs to me is that if, for some reason, we're > using the same handle every time on Windows, and if Windows takes a > bit of time to reclaim the segment after the postmaster exits (which > is not hard to believe given some previous Windows behavior I've > seen), then running the postmaster lots of times in quick succession > (as initdb does) might fail. I dunno what that has to do with the > patch, though. Could it be that we haven't primed the random number generator with the time or something like that yet? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers