Обсуждение: postgres access violation in pg_detoast_datum
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
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
Вложения
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
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"