| 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.
>
| 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 |