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 1hnAhg-000881-RK for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jul 2019 23:48:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnAhf-0005jm-N7 for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jul 2019 23:48:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnAhe-0005er-TZ for pgsql-hackers@lists.postgresql.org; Mon, 15 Jul 2019 23:48:19 +0000 Received: from resqmta-ch2-04v.sys.comcast.net ([2001:558:fe21:29:69:252:207:36]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hnAhc-00006t-8t for pgsql-hackers@postgresql.org; Mon, 15 Jul 2019 23:48:17 +0000 Received: from resomta-ch2-18v.sys.comcast.net ([69.252.207.114]) by resqmta-ch2-04v.sys.comcast.net with ESMTP id n8LshlYOeUhOfnAhZhh37j; Mon, 15 Jul 2019 23:48:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1563234493; bh=YRZ4g3HRRpfGIQFpt3R9dNkxA4u+F6Qe0WKYgIgYeVM=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=1XF8099oe34aE9mM2rJPqwcyeAEvYYg0OPXnWnlUqBkjqTX32vUxbrhwPE4EdvHA5 HXJ9ZJ/MeEm0EVhkOeJQ5YmbRtJ4j+s9Nl+zAERhulluUM9jiorybiMIfHyDcnA2W8 IU2uF3uHalZlhZ/joh3IGRJJ1vGsGQkCLz5f2pmkIvZsAyrD8Ou5FN0z/9MlMoeFgd F1Y1AL5IlZMlC8BRV/ezJOsn60BnGiswRWZDaHieoVXXl5cf53wYJv+pgeEzPPu4ag 2ot8cIXv74bVRSHvoshvbzpVMBO7fxk+aQq6+Oe1ZxzxrRfiCbFyEkSYFWuxQf3EOB VID/NmHhZZwHQ== Received: from jsievers.comcast.net ([12.187.116.132]) by resomta-ch2-18v.sys.comcast.net with ESMTPA id nAhRhwRdn7p2LnAhTh7BA2; Mon, 15 Jul 2019 23:48:11 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduvddrheelgddvgecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddtnecunecujfgurhephffvufffkfgfgggtsehttdertddtredtnecuhfhrohhmpeflvghrrhihucfuihgvvhgvrhhsuceoghhsihgvvhgvrhhsudelsegtohhmtggrshhtrdhnvghtqeenucfkphepuddvrddukeejrdduudeirddufedvnecurfgrrhgrmhephhgvlhhopehjshhivghvvghrshdrtghomhgtrghsthdrnhgvthdpihhnvghtpeduvddrudekjedrudduiedrudefvddpmhgrihhlfhhrohhmpehgshhivghvvghrshduleestghomhgtrghsthdrnhgvthdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedt X-Xfinity-VMeta: sc=0;st=legit Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id C85F126005A for ; Mon, 15 Jul 2019 18:48:05 -0500 (CDT) From: Jerry Sievers To: pgsql-hackers@postgresql.org Subject: SegFault on 9.6.14 Date: Mon, 15 Jul 2019 18:48:05 -0500 Message-ID: <87ims2amh6.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Greetings Hackers. We have a reproduceable case of $subject that issues a backtrace such as seen below. The query that I'd prefer to sanitize before sending is <30 lines of at a glance, not terribly complex logic. It nonetheless dies hard after a few seconds of running and as expected, results in an automatic all-backend restart. Please advise on how to proceed. Thanks! bt #0 initscan (scan=scan@entry=0x55d7a7daa0b0, key=0x0, keep_startblock=keep_startblock@entry=1 '\001') at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/access/heap/heapam.c:233 #1 0x000055d7a72fa8d0 in heap_rescan (scan=0x55d7a7daa0b0, key=key@entry=0x0) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/access/heap/heapam.c:1529 #2 0x000055d7a7451fef in ExecReScanSeqScan (node=node@entry=0x55d7a7d85100) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/nodeSeqscan.c:280 #3 0x000055d7a742d36e in ExecReScan (node=0x55d7a7d85100) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/execAmi.c:158 #4 0x000055d7a7445d38 in ExecReScanGather (node=node@entry=0x55d7a7d84d30) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/nodeGather.c:475 #5 0x000055d7a742d255 in ExecReScan (node=0x55d7a7d84d30) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/execAmi.c:166 #6 0x000055d7a7448673 in ExecReScanHashJoin (node=node@entry=0x55d7a7d84110) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/nodeHashjoin.c:1019 #7 0x000055d7a742d29e in ExecReScan (node=node@entry=0x55d7a7d84110) at /build/postgresql-9.6-5O8OLM/postgresql-9.6-9.6.14/build/../src/backend/executor/execAmi.c:226 -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net