Re: ALTER TABLE ALTER COLUMN SET TYPE crash

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Robins Tharakan <tharakan(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ALTER TABLE ALTER COLUMN SET TYPE crash
Date: 2020-08-25 06:05:11
Message-ID: 20200825060511.GF2017@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2020-08-25 10:00:06 Re: invalid alloc size error possible in shm_mq
Previous Message Robins Tharakan 2020-08-25 04:14:06 ALTER TABLE ALTER COLUMN SET TYPE crash