postgres access violation in pg_detoast_datum - Mailing list 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