ALTER TABLE ALTER COLUMN SET TYPE crash

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ALTER TABLE ALTER COLUMN SET TYPE crash
Date: 2020-08-25 04:14:06
Message-ID: CAEP4nAzwokLht2Bi3RCHNcCJBdOa8d7LnqJkDO1xiaH+biW8fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

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.

Steps to reproduce:
==================

ubuntu(at)laptop:~$ dropdb --if-exists tempdel && createdb tempdel
ubuntu(at)laptop:~$ ./pg_regress --use-existing --schedule=serial_schedule
--dbname=tempdel >/dev/null
ubuntu(at)laptop:~$ sleep 5 && psql -c "SELECT version();" tempdel
version
--------------------------------------------------------------------------------------------------------
PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
(1 row)

ubuntu(at)laptop:~$ psql -c "begin; ALTER TABLE ONLY public.xacttest ALTER
COLUMN a SET DATA TYPE TEXT USING public.max_xacttest(); ROLLBACK;"
tempdel
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
ubuntu(at)laptop:~$ sleep 5 && psql -c "SELECT 1;" tempdel
?column?
----------
1
(1 row)

-
robins tharakan

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2020-08-25 06:05:11 Re: ALTER TABLE ALTER COLUMN SET TYPE crash
Previous Message Robins Tharakan 2020-08-25 03:59:07 ALTER TABLE error - Could not read block 0