Re: BUG #15684: Server crash on DROP partitioned table - Mailing list pgsql-bugs

From Julien Rouhaud
Subject Re: BUG #15684: Server crash on DROP partitioned table
Date
Msg-id CAOBaU_Z7n+Lvray0LQffoRETC03EKkNujF7siBedwor1M323fg@mail.gmail.com
Whole thread Raw
In response to BUG #15684: Server crash on DROP partitioned table  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15684: Server crash on DROP partitioned table
List pgsql-bugs
Hi,

On Sun, Mar 10, 2019 at 7:55 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following query:
> create table at_partitioned (a int, b text) partition by range (a);
> create table at_part_1 partition of at_partitioned for values from (0) to
> (1000);
> create table at_part_2 partition of at_partitioned for values from (1000) to
> (2000);
> create index on at_partitioned (b);
> alter table at_partitioned alter column b type numeric using b::numeric;
> alter table at_partitioned alter column b type numeric using b::numeric;
> drop table at_partitioned cascade;
>
> crashes server (on REL_11_2 and REL_11_STABLE) with the error messages:
> psql:query.sql:7: WARNING:  AbortTransaction while in COMMIT state
> psql:query.sql:7: ERROR:  SMgrRelation hashtable corrupted
> PANIC:  cannot abort transaction 575, it was already committed
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> psql:query.sql:7: connection to server was lost
>
> and the following stack trace:
> [...]

It seems to be the same bug as described in bug #15672
(https://www.postgresql.org/message-id/15672-b9fa7db32698269f@postgresql.org).
I'm Cc-ing Amit just in case.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15684: Server crash on DROP partitioned table
Next
From: Alexander Lakhin
Date:
Subject: Re: BUG #15684: Server crash on DROP partitioned table