Обсуждение: ANALYZE on parent table results in an error "tuple already updated by self"

Поиск
Список
Период
Сортировка

ANALYZE on parent table results in an error "tuple already updated by self"

От
Manuel Rigger
Дата:
Hi everyone,

In the example below, ANALYZE unexpectedly results in an error.

CREATE TABLE t0(c0 boolean , c1 integer);
CREATE TABLE t1(c0 boolean, c1 integer) INHERITS(t0);
INSERT INTO t0(c1) VALUES (0);
CREATE STATISTICS s0 ON c0, c1 FROM t0;
ANALYZE t0; -- unexpected: ERROR:  tuple already updated by self

I found this on the latest trunk version.

Best,
Manuel

Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"

От
Andres Freund
Дата:
Hi,

On 2019-07-24 03:19:19 +0200, Manuel Rigger wrote:
> Hi everyone,
> 
> In the example below, ANALYZE unexpectedly results in an error.
> 
> CREATE TABLE t0(c0 boolean , c1 integer);
> CREATE TABLE t1(c0 boolean, c1 integer) INHERITS(t0);
> INSERT INTO t0(c1) VALUES (0);
> CREATE STATISTICS s0 ON c0, c1 FROM t0;
> ANALYZE t0; -- unexpected: ERROR:  tuple already updated by self
> 
> I found this on the latest trunk version.

Yea, that's the bug I was referencing earlier in your other thread:
https://www.postgresql.org/message-id/20190619000837.awy6j7h45ahd4vop%40alap3.anarazel.de

Greetings,

Andres Freund

Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"

От
Michael Paquier
Дата:
Hi Manuel,

On Wed, Jul 24, 2019 at 03:19:19AM +0200, Manuel Rigger wrote:
> In the example below, ANALYZE unexpectedly results in an error.
>
> CREATE TABLE t0(c0 boolean , c1 integer);
> CREATE TABLE t1(c0 boolean, c1 integer) INHERITS(t0);
> INSERT INTO t0(c1) VALUES (0);
> CREATE STATISTICS s0 ON c0, c1 FROM t0;
> ANALYZE t0; -- unexpected: ERROR:  tuple already updated by self
>
> I found this on the latest trunk version.

This issue was introduced by v11 and has been already reported here:
https://www.postgresql.org/message-id/20190618231233.GA27470@telsasoft.com
--
Michael
Вложения

Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"

От
Manuel Rigger
Дата:
Thanks, and sorry for having overlooked this bug report!

Best,
Manuel

On Wed, Jul 24, 2019 at 8:00 AM Andres Freund <andres@anarazel.de> wrote:
>
> Hi,
>
> On 2019-07-24 03:19:19 +0200, Manuel Rigger wrote:
> > Hi everyone,
> >
> > In the example below, ANALYZE unexpectedly results in an error.
> >
> > CREATE TABLE t0(c0 boolean , c1 integer);
> > CREATE TABLE t1(c0 boolean, c1 integer) INHERITS(t0);
> > INSERT INTO t0(c1) VALUES (0);
> > CREATE STATISTICS s0 ON c0, c1 FROM t0;
> > ANALYZE t0; -- unexpected: ERROR:  tuple already updated by self
> >
> > I found this on the latest trunk version.
>
> Yea, that's the bug I was referencing earlier in your other thread:
> https://www.postgresql.org/message-id/20190619000837.awy6j7h45ahd4vop%40alap3.anarazel.de
>
> Greetings,
>
> Andres Freund