Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3t8d-00077m-KQ for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Aug 2020 03:33:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k3t8c-0007il-Gy for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Aug 2020 03:33:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k3t8c-0007ie-5r for pgsql-hackers@lists.postgresql.org; Fri, 07 Aug 2020 03:33:46 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1k3t8X-000887-Lr for pgsql-hackers@postgresql.org; Fri, 07 Aug 2020 03:33:45 +0000 Received: by mail-io1-xd33.google.com with SMTP id t15so581966iob.3 for ; Thu, 06 Aug 2020 20:33:41 -0700 (PDT) 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=wsRtWFt9w4QrNMbPEWlJt2BNsnSKTRjAD+8w7aZammk=; b=cVbSixWBpMdhNd4XqSFevIa8mUGfdTg5uA/XFCF+wod3P8HlkDBKyiWaTt5aHSkXew QcpWM9hrR9/8g/CiGlmg7ZNn+Lf6n48IadWvCymz3y1Jx7HZhEpqt0D0hb3j4pSTkC6N Id5aiJThFgl6PiPc1yT6c/fl95q2WJDz19JaQlceL1qoWs3984oJvEMPxYMZfzcy+hOL 03jy6YUKFxjnqAXydDbNmrmKUobZlQ58Hd8nE6L7Ip79db6corb30t90c0KfLRMv0NHR lWfSGpZZIHhf8TPFQQD5RCdH5nqu5gojmmZB7ki/xm6ThBt00MWTjNvta9GR8K1inT/p T7aA== 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=wsRtWFt9w4QrNMbPEWlJt2BNsnSKTRjAD+8w7aZammk=; b=L8s2d0N/+lQdYV0zttmH18kdSNmYTJN13nG/MW3RrFyrfNp5ZAlokgfqbNGQa1BrdS hy1oKftD8R1I8G0yDAHUXXR43o/D64fq6ksUi8QDLUOh3YY3akvsMJqzbQMsAx3XJuQv jvCw045FFYPa8vGPF3/5RrT0eENYH3wr5G3PM2LUB9CStcz9pmP4OJV0XB+pAHXLyj11 BvvLN5WvthVOkR07rnmcJ2H3lq8AoOIuiurXDwWLO0WjPtxFDs1C7e+MjJJLEfjCNT7Z 18tRXt37e/R5QcR2fbZ9WabC/e5eAUrpq86pP+eMUEYl0mp0DyoSoxVIgnn2cH9toCah a8kg== X-Gm-Message-State: AOAM531LKVj9LEV8/wgWXAWfX08YVyw5lQxT6M23jwDHSbuq318h+utL ulsmYheCVCKqY327748yp74gIw== X-Google-Smtp-Source: ABdhPJwRZ2WXJrfKJLfxcy89prDcfHxSFkXUpkVouaft70kwpwFHybS3qW7Z2jta0hYYsZc1uLeNKA== X-Received: by 2002:a5d:9bd5:: with SMTP id d21mr2434589ion.68.1596771220685; Thu, 06 Aug 2020 20:33:40 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id 186sm6086827ila.0.2020.08.06.20.33.39 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 06 Aug 2020 20:33:39 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id A20FD800864; Thu, 6 Aug 2020 22:33:37 -0500 (CDT) Date: Thu, 6 Aug 2020 22:33:37 -0500 From: Justin Pryzby To: Amit Langote Cc: Tom Lane , Andy Fan , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Message-ID: <20200807033337.GC20473@telsasoft.com> References: <2528807.1596648630@sss.pgh.pa.us> <2550497.1596651719@sss.pgh.pa.us> <2598266.1596686548@sss.pgh.pa.us> <2626504.1596724930@sss.pgh.pa.us> <2685059.1596760353@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Aug 07, 2020 at 12:16:11PM +0900, Amit Langote wrote: > Curiously, Justin mentioned upthread that the crash occurred during > BIND of a prepared query, so it better had been that a custom plan was > being executed, I'm looking at how to check that ... can you give a hint ? -- Justin