Re: TRAP: failed Assert("offsets[i] > offsets[i - 1]"), File: "tidstore.c"
Masahiko Sawada <sawada.mshk@gmail.com>
From: Masahiko Sawada <sawada.mshk@gmail.com>
To: Andrei Lepikhov <lepihov@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2026-04-15T20:50:01Z
Lists: pgsql-bugs
On Wed, Apr 15, 2026 at 5:48 AM Andrei Lepikhov <lepihov@gmail.com> wrote: > > Hi, > > While experimenting with query plans, I periodically see test_tidstore > fail on the assertion in TidStoreSetBlockOffsets(). > > The cause is that the harness function do_set_block_offsets() forwards > the SQL array straight to TidStoreSetBlockOffsets(), which has an > explicit contract: > > "The offset numbers 'offsets' must be sorted in ascending order." > > array_agg() without ORDER BY gives no such guarantee, and plan shapes > that reshuffle the input can deliver the offsets out of order and trip > the Assert. > > The issue is minor and doesn't expose any underlying bug, but it is > still worth fixing: it removes a source of flaky test runs and makes > life easier for extension developers who reuse the same pattern. > > Patch attached. Thank you for the report. Could you provide the reproducer of the assertion failure? IIRC there have not been such reports on the community so far and the test should be included in the patch anyway. Regards, -- Masahiko Sawada Amazon Web Services: https://aws.amazon.com
Commits
-
test_tidstore: Stabilize regression tests by sorting offsets.
- 0b3f72f8816b 17.10 landed
- cfbfdb963a42 18.4 landed
- a424e31b16ba 19 (unreleased) landed