postgres access violation in pg_detoast_datum

From: Arnd Empting <arnd(dot)empting(at)koerber(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: postgres access violation in pg_detoast_datum
Date: 2025-10-21 06:49:13
Message-ID: AS8PR04MB773582904779B1E30D3CF0C388F2A@AS8PR04MB7735.eurprd04.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Versions:
Postgres: postgres (PostgreSQL) 17.2
OS: Microsoft Windows [Version 10.0.19044.5854]

Problem:
Crashing postgres executable due to access violation in pg_detoast_datum

ExceptionAddress: 00007ff6ef1e86f0 (postgres!pg_detoast_datum)
ExceptionCode: c0000005 (Access violation)

Circumstances:
Happens about once or twice a week.
We activated the windows mini-dump mechanic after seeing sporadic recovery cases in the logs.

Anything special we do when using the db:
Beside other stuff we write a lot of tif-pictures in the database.

Attachments:
I attach the winDbg analyze results of the mini-dump we had.
(several postgres processes crashed at the same time - but the analyze results looked mostly the same).

We run a script every 5 minutes that reports a few of the pg_stats.. tables into a log file.
I attach the last of those statistics before the crash if you need an idea about the io or wal use.

If you need the dump file - contact me. We will try to use a newer postgresql version now - but as I found no actual commits concerning pg_detoast_datum I am not very hopeful.

Cheers
Arnd Empting

K?rber Supply Chain Logistics GmbH

Lilienthalstr. 16/18, 78467 Konstanz, Germany
T + 49 (0) 7531 9200222 ? info-parcel(dot)sc(dot)pl(at)koerber(dot)com ? www.koerber-supplychain.com<https://www.koerber-supplychain.com>

Vorsitzende des Aufsichtsrats / Chairwoman of the Supervisory Board: Dr. Helena Garriga Rubio
Gesch?ftsf?hrung / Management Board: Stefan Bitzi, Oliver Aberle
Sitz der Gesellschaft / Registered office: Lilienthalstr. 16/18, 78467 Konstanz, Germany
Registergericht / Court of registration: Amtsgericht Freiburg i. Br., HRB 728548, VAT-No: DE813868425, WEEE-Reg.-No. DE 74742921

Attachment Content-Type Size
windbg_dump_analyze.txt text/plain 8.0 KB
pg_stats.txt text/plain 17.1 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2025-10-21 07:05:09 Re: postgres access violation in pg_detoast_datum
Previous Message David Rowley 2025-10-21 05:20:31 Re: Segfault in RI UPDATE CASCADE on partitioned tables with LIKE+ATTACH child (attnum drift)