From: kjonca@fastmail.com
To: Tomas Vondra <tomas.vondra@2ndquadrant.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:02:34 +0200
Message-ID: <87o8rv5q79.fsf@alfa.kjonca> (raw)
In-Reply-To: <20200413153246.r5amtd62cxvwlqkn@development>
References: <87imi37spc.fsf@alfa.kjonca>
<20200413114147.a42vf3tr3auybdtr@development>
<394.1586790061@sss.pgh.pa.us>
<20200413153246.r5amtd62cxvwlqkn@development>
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.
2. I can try to prepare test data, but it will be rather long
process. Stay tuned :/
KJ
--
http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
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: kjonca@fastmail.com, tomas.vondra@2ndquadrant.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: backend crash
In-Reply-To: <87o8rv5q79.fsf@alfa.kjonca>
* 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