Thread

1. postgres access violation in pg_detoast_datum

   Arnd Empting <arnd.empting@koerber.com> — 2025-10-21T06:49:13Z

   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
   

2. Re: postgres access violation in pg_detoast_datum

   David Rowley <dgrowleyml@gmail.com> — 2025-10-21T07:05:09Z

   On Tue, 21 Oct 2025 at 19:51, Arnd Empting <arnd.empting@koerber.com> wrote:
   > Versions:
   > Postgres: postgres (PostgreSQL) 17.2
   
   Please upgrade to the latest minor version of v17 (17.6) and report
   back if you're having issues.
   
   David
   
   
   
   

3. Re: postgres access violation in pg_detoast_datum

   Álvaro Herrera <alvherre@kurilemu.de> — 2025-10-21T08:21:24Z

   On 2025-Oct-21, Arnd Empting wrote:
   
   > Crashing postgres executable due to access violation in pg_detoast_datum
   > 
   > ExceptionAddress: 00007ff6ef1e86f0 (postgres!pg_detoast_datum)
   > ExceptionCode: c0000005 (Access violation)
   
   You may well have corrupt data in your tables.  I suspect some parts of
   the detoasting code are still not robust enough against that and could
   cause server crashes.
   
   It would be good, at some point, to look into fuzzing the toast code
   with random bytes so that we can report errors rather than crashing ...
   
   -- 
   Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
   "Uno puede defenderse de los ataques; contra los elogios se esta indefenso"