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
- windbg_dump_analyze.txt (text/plain)
- pg_stats.txt (text/plain)
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