postgres access violation in pg_detoast_datum

Arnd Empting <arnd.empting@koerber.com>

From: Arnd Empting <arnd.empting@koerber.com>
To: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-10-21T06:49:13Z
Lists: pgsql-bugs

Attachments

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.sc.pl@koerber.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