From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: infernorb@gmail.com, pgsql-bugs@lists.postgresql.org, PG Bug reporting form <noreply@postgresql.org>
Subject: Re: BUG #15677: Crash while deleting from partitioned table
Date: Fri, 28 Jun 2019 17:56:03 -0400
Message-ID: <20190628215603.GA12247@alvherre.pgsql> (raw)
In-Reply-To: <3ad5ba71-d200-96da-f903-7e3b16416140@lab.ntt.co.jp>
On 2019-Mar-11, Amit Langote wrote:
> To reproduce, use these steps (needs 2 sessions to invoke EvalPlanQual at
> all):
>
> Setup:
>
> create table p (a int) partition by list (a);
> create table p1 partition of p for values in (1);
> insert into p values (1);
>
> Session 1:
>
> begin;
> update p set a = a;
>
> Session 2:
>
> with u as (update p set a = a returning p.*) update p set a = u.a from u;
> <blocks>
Hmmm ... I rewrote to this isolationtester spec and doesn't reproduce a
problem in master. I am probably missing something ...
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
setup {
create table p (a int) partition by list (a);
create table p1 partition of p for values in (1);
insert into p values (1);
}
session "s1"
setup { begin; }
step "s1_update" { update p set a = a; }
step "s1_commit" { commit; }
session "s2"
step "s2_update" { with u as (update p set a = a returning p.*) update p set a = u.a from u; }
permutation "s1_update" "s2_update" "s1_commit"
Attachments:
[text/plain] partition-eval-plan-qual.spec (394B, ../20190628215603.GA12247@alvherre.pgsql/2-partition-eval-plan-qual.spec)
download | inline:
setup {
create table p (a int) partition by list (a);
create table p1 partition of p for values in (1);
insert into p values (1);
}
session "s1"
setup { begin; }
step "s1_update" { update p set a = a; }
step "s1_commit" { commit; }
session "s2"
step "s2_update" { with u as (update p set a = a returning p.*) update p set a = u.a from u; }
permutation "s1_update" "s2_update" "s1_commit"
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: alvherre@2ndquadrant.com, Langote_Amit_f8@lab.ntt.co.jp, noreply@postgresql.org
Subject: Re: BUG #15677: Crash while deleting from partitioned table
In-Reply-To: <20190628215603.GA12247@alvherre.pgsql>
* 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