Re: ALTER TABLE ALTER COLUMN SET TYPE crash

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: ALTER TABLE ALTER COLUMN SET TYPE crash
Дата
Msg-id 20200825060511.GF2017@paquier.xyz
обсуждение исходный текст
Ответ на ALTER TABLE ALTER COLUMN SET TYPE crash  (Robins Tharakan <tharakan@gmail.com>)
Ответы Re: ALTER TABLE ALTER COLUMN SET TYPE crash  (Bruce Momjian <bruce@momjian.us>)
Re: ALTER TABLE ALTER COLUMN SET TYPE crash  (Robins Tharakan <tharakan@gmail.com>)
Список pgsql-bugs
On Tue, Aug 25, 2020 at 02:14:06PM +1000, Robins Tharakan wrote:
> Unlike a recently reported similar issue, executing the following ALTER
> TABLE on the regression database crashes Postgres (master).
>
> Admittedly it doesn't do anything constructive (and am new to the tool),
> but do let me know if such reports are interesting and / or if you need
> more details for reproduction.

Such reports are constructive!  I can reproduce the crash here down to
9.5.  From what I can see, the problem comes from ATRewriteTable() ->
ExecEvalExpr() when we evaluate expressions with inputs coming from
the old tuple.  It looks like a memory corruption issue or a context
issue at quick glance, and I cannot get a clean backtrace.
--
Michael

Вложения

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

Предыдущее
От: Robins Tharakan
Дата:
Сообщение: ALTER TABLE ALTER COLUMN SET TYPE crash
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: invalid alloc size error possible in shm_mq