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