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 1gsrXG-0001HH-9N for pgsql-hackers@arkaria.postgresql.org; Sun, 10 Feb 2019 16:00:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gsrXE-0002Qq-Fn for pgsql-hackers@arkaria.postgresql.org; Sun, 10 Feb 2019 16:00:48 +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 1gsrXE-0002Pc-4W for pgsql-hackers@lists.postgresql.org; Sun, 10 Feb 2019 16:00:48 +0000 Received: from mail-it1-x141.google.com ([2607:f8b0:4864:20::141]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gsrX5-0000dB-N5 for pgsql-hackers@lists.postgresql.org; Sun, 10 Feb 2019 16:00:47 +0000 Received: by mail-it1-x141.google.com with SMTP id c9so20496205itj.1 for ; Sun, 10 Feb 2019 08:00:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=J0BHxM0WvDtKHjfRamT4ubItrliyUwEQcLUq2nLiH74=; b=w4zYlVV0x11OajgSLLt6Q5wSmq8IpzCjhSFBo1G0Zwsm+zsW5oBt0PLb+F67oyNkhd kbGwk81FP+5FSy1SgG49G0HhQilICO/JjpsedGx0rrTlVWamsgNsgUYp923e99DQS9Bs qL1VXJ0muXYFxvPRFe1Hq1aH7eGPy35+QF1oYGJlgB5kYUd54DcI+KLKZu0gqpCuGPjs lM/AEUngTbnirbqDisz0fqyY2c8ntldNLCDAso89RVTrLUKdrM91tNwlDlPeZjd/kCcy ALDKTQacicj/dT+VskTWPwrO+lhX4//QTJvDc1Zw0muZOLBJMAHi/d5XllkdwnS7211e mfWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=J0BHxM0WvDtKHjfRamT4ubItrliyUwEQcLUq2nLiH74=; b=tJGSG/HkcvnrRkd4OzPgMalFm0fO2nzt+cNIXZ+A7ATbsVN1/2nONvytZEGJydLmVM mGThK3/c1igXObAvhp1/oWEfpzMhn+r3DWtNCSDOoNNT3OM+g5/7uDE3+U9BTYuk2sA3 Gaq6ImxunGN0Q5CJCvXZizxBNTrQ5dH8G7v72KlD8ZqdYGivJ4OnM3UX6EZ/s8QVaiGA XCl7y8VMDE1clJrZyHNskcJZTLHQ5ame0BjZlOS/V9OebtCk8s8uqxjxJQQcjaPgLUOZ G31+UNkRxW9XhJabgGxqVcraO3MGffZiCu/3UyQoAzB0ZzPNlB53cdOcl8fGhJgcQE8i /cJw== X-Gm-Message-State: AHQUAuZWlXPZAKxMzExl+pLWvLOV486/eR9d3TdxLCC2LmJn2Es/X7TC gKaVxZtdUvhPAz0vVJYzXZgXNw== X-Google-Smtp-Source: AHgI3IaCMgwQtszNj+TiioEWCT3QS6xpdEtSO4TDE7/7Bd2YyE1hosUP0CLmTVpp5LuP1l9Q4cr0vg== X-Received: by 2002:a24:2711:: with SMTP id g17mr3472215ita.72.1549814437646; Sun, 10 Feb 2019 08:00:37 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id s25sm1673107iob.24.2019.02.10.08.00.36 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 10 Feb 2019 08:00:36 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 68044800BD7; Sun, 10 Feb 2019 10:00:35 -0600 (CST) Date: Sun, 10 Feb 2019 10:00:35 -0600 From: Justin Pryzby To: Robert Haas Cc: Thomas Munro , Jakub Glapa , Fabio Isabettini , Arne Roland , Sand Stone , Rick Otten , PostgreSQL Hackers Subject: Re: dsa_allocate() faliure Message-ID: <20190210160035.GS31721@telsasoft.com> References: <20190206232110.GH29720@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, Feb 10, 2019 at 12:10:52PM +0530, Robert Haas wrote: > I think I see what's happening. At the moment the problem occurs, > there is no btree - there is only a singleton range. So > FreePageManagerInternal() takes the fpm->btree_depth == 0 branch and > then ends up in the section with the comment /* Not contiguous; we > need to initialize the btree. */. And that section, sadly, does not > respect the 'soft' flag, so kaboom. Something like the attached might > fix it. I ran overnight with this patch, but all parallel processes ended up stuck in the style of bug#15585. So that's either not the root cause, or there's a 2nd issue. https://www.postgresql.org/message-id/flat/15585-324ff6a93a18da46%40postgresql.org Justin