Re: BUG #15446: Crash on ALTER TABLE - Mailing list pgsql-bugs

From Dmitry Molotkov
Subject Re: BUG #15446: Crash on ALTER TABLE
Date
Msg-id CADfhRD+Ee6gzUhAtLcxrenAt-SAt-BiLZ+GzpFWu4=NUQ_z8aQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15446: Crash on ALTER TABLE  (Andres Freund <andres@anarazel.de>)
Responses Re: BUG #15446: Crash on ALTER TABLE
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: NOTIFY does not work as expected
Next
From: Andres Freund
Date:
Subject: Re: NOTIFY does not work as expected