ALTER TABLE error - Could not read block 0

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ALTER TABLE error - Could not read block 0
Date: 2020-08-25 03:59:07
Message-ID: CAEP4nAzLjxr+OTAZagJMm29wda_Yk5UzT-vpOrohq4pmMsg3DQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

While testing SQLSmith, I see that executing the following SQL on the
regression database gives an unexpected error. It doesn't crash the engine,
nonetheless I thought reporting it doesn't hurt (This tool is new to me, so
do let me know if I am doing something wrong here).

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

ubuntu(at)laptop:$ git log | head -3
commit 77c1537f512e6ac2513f8695c795dc94cbf207ee
Author: Michael Paquier <michael(at)paquier(dot)xyz>
Date: Mon Aug 24 16:46:52 2020 +0900
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:$ psql -c "SELECT version();" postgres
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 "ALTER TABLE ONLY public.pline ALTER COLUMN
slotname SET DATA TYPE TEXT USING cast(null as bpchar), ALTER COLUMN
comment SET DATA TYPE TEXT USING
public.pslot_backlink_view(cast(public.pline.backlink as bpchar));" tempdel
ERROR: could not read block 0 in file "base/13550023/13569741": read only
0 of 8192 bytes
CONTEXT: SQL statement "select * from PLine where slotname =
"outer".rec.backlink"
PL/pgSQL function pslot_backlink_view(character) line 20 at SQL statement

-
robins tharakan

Browse pgsql-bugs by date

  From Date Subject
Next Message Robins Tharakan 2020-08-25 04:14:06 ALTER TABLE ALTER COLUMN SET TYPE crash
Previous Message Mukesh Chhatani 2020-08-24 19:30:23 Re: Logical replication stalling for large tables with heavy write activity - Pg11