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 1jO1du-0002s0-SM for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Apr 2020 16:09:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jO1dt-0007Ey-Qg for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Apr 2020 16:09:01 +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 1jO1Xm-0003Q1-HP for pgsql-bugs@lists.postgresql.org; Mon, 13 Apr 2020 16:02:44 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jO1Xj-00065O-ID for pgsql-bugs@lists.postgresql.org; Mon, 13 Apr 2020 16:02:41 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id A0B8339E; Mon, 13 Apr 2020 12:02:37 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Mon, 13 Apr 2020 12:02:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com; h= from:to:cc:subject:references:date:in-reply-to:message-id :mime-version:content-type:content-transfer-encoding; s=fm2; bh= AtjoweMcjTUXUH5t/7JZFAEPWDiro8s9cc5thadOWik=; b=ivYX1+ffoUOdqZi5 dybVXYLdYLHa7kTRlF/PeFN+X+CFCA/1FgsWjaUDXCKTPh57zAIBx68TcnRxiPxW /lCzMo62VQ2Xz5LwAfZSwwjmlLADBS3ljLBmD7CrtBdHFIQou+pDXH1hdSHDKxjm MxSkAP84yzROwBKg2oleJ+PEXyPbxXhdbTCOXZces8LCuCEKR0zf5Q3BT2f4k6p2 Y+NhEObWslIqC0rB4+AfZdKserrtJ2Ry6e3tLt1lIhIj6e+7mxRz+ThhZl8zgEMt m1+oW0fJPQqDglW5sTh+ms162htMrFCF6wqoMdI7MUJgiQkJsLru02byJred91jE B3qIag== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=AtjoweMcjTUXUH5t/7JZFAEPWDiro8s9cc5thadOW ik=; b=dZ+G2moJitroFh/pycOj8sG7qfxsxpx1DZKrzkpas2cqOcXFAPH24xV1R LZ5r3g15k9vhU1RO6Me9Gl1E6HNJnpmeMyFpiJyrUpDkny0nuJGL+0AdSEqAFASU 3aHF4hqeXCi6QQIy6Z19dfBTZncqwilyNQVQ7+5YYFGY/jB5vubeoPC6COCRc5ki H8w+NV4d4SY2AEXRAsEPiVCKAw9XNP0VjbkQ3gOdKexZPmYUFedzM6Cy7ZYTyP8q zQKK8IjuMLSZL23NMHywNBdfzCwQgVznZ9YArSdUAei5AN58lDIyknbnpxrGSx3E gBB883ZaEOAWOJvTqJGpqFSpJjbDg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrvdelgdelkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefhvffufhffjgfkfgggtgfgsehtqhdttddtrehsnecuhfhrohhmpehkjhhonhgt rgesfhgrshhtmhgrihhlrdgtohhmucdlmfgrmhhilhculfhokngtrgdmnecuffhomhgrih hnpehsthhophhsthhophhnohhprdhplhenucfkphepudejkedrvdefhedrheehrdduieef necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepkhhjoh hntggrsehfrghsthhmrghilhdrtghomh X-ME-Proxy: Received: from alfa.kjonca (178235055163.warszawa.vectranet.pl [178.235.55.163]) by mail.messagingengine.com (Postfix) with ESMTPA id 39BAB3060076; Mon, 13 Apr 2020 12:02:36 -0400 (EDT) Received: from kjonca by alfa.kjonca with local (Exim 4.93) (envelope-from ) id 1jO1Xe-00EELp-1M; Mon, 13 Apr 2020 18:02:34 +0200 From: kjonca@fastmail.com (Kamil =?iso-8859-2?Q?Jo=F1ca?=) To: Tomas Vondra Cc: Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: backend crash References: <87imi37spc.fsf@alfa.kjonca> <20200413114147.a42vf3tr3auybdtr@development> <394.1586790061@sss.pgh.pa.us> <20200413153246.r5amtd62cxvwlqkn@development> Date: Mon, 13 Apr 2020 18:02:34 +0200 In-Reply-To: <20200413153246.r5amtd62cxvwlqkn@development> (Tomas Vondra's message of "Mon, 13 Apr 2020 17:32:46 +0200") Message-ID: <87o8rv5q79.fsf@alfa.kjonca> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tomas Vondra writes: > On Mon, Apr 13, 2020 at 11:01:01AM -0400, Tom Lane wrote: >>Tomas Vondra writes: >>> On Mon, Apr 13, 2020 at 09:25:35AM +0200, Kamil Jo=F1ca wrote: >>>> I have problem with (pseudo) random backend crashes. >>>> They seems to happen at one query, but not every time. >> >>> I've tried to reproduce this, but unfortunately it does not fail for me. >>> Chances are this depends on data. Can you prepare a small data sample >>> that would trigger the issue? >> >>This is evidently a parallel-query worker, so it's unlikely you'd ever >>get anywhere near this crash with a "small" data sample; for starters >>there'd have to be enough data to prompt use of a parallel plan. >> >>I doubt that the crash is very data-specific though. Maybe just fill >>the table with a lot of dummy data? >> > > I did that, of course, and the plan looks like this: > 1. Did you try run this many times? As I wrote this does not crash every time. I can reproduce this on my data by running query 1000 times in loop. 2. I can try to prepare test data, but it will be rather long process. Stay tuned :/ KJ --=20 http://stopstopnop.pl/stop_stopnop.pl_o_nas.html