Re: PG17.6 wal apply bug (SIGSEGV)

From: "badfilez(at)gmail(dot)com" <badfilez(at)gmail(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: PG17.6 wal apply bug (SIGSEGV)
Date: 2025-10-22 06:19:37
Message-ID: 630d3d31-40b2-40c2-b1bf-c857ba88322d@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

Thank you,
there still are 2 broken indexes in master DB,
one of them exactly matches the said relation 151181595.

still,
is it proper wal apply procedure, to segfault in such a case?

On 20/10/2025 20:18, Peter Geoghegan wrote:
> On Mon, Oct 20, 2025 at 1:07 PM badfilez(at)gmail(dot)com <badfilez(at)gmail(dot)com> wrote:
>> Program terminated with signal SIGSEGV, Segmentation fault.
>> #0 0x000000000057eff2 in _bt_restore_page (page=0x7f6f48fd1000 "", from=0x7f6fe2eccd80 "", len=<optimized out>) at nbtxlog.c:63
>> 63 itemsz = MAXALIGN(itemsz);
>> (gdb) bt full
> "itemsz = 0" suggests that the index was already corrupt, before the
> WAL record is applied.
>
> I suggest that you use contrib/amcheck (or the pg_amcheck frontend
> program) to ascertain the extent of any index corruption on this
> database.
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Emmanuel Touzery 2025-10-22 07:33:43 ERROR: XX000: could not find memoization table entry (reproducible)
Previous Message Jacob Champion 2025-10-21 20:44:52 Re: TLS verification to intermediate trust anchor with psql