pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Kamil Jońca <kjonca@fastmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: backend crash
Date: Mon, 13 Apr 2020 18:42:30 +0200
Message-ID: <20200413164230.lvlfbippew7ulzsh@development> (raw)
In-Reply-To: <20200413161913.2oytbclavuwi3fnx@development>
References: <87imi37spc.fsf@alfa.kjonca>
	<20200413114147.a42vf3tr3auybdtr@development>
	<394.1586790061@sss.pgh.pa.us>
	<20200413153246.r5amtd62cxvwlqkn@development>
	<87o8rv5q79.fsf@alfa.kjonca>
	<20200413161913.2oytbclavuwi3fnx@development>

On Mon, Apr 13, 2020 at 06:19:13PM +0200, Tomas Vondra wrote:
>On Mon, Apr 13, 2020 at 06:02:34PM +0200, Kamil Jońca wrote:
>>Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
>>
>>>On Mon, Apr 13, 2020 at 11:01:01AM -0400, Tom Lane wrote:
>>>>Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
>>>>>On Mon, Apr 13, 2020 at 09:25:35AM +0200, Kamil Jońca 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.
>
>I did run it about 100x, I'll reduce the amount of data and let it run.
>
>How often it crashes? What execution plan does it use?
>

Also, presumably you're building from source, right? What configure
options are you using?


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





view thread (13+ messages)  latest in thread

Message-ID: <20200413164230.lvlfbippew7ulzsh@development>
Permalink:  ../20200413164230.lvlfbippew7ulzsh@development/
Also on:    postgresql.org/message-id/20200413164230.lvlfbippew7ulzsh@development

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com, kjonca@fastmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
  Subject: Re: backend crash
  In-Reply-To: <20200413164230.lvlfbippew7ulzsh@development>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox