Re: BUG #15684: Server crash on DROP partitioned table

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: BUG #15684: Server crash on DROP partitioned table
Дата
Msg-id CAOBaU_Z7n+Lvray0LQffoRETC03EKkNujF7siBedwor1M323fg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15684: Server crash on DROP partitioned table  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #15684: Server crash on DROP partitioned table
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15684: Server crash on DROP partitioned table
Следующее
От: Alexander Lakhin
Дата:
Сообщение: Re: BUG #15684: Server crash on DROP partitioned table