agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Alexander Lakhin <exclusion@gmail.com>
To: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
To: pgsql-bugs@lists.postgresql.org, Alexandre Felipe <o.alexandre.felipe@gmail.com>
Subject: Re: BUG #19687: ALTER SEQUENCE provokes error XX001 could not read blocks
Date: Wed, 23 Sep 2026 21:00:00 +0300
Message-ID: <7ac90032-cf60-4415-a7f9-cf512196db35@gmail.com> (raw)
In-Reply-To: <CAJTYsWWH0N-jJUviz3eviLa_ehGVsmumOmpTGufbRAsuDD2Uiw@mail.gmail.com>
References: <19687-dd094472b0c48afb@postgresql.org>
<CAJTYsWWH0N-jJUviz3eviLa_ehGVsmumOmpTGufbRAsuDD2Uiw@mail.gmail.com>
Hello Ayush and Alexandre,
14.09.2026 22:07, Ayush Tiwari wrote:
> On Mon, 14 Sept 2026 at 20:23, PG Bug reporting form
> <noreply@postgresql.org> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 19687
>> ...
>> The following script:
>> ...
>>
>> triggers:
>> iteration 3
>> ERROR: could not read blocks 0..0 in file "base/16384/16597": read only 0
>> of 8192 bytes
>> 2026-09-14 07:53:16.554 EEST [2078499:4] psql XX001 ERROR: could not read
>> blocks 0..0 in file "base/16384/16597": read only 0 of 8192 bytes
>> 2026-09-14 07:53:16.554 EEST [2078499:5] psql XX001 STATEMENT: SELECT *
>> FROM s;
Thank you for working on the fix!
Just for the record: with these parameters:
cpu_tuple_cost = 10000
min_parallel_table_scan_size = 1
set, the same script triggers also:
TRAP: failed Assert("RelFileLocatorEquals(relation->rd_locator, pscan->phs_locator)"), File: "tableam.c", Line: 173,
PID: 4140896
ExceptionalCondition at assert.c:51:13
table_beginscan_parallel at tableam.c:178:14
ExecSeqScanInitializeWorker at nodeSeqscan.c:450:30
ExecParallelInitializeWorker at execParallel.c:1406:5
ParallelQueryMain at execParallel.c:1566:2
ParallelWorkerMain at parallel.c:1571:2
BackgroundWorkerMain at bgworker.c:868:2
postmaster_child_launch at launch_backend.c:269:3
StartBackgroundWorker at postmaster.c:4222:5
(inlined by) maybe_start_bgworkers at postmaster.c:4385:9
ServerLoop at postmaster.c:1745:6
CreateOptsFile at postmaster.c:4166:3
(inlined by) PostmasterMain at postmaster.c:1301:7
check_root at main.c:448:3
(inlined by) main at main.c:195:3
...
Best regards,
Alexander
view thread (8+ messages) latest in thread
Message-ID: <7ac90032-cf60-4415-a7f9-cf512196db35@gmail.com>
Permalink: ../7ac90032-cf60-4415-a7f9-cf512196db35@gmail.com/
Also on: postgresql.org/message-id/7ac90032-cf60-4415-a7f9-cf512196db35@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: exclusion@gmail.com, ayushtiwari.slg01@gmail.com, o.alexandre.felipe@gmail.com
Subject: Re: BUG #19687: ALTER SEQUENCE provokes error XX001 could not read blocks
In-Reply-To: <7ac90032-cf60-4415-a7f9-cf512196db35@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox