Re: BUG #15446: Crash on ALTER TABLE

Поиск
Список
Период
Сортировка
От Dmitry Molotkov
Тема Re: BUG #15446: Crash on ALTER TABLE
Дата
Msg-id CADfhRD+Ee6gzUhAtLcxrenAt-SAt-BiLZ+GzpFWu4=NUQ_z8aQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15446: Crash on ALTER TABLE  (Andres Freund <andres@anarazel.de>)
Ответы Re: BUG #15446: Crash on ALTER TABLE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
Hi, that was fast answer, thanks :)

Reproduce is easy if you can install python 3.
Here is empty django project that will reproduce it
install requirements from requirements file.
in djangotestpgbug\settings.py - set postgres user/password/database.
python manage.py migrate - it will run migration and it will crash postgres:latest from docker. Didnt tried without docker. But i dont think docker has anything to do with it.

Here is failing migration


сб, 20 окт. 2018 г. в 2:27, Andres Freund <andres@anarazel.de>:
Hi,

On 2018-10-19 23:20:10 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      15446
> Logged by:          Dmitry Molotkov
> Email address:      aldarund@gmail.com
> PostgreSQL version: 11.0
> Operating system:   docker
> Description:       
>
> postgres via docker.
> latest tag dont work.
>
> 2018-10-19 23:17:53.903 UTC [1] LOG:  server process (PID 69) was terminated
> by signal 11: Segmentation fault
> 2018-10-19 23:17:53.903 UTC [1] DETAIL:  Failed process was running: ALTER
> TABLE "admin_interface_theme" ALTER COLUMN
> "related_modal_background_opacity" TYPE varchar(5) USING
> "related_modal_background_opacity"::varchar(5)

Unfortunately this is not enough information to reproduce the
problem. It'd be very helpful if you could provide a reproducible set of
commands that trigger the crash.  Alternatively, should that prove hard,
the very least we're going to need the table definition of that
admin_interface_theme table, so we can attempt to reproduce the issue
ourselves.

Greetings,

Andres Freund

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: NOTIFY does not work as expected
Следующее
От: Andres Freund
Дата:
Сообщение: Re: NOTIFY does not work as expected