pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres access violation in pg_detoast_datum
3+ messages / 3 participants
[nested] [flat]
* postgres access violation in pg_detoast_datum
@ 2025-10-21 06:49 Arnd Empting <arnd.empting@koerber.com>
2025-10-21 07:05 ` Re: postgres access violation in pg_detoast_datum David Rowley <dgrowleyml@gmail.com>
2025-10-21 08:21 ` Re: postgres access violation in pg_detoast_datum Álvaro Herrera <alvherre@kurilemu.de>
0 siblings, 2 replies; 3+ messages in thread
From: Arnd Empting @ 2025-10-21 06:49 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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
Loading Dump File [D:\logs\PIDS\crash_dumps\postgres.exe.14104.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available
************* Path validation summary **************
Response Time (ms) Location
Deferred srv*
Symbol search path is: srv*
Executable search path is:
Windows 10 Version 19044 MP (18 procs) Free x64
Product: WinNt, suite: SingleUserTS
Edition build lab: 19041.1.amd64fre.vb_release.191206-1406
Debug session time: Mon Oct 20 23:55:42.000 2025 (UTC + 2:00)
System Uptime: not available
Process Uptime: 0 days 4:06:39.000
......................................
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr
(3718.3364): Access violation - code c0000005 (first/second chance not available)
For analysis of this file, run !analyze -v
ntdll!NtWaitForMultipleObjects+0x14:
00007fff`9d2ae044 c3 ret
0:000> !analyze -v
......................................
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************
KEY_VALUES_STRING: 1
Key : AV.Type
Value: Read
Key : Analysis.CPU.mSec
Value: 562
Key : Analysis.Elapsed.mSec
Value: 5595
Key : Analysis.IO.Other.Mb
Value: 0
Key : Analysis.IO.Read.Mb
Value: 1
Key : Analysis.IO.Write.Mb
Value: 0
Key : Analysis.Init.CPU.mSec
Value: 1125
Key : Analysis.Init.Elapsed.mSec
Value: 23653
Key : Analysis.Memory.CommitPeak.Mb
Value: 102
Key : Analysis.Version.DbgEng
Value: 10.0.29457.1000
Key : Analysis.Version.Description
Value: 10.2506.23.01 amd64fre
Key : Analysis.Version.Ext
Value: 1.2506.23.1
Key : Failure.Bucket
Value: INVALID_POINTER_READ_c0000005_postgres.exe!pg_detoast_datum
Key : Failure.Exception.Code
Value: 0xc0000005
Key : Failure.Exception.IP.Address
Value: 0x7ff6ef1e86f0
Key : Failure.Exception.IP.Module
Value: postgres
Key : Failure.Exception.IP.Offset
Value: 0x5086f0
Key : Failure.Hash
Value: {f7b3946c-d59b-1a89-0c47-4093df8b5c9b}
Key : Failure.ProblemClass.Primary
Value: INVALID_POINTER_READ
Key : Timeline.Process.Start.DeltaSec
Value: 14799
Key : WER.OS.Branch
Value: vb_release
Key : WER.OS.Version
Value: 10.0.19041.1
Key : WER.Process.Version
Value: 17.0.2.0
FILE_IN_CAB: postgres.exe.14104.dmp
NTGLOBALFLAG: 0
APPLICATION_VERIFIER_FLAGS: 0
CONTEXT: (.ecxr)
rax=ffffffffffffffff rbx=ffffffffffffffff rcx=ffffffffffffffff
rdx=ffffffffffffffff rsi=000002210e046650 rdi=000002210dc255c0
rip=00007ff6ef1e86f0 rsp=000000d34ebfebf8 rbp=000000d34ebfec80
r8=000002210dc255c0 r9=00000000ffffffff r10=0000000000000000
r11=000002210e047074 r12=00000000ffffffff r13=000002210dc24db8
r14=ffffffffffffffff r15=0000000000000018
iopl=0 nv up ei pl nz na po nc
cs=0033 ss=002b ds=002b es=002b fs=0053 gs=002b efl=00010206
postgres!pg_detoast_datum:
00007ff6`ef1e86f0 f60103 test byte ptr [rcx],3 ds:ffffffff`ffffffff=??
Resetting default scope
EXCEPTION_RECORD: (.exr -1)
ExceptionAddress: 00007ff6ef1e86f0 (postgres!pg_detoast_datum)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 0000000000000000
Parameter[1]: ffffffffffffffff
Attempt to read from address ffffffffffffffff
PROCESS_NAME: postgres.exe
READ_ADDRESS: ffffffffffffffff
ERROR_CODE: (NTSTATUS) 0xc0000005 - Die Anweisung in 0x%p verwies auf Arbeitsspeicher bei 0x%p. Der Vorgang %s konnte im Arbeitsspeicher nicht durchgef hrt werden.
EXCEPTION_CODE_STR: c0000005
EXCEPTION_PARAMETER1: 0000000000000000
EXCEPTION_PARAMETER2: ffffffffffffffff
STACK_TEXT:
000000d3`4ebfebf8 00007ff6`ef138655 : 00000000`00000018 ffffffff`ffffffff 00000221`0dc24db8 00000000`ffffffff : postgres!pg_detoast_datum
000000d3`4ebfec00 00007ff6`ef218f23 : 00000000`00000019 000000d3`4ebfec80 00000221`0e046650 00000221`0dc255c0 : postgres!numeric_fac+0x195
000000d3`4ebfec30 00007ff6`ef218b49 : 00000221`0dce8400 00007ff6`eeeb7d00 00000221`0dd1c040 00000221`0dce8528 : postgres!tuplesort_used_bound+0xd03
000000d3`4ebfecc0 00007ff6`ef213f5c : 00000221`0dd1c088 00000221`0dd1c0d0 00000000`00000001 00000000`00000000 : postgres!tuplesort_used_bound+0x929
000000d3`4ebfed00 00007ff6`ef217692 : 00000221`0e047658 00000000`00000007 00000221`0dc24db8 00000221`0dc24db8 : postgres!PrepareSortSupportFromOrderingOp+0x212c
000000d3`4ebfed80 00007ff6`eeedf1e6 : 00000221`0dce8420 00000221`0dce8420 00000221`0dce8218 00000221`0dc24db8 : postgres!tuplesort_performsort+0x1d2
000000d3`4ebfede0 00007ff6`eeeaf728 : 00000221`0dce8110 00000221`0dce8110 00000000`00000000 00000221`0dc30e18 : postgres!ExecReScanSort+0x276
000000d3`4ebfee50 00007ff6`eeebe847 : 00000221`0dc318c8 00000221`0dc318c8 00000221`0dce8110 00000221`0db21e48 : postgres!ExecScan+0x198
000000d3`4ebfeeb0 00007ff6`eeedf1c6 : 00000221`0dc318c8 00000221`0dc316c0 00000221`0dc318c8 00000221`0dc316c0 : postgres!hash_agg_set_limits+0x1e27
000000d3`4ebfeee0 00007ff6`eeee4056 : 00000221`0dc314b8 00000221`0d96df80 00000221`0dc31378 00000221`0dded180 : postgres!ExecReScanSort+0x256
000000d3`4ebfef50 00007ff6`eeedf1c6 : 00000221`0dc31270 00000221`0dc314b8 00000221`0d96df80 00000221`0dc314b8 : postgres!ExecReScanUnique+0x96
000000d3`4ebfefa0 00007ff6`eeea740a : 00000000`00000000 00000221`0dc314b8 00000221`0dbc9220 00000221`0dc30e18 : postgres!ExecReScanSort+0x256
000000d3`4ebff010 00007fff`87fd36d1 : 00000221`00000001 00007fff`00000301 00000000`00000000 00000000`00000000 : postgres!standard_ExecutorRun+0x14a
000000d3`4ebff080 00007ff6`ef07ace3 : 00000221`0d898198 00000221`0dbc9220 00000000`000003ff 00000000`00002001 : pg_stat_statements!pg_stat_statements_reset_1_7+0x2d1
000000d3`4ebff200 00007ff6`ef07a608 : 000000d3`4ebff340 00000000`00000000 00000221`0b313560 00000000`00000000 : postgres!PortalRunFetch+0x593
000000d3`4ebff240 00007ff6`ef077240 : 00000000`00000003 00000221`0d8d4a88 00007ff6`eef04778 0000027f`00001fb1 : postgres!PortalRun+0x228
000000d3`4ebff420 00007ff6`ef07407c : 00000000`00000045 000000d3`4ebff630 00000221`0d8d4a89 00000221`5a030000 : postgres!die+0x1450
000000d3`4ebff530 00007ff6`eefc85d3 : 00000000`00000018 00007ff6`ef5e1d10 00000000`00000018 00000221`00000000 : postgres!PostgresMain+0x72c
000000d3`4ebff6f0 00007ff6`eef0a087 : 00000000`00000000 00000000`00000003 00000000`00000004 00000221`0b296b88 : postgres!SubPostmasterMain+0x1a3
000000d3`4ebff730 00007ff6`ef2e7124 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : postgres!main+0x4f7
000000d3`4ebff920 00007fff`9cf77374 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : postgres!record_config_file_error+0x81c4
000000d3`4ebff960 00007fff`9d25cc91 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x14
000000d3`4ebff990 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x21
STACK_COMMAND: ~0s; .ecxr ; kb
SYMBOL_NAME: postgres!pg_detoast_datum+d34ebfebf0
MODULE_NAME: postgres
IMAGE_NAME: postgres.exe
FAILURE_BUCKET_ID: INVALID_POINTER_READ_c0000005_postgres.exe!pg_detoast_datum
OS_VERSION: 10.0.19041.1
BUILDLAB_STR: vb_release
OSPLATFORM_TYPE: x64
OSNAME: Windows 10
IMAGE_VERSION: 17.0.2.0
FAILURE_ID_HASH: {f7b3946c-d59b-1a89-0c47-4093df8b5c9b}
Followup: MachineOwner
==== 2025-10-20 23:52:00 ====
--- pg_stat_database ---
datid | datname | numbackends | xact_commit | xact_rollback | blks_read | blks_hit | tup_returned | tup_fetched | tup_inserted | tup_updated | tup_deleted | conflicts | temp_files | temp_bytes | deadlocks | checksum_failures | checksum_last_failure | blk_read_time | blk_write_time | session_time | active_time | idle_in_transaction_time | sessions | sessions_abandoned | sessions_fatal | sessions_killed | stats_reset
-------+-----------+-------------+-------------+---------------+-----------+------------+--------------+-------------+--------------+-------------+-------------+-----------+------------+------------+-----------+-------------------+-----------------------+---------------+----------------+----------------+--------------+--------------------------+----------+--------------------+----------------+-----------------+-------------
0 | | 0 | 0 | 0 | 1245 | 735793 | 160396 | 103370 | 25151 | 0 | 25137 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
5 | postgres | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | template1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
4 | template0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
16384 | orca | 92 | 22568989 | 20 | 6342820 | 1105892654 | 16580086407 | 267757868 | 125844198 | 5961298 | 39645951 | 0 | 547 | 3862805148 | 0 | | | 320286.719 | 365583.61 | 3299478182.179 | 25788508.026 | 54463213.913 | 4557 | 0 | 0 | 0 |
(5 rows)
--- pg_stat_bgwriter ---
buffers_clean | maxwritten_clean | buffers_alloc | stats_reset
---------------+------------------+---------------+-------------------------------
1856403 | 16955 | 18998130 | 2025-10-20 11:44:03.551522+02
(1 row)
--- pg_stat_wal ---
wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write | wal_sync | wal_write_time | wal_sync_time | stats_reset
-------------+---------+--------------+------------------+-----------+----------+----------------+---------------+-------------------------------
351566098 | 9289056 | 284392639592 | 0 | 7666357 | 0 | 0 | 0 | 2025-10-20 11:44:03.551522+02
(1 row)
--- pg_stat_activity (active sessions) ---
datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type
-------+---------+-------+------------+----------+----------+------------------------+---------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+------------+---------------------+-------------+--------------+----------------------+-------------------------------------------------------+----------------
16384 | orca | 6736 | | 16492 | OU | PostgreSQL JDBC Driver | 172.30.24.213 | | 53509 | 2025-10-20 17:25:43.932597+02 | 2025-10-20 23:52:01.742415+02 | 2025-10-20 23:52:01.742447+02 | 2025-10-20 23:52:01.742497+02 | Client | ClientRead | idle in transaction | | 135234083 | -8102777723535849968 | SELECT * FROM SM_Shifts WHERE STOP_TIME IS NULL | client backend
16384 | orca | 20956 | | 10 | postgres | psql | ::1 | | 55590 | 2025-10-20 23:52:01.729614+02 | 2025-10-20 23:52:01.740532+02 | 2025-10-20 23:52:01.740532+02 | 2025-10-20 23:52:01.740533+02 | | | active | | 135234083 | 4112192878702547010 | SELECT * FROM pg_stat_activity WHERE state != 'idle'; | client backend
(2 rows)
--- pg_stat_activity (idle in transaction > 10 min) ---
pid | usename | application_name | client_addr | xact_start | query
-----+---------+------------------+-------------+------------+-------
(0 rows)
--- pg_stat_io ---
backend_type | object | context | reads | read_time | writes | write_time | writebacks | writeback_time | extends | extend_time | op_bytes | hits | evictions | reuses | fsyncs | fsync_time | stats_reset
---------------------+---------------+-----------+---------+--------------------+----------+------------+------------+----------------+----------+-------------+----------+------------+-----------+---------+--------+--------------------+-------------------------------
client backend | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
client backend | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 13741 | 1893.489 | 8192 | 0 | 8342 | 0 | | | 2025-10-20 11:44:03.551522+02
client backend | relation | normal | 312891 | 12218.815 | 0 | 0 | 0 | 0 | 18456704 | 344816.841 | 8192 | 1008150788 | 16579102 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
client backend | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
client backend | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
autovacuum launcher | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
autovacuum launcher | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
autovacuum worker | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
autovacuum worker | relation | normal | 21367 | 2666.742 | 0 | 0 | 0 | 0 | 30684 | 5075.861 | 8192 | 44816126 | 23713 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
autovacuum worker | relation | vacuum | 6009763 | 307748.607 | 2224059 | 22840.662 | 0 | 0 | 0 | 0 | 8192 | 47115592 | 138358 | 5855606 | | | 2025-10-20 11:44:03.551522+02
background worker | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background worker | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background worker | relation | normal | 5 | 2.17 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 6567712 | 5 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
background worker | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background worker | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
walsender | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
walsender | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
walsender | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
walsender | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
walsender | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
slotsync worker | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
standalone backend | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
standalone backend | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
standalone backend | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
standalone backend | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background writer | relation | normal | | | 1856395 | 20187.566 | 0 | 0 | | | 8192 | | | | 0 | 0 | 2025-10-20 11:44:03.551522+02
checkpointer | relation | normal | | | 38794873 | 337967.694 | 0 | 0 | | | 8192 | | | | 94979 | 108188.56300000001 | 2025-10-20 11:44:03.551522+02
startup | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
startup | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
startup | relation | normal | 77 | 2.4210000000000003 | 0 | 0 | 0 | 0 | 178 | 6.37 | 8192 | 110446 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
startup | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
(35 rows)
--- pg_stat_replication ---
pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | backend_xmin | state | sent_lsn | write_lsn | flush_lsn | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state | reply_time
-----+----------+---------+------------------+-------------+-----------------+-------------+---------------+--------------+-------+----------+-----------+-----------+------------+-----------+-----------+------------+---------------+------------+------------
(0 rows)
--- pg_stat_checkpointer ---
num_timed | num_requested | restartpoints_timed | restartpoints_req | restartpoints_done | write_time | sync_time | buffers_written | stats_reset
-----------+---------------+---------------------+-------------------+--------------------+------------+-----------+-----------------+-------------------------------
41 | 50 | 0 | 0 | 0 | 34338197 | 112725 | 38799792 | 2025-10-20 11:44:03.551522+02
(1 row)
--- pg_stat_archiver ---
archived_count | last_archived_wal | last_archived_time | failed_count | last_failed_wal | last_failed_time | stats_reset
----------------+-------------------+--------------------+--------------+-----------------+------------------+-------------------------------
0 | | | 0 | | | 2025-10-20 11:44:03.551522+02
(1 row)
--- PostgreSQL RAM Monitoring ---
PostgreSQL RAM-Verbrauch: 38994.93 MB
System RAM: 65535.04 MB
Warnschwelle (90%): 51608.73 MB
PostgreSQL RAM-Verbrauch im grünen Bereich.
Attachments:
[text/plain] windbg_dump_analyze.txt (8.0K, ../../AS8PR04MB773582904779B1E30D3CF0C388F2A@AS8PR04MB7735.eurprd04.prod.outlook.com/3-windbg_dump_analyze.txt)
download | inline:
Loading Dump File [D:\logs\PIDS\crash_dumps\postgres.exe.14104.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available
************* Path validation summary **************
Response Time (ms) Location
Deferred srv*
Symbol search path is: srv*
Executable search path is:
Windows 10 Version 19044 MP (18 procs) Free x64
Product: WinNt, suite: SingleUserTS
Edition build lab: 19041.1.amd64fre.vb_release.191206-1406
Debug session time: Mon Oct 20 23:55:42.000 2025 (UTC + 2:00)
System Uptime: not available
Process Uptime: 0 days 4:06:39.000
......................................
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr
(3718.3364): Access violation - code c0000005 (first/second chance not available)
For analysis of this file, run !analyze -v
ntdll!NtWaitForMultipleObjects+0x14:
00007fff`9d2ae044 c3 ret
0:000> !analyze -v
......................................
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************
KEY_VALUES_STRING: 1
Key : AV.Type
Value: Read
Key : Analysis.CPU.mSec
Value: 562
Key : Analysis.Elapsed.mSec
Value: 5595
Key : Analysis.IO.Other.Mb
Value: 0
Key : Analysis.IO.Read.Mb
Value: 1
Key : Analysis.IO.Write.Mb
Value: 0
Key : Analysis.Init.CPU.mSec
Value: 1125
Key : Analysis.Init.Elapsed.mSec
Value: 23653
Key : Analysis.Memory.CommitPeak.Mb
Value: 102
Key : Analysis.Version.DbgEng
Value: 10.0.29457.1000
Key : Analysis.Version.Description
Value: 10.2506.23.01 amd64fre
Key : Analysis.Version.Ext
Value: 1.2506.23.1
Key : Failure.Bucket
Value: INVALID_POINTER_READ_c0000005_postgres.exe!pg_detoast_datum
Key : Failure.Exception.Code
Value: 0xc0000005
Key : Failure.Exception.IP.Address
Value: 0x7ff6ef1e86f0
Key : Failure.Exception.IP.Module
Value: postgres
Key : Failure.Exception.IP.Offset
Value: 0x5086f0
Key : Failure.Hash
Value: {f7b3946c-d59b-1a89-0c47-4093df8b5c9b}
Key : Failure.ProblemClass.Primary
Value: INVALID_POINTER_READ
Key : Timeline.Process.Start.DeltaSec
Value: 14799
Key : WER.OS.Branch
Value: vb_release
Key : WER.OS.Version
Value: 10.0.19041.1
Key : WER.Process.Version
Value: 17.0.2.0
FILE_IN_CAB: postgres.exe.14104.dmp
NTGLOBALFLAG: 0
APPLICATION_VERIFIER_FLAGS: 0
CONTEXT: (.ecxr)
rax=ffffffffffffffff rbx=ffffffffffffffff rcx=ffffffffffffffff
rdx=ffffffffffffffff rsi=000002210e046650 rdi=000002210dc255c0
rip=00007ff6ef1e86f0 rsp=000000d34ebfebf8 rbp=000000d34ebfec80
r8=000002210dc255c0 r9=00000000ffffffff r10=0000000000000000
r11=000002210e047074 r12=00000000ffffffff r13=000002210dc24db8
r14=ffffffffffffffff r15=0000000000000018
iopl=0 nv up ei pl nz na po nc
cs=0033 ss=002b ds=002b es=002b fs=0053 gs=002b efl=00010206
postgres!pg_detoast_datum:
00007ff6`ef1e86f0 f60103 test byte ptr [rcx],3 ds:ffffffff`ffffffff=??
Resetting default scope
EXCEPTION_RECORD: (.exr -1)
ExceptionAddress: 00007ff6ef1e86f0 (postgres!pg_detoast_datum)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 0000000000000000
Parameter[1]: ffffffffffffffff
Attempt to read from address ffffffffffffffff
PROCESS_NAME: postgres.exe
READ_ADDRESS: ffffffffffffffff
ERROR_CODE: (NTSTATUS) 0xc0000005 - Die Anweisung in 0x%p verwies auf Arbeitsspeicher bei 0x%p. Der Vorgang %s konnte im Arbeitsspeicher nicht durchgef hrt werden.
EXCEPTION_CODE_STR: c0000005
EXCEPTION_PARAMETER1: 0000000000000000
EXCEPTION_PARAMETER2: ffffffffffffffff
STACK_TEXT:
000000d3`4ebfebf8 00007ff6`ef138655 : 00000000`00000018 ffffffff`ffffffff 00000221`0dc24db8 00000000`ffffffff : postgres!pg_detoast_datum
000000d3`4ebfec00 00007ff6`ef218f23 : 00000000`00000019 000000d3`4ebfec80 00000221`0e046650 00000221`0dc255c0 : postgres!numeric_fac+0x195
000000d3`4ebfec30 00007ff6`ef218b49 : 00000221`0dce8400 00007ff6`eeeb7d00 00000221`0dd1c040 00000221`0dce8528 : postgres!tuplesort_used_bound+0xd03
000000d3`4ebfecc0 00007ff6`ef213f5c : 00000221`0dd1c088 00000221`0dd1c0d0 00000000`00000001 00000000`00000000 : postgres!tuplesort_used_bound+0x929
000000d3`4ebfed00 00007ff6`ef217692 : 00000221`0e047658 00000000`00000007 00000221`0dc24db8 00000221`0dc24db8 : postgres!PrepareSortSupportFromOrderingOp+0x212c
000000d3`4ebfed80 00007ff6`eeedf1e6 : 00000221`0dce8420 00000221`0dce8420 00000221`0dce8218 00000221`0dc24db8 : postgres!tuplesort_performsort+0x1d2
000000d3`4ebfede0 00007ff6`eeeaf728 : 00000221`0dce8110 00000221`0dce8110 00000000`00000000 00000221`0dc30e18 : postgres!ExecReScanSort+0x276
000000d3`4ebfee50 00007ff6`eeebe847 : 00000221`0dc318c8 00000221`0dc318c8 00000221`0dce8110 00000221`0db21e48 : postgres!ExecScan+0x198
000000d3`4ebfeeb0 00007ff6`eeedf1c6 : 00000221`0dc318c8 00000221`0dc316c0 00000221`0dc318c8 00000221`0dc316c0 : postgres!hash_agg_set_limits+0x1e27
000000d3`4ebfeee0 00007ff6`eeee4056 : 00000221`0dc314b8 00000221`0d96df80 00000221`0dc31378 00000221`0dded180 : postgres!ExecReScanSort+0x256
000000d3`4ebfef50 00007ff6`eeedf1c6 : 00000221`0dc31270 00000221`0dc314b8 00000221`0d96df80 00000221`0dc314b8 : postgres!ExecReScanUnique+0x96
000000d3`4ebfefa0 00007ff6`eeea740a : 00000000`00000000 00000221`0dc314b8 00000221`0dbc9220 00000221`0dc30e18 : postgres!ExecReScanSort+0x256
000000d3`4ebff010 00007fff`87fd36d1 : 00000221`00000001 00007fff`00000301 00000000`00000000 00000000`00000000 : postgres!standard_ExecutorRun+0x14a
000000d3`4ebff080 00007ff6`ef07ace3 : 00000221`0d898198 00000221`0dbc9220 00000000`000003ff 00000000`00002001 : pg_stat_statements!pg_stat_statements_reset_1_7+0x2d1
000000d3`4ebff200 00007ff6`ef07a608 : 000000d3`4ebff340 00000000`00000000 00000221`0b313560 00000000`00000000 : postgres!PortalRunFetch+0x593
000000d3`4ebff240 00007ff6`ef077240 : 00000000`00000003 00000221`0d8d4a88 00007ff6`eef04778 0000027f`00001fb1 : postgres!PortalRun+0x228
000000d3`4ebff420 00007ff6`ef07407c : 00000000`00000045 000000d3`4ebff630 00000221`0d8d4a89 00000221`5a030000 : postgres!die+0x1450
000000d3`4ebff530 00007ff6`eefc85d3 : 00000000`00000018 00007ff6`ef5e1d10 00000000`00000018 00000221`00000000 : postgres!PostgresMain+0x72c
000000d3`4ebff6f0 00007ff6`eef0a087 : 00000000`00000000 00000000`00000003 00000000`00000004 00000221`0b296b88 : postgres!SubPostmasterMain+0x1a3
000000d3`4ebff730 00007ff6`ef2e7124 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : postgres!main+0x4f7
000000d3`4ebff920 00007fff`9cf77374 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : postgres!record_config_file_error+0x81c4
000000d3`4ebff960 00007fff`9d25cc91 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x14
000000d3`4ebff990 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x21
STACK_COMMAND: ~0s; .ecxr ; kb
SYMBOL_NAME: postgres!pg_detoast_datum+d34ebfebf0
MODULE_NAME: postgres
IMAGE_NAME: postgres.exe
FAILURE_BUCKET_ID: INVALID_POINTER_READ_c0000005_postgres.exe!pg_detoast_datum
OS_VERSION: 10.0.19041.1
BUILDLAB_STR: vb_release
OSPLATFORM_TYPE: x64
OSNAME: Windows 10
IMAGE_VERSION: 17.0.2.0
FAILURE_ID_HASH: {f7b3946c-d59b-1a89-0c47-4093df8b5c9b}
Followup: MachineOwner
[text/plain] pg_stats.txt (17.1K, ../../AS8PR04MB773582904779B1E30D3CF0C388F2A@AS8PR04MB7735.eurprd04.prod.outlook.com/4-pg_stats.txt)
download | inline:
==== 2025-10-20 23:52:00 ====
--- pg_stat_database ---
datid | datname | numbackends | xact_commit | xact_rollback | blks_read | blks_hit | tup_returned | tup_fetched | tup_inserted | tup_updated | tup_deleted | conflicts | temp_files | temp_bytes | deadlocks | checksum_failures | checksum_last_failure | blk_read_time | blk_write_time | session_time | active_time | idle_in_transaction_time | sessions | sessions_abandoned | sessions_fatal | sessions_killed | stats_reset
-------+-----------+-------------+-------------+---------------+-----------+------------+--------------+-------------+--------------+-------------+-------------+-----------+------------+------------+-----------+-------------------+-----------------------+---------------+----------------+----------------+--------------+--------------------------+----------+--------------------+----------------+-----------------+-------------
0 | | 0 | 0 | 0 | 1245 | 735793 | 160396 | 103370 | 25151 | 0 | 25137 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
5 | postgres | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | template1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
4 | template0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
16384 | orca | 92 | 22568989 | 20 | 6342820 | 1105892654 | 16580086407 | 267757868 | 125844198 | 5961298 | 39645951 | 0 | 547 | 3862805148 | 0 | | | 320286.719 | 365583.61 | 3299478182.179 | 25788508.026 | 54463213.913 | 4557 | 0 | 0 | 0 |
(5 rows)
--- pg_stat_bgwriter ---
buffers_clean | maxwritten_clean | buffers_alloc | stats_reset
---------------+------------------+---------------+-------------------------------
1856403 | 16955 | 18998130 | 2025-10-20 11:44:03.551522+02
(1 row)
--- pg_stat_wal ---
wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write | wal_sync | wal_write_time | wal_sync_time | stats_reset
-------------+---------+--------------+------------------+-----------+----------+----------------+---------------+-------------------------------
351566098 | 9289056 | 284392639592 | 0 | 7666357 | 0 | 0 | 0 | 2025-10-20 11:44:03.551522+02
(1 row)
--- pg_stat_activity (active sessions) ---
datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type
-------+---------+-------+------------+----------+----------+------------------------+---------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+------------+---------------------+-------------+--------------+----------------------+-------------------------------------------------------+----------------
16384 | orca | 6736 | | 16492 | OU | PostgreSQL JDBC Driver | 172.30.24.213 | | 53509 | 2025-10-20 17:25:43.932597+02 | 2025-10-20 23:52:01.742415+02 | 2025-10-20 23:52:01.742447+02 | 2025-10-20 23:52:01.742497+02 | Client | ClientRead | idle in transaction | | 135234083 | -8102777723535849968 | SELECT * FROM SM_Shifts WHERE STOP_TIME IS NULL | client backend
16384 | orca | 20956 | | 10 | postgres | psql | ::1 | | 55590 | 2025-10-20 23:52:01.729614+02 | 2025-10-20 23:52:01.740532+02 | 2025-10-20 23:52:01.740532+02 | 2025-10-20 23:52:01.740533+02 | | | active | | 135234083 | 4112192878702547010 | SELECT * FROM pg_stat_activity WHERE state != 'idle'; | client backend
(2 rows)
--- pg_stat_activity (idle in transaction > 10 min) ---
pid | usename | application_name | client_addr | xact_start | query
-----+---------+------------------+-------------+------------+-------
(0 rows)
--- pg_stat_io ---
backend_type | object | context | reads | read_time | writes | write_time | writebacks | writeback_time | extends | extend_time | op_bytes | hits | evictions | reuses | fsyncs | fsync_time | stats_reset
---------------------+---------------+-----------+---------+--------------------+----------+------------+------------+----------------+----------+-------------+----------+------------+-----------+---------+--------+--------------------+-------------------------------
client backend | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
client backend | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 13741 | 1893.489 | 8192 | 0 | 8342 | 0 | | | 2025-10-20 11:44:03.551522+02
client backend | relation | normal | 312891 | 12218.815 | 0 | 0 | 0 | 0 | 18456704 | 344816.841 | 8192 | 1008150788 | 16579102 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
client backend | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
client backend | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
autovacuum launcher | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
autovacuum launcher | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
autovacuum worker | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
autovacuum worker | relation | normal | 21367 | 2666.742 | 0 | 0 | 0 | 0 | 30684 | 5075.861 | 8192 | 44816126 | 23713 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
autovacuum worker | relation | vacuum | 6009763 | 307748.607 | 2224059 | 22840.662 | 0 | 0 | 0 | 0 | 8192 | 47115592 | 138358 | 5855606 | | | 2025-10-20 11:44:03.551522+02
background worker | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background worker | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background worker | relation | normal | 5 | 2.17 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 6567712 | 5 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
background worker | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background worker | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
walsender | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
walsender | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
walsender | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
walsender | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
walsender | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
slotsync worker | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
slotsync worker | temp relation | normal | 0 | 0 | 0 | 0 | | | 0 | 0 | 8192 | 0 | 0 | | | | 2025-10-20 11:44:03.551522+02
standalone backend | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
standalone backend | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
standalone backend | relation | normal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
standalone backend | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
background writer | relation | normal | | | 1856395 | 20187.566 | 0 | 0 | | | 8192 | | | | 0 | 0 | 2025-10-20 11:44:03.551522+02
checkpointer | relation | normal | | | 38794873 | 337967.694 | 0 | 0 | | | 8192 | | | | 94979 | 108188.56300000001 | 2025-10-20 11:44:03.551522+02
startup | relation | bulkread | 0 | 0 | 0 | 0 | 0 | 0 | | | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
startup | relation | bulkwrite | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
startup | relation | normal | 77 | 2.4210000000000003 | 0 | 0 | 0 | 0 | 178 | 6.37 | 8192 | 110446 | 0 | | 0 | 0 | 2025-10-20 11:44:03.551522+02
startup | relation | vacuum | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8192 | 0 | 0 | 0 | | | 2025-10-20 11:44:03.551522+02
(35 rows)
--- pg_stat_replication ---
pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | backend_xmin | state | sent_lsn | write_lsn | flush_lsn | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state | reply_time
-----+----------+---------+------------------+-------------+-----------------+-------------+---------------+--------------+-------+----------+-----------+-----------+------------+-----------+-----------+------------+---------------+------------+------------
(0 rows)
--- pg_stat_checkpointer ---
num_timed | num_requested | restartpoints_timed | restartpoints_req | restartpoints_done | write_time | sync_time | buffers_written | stats_reset
-----------+---------------+---------------------+-------------------+--------------------+------------+-----------+-----------------+-------------------------------
41 | 50 | 0 | 0 | 0 | 34338197 | 112725 | 38799792 | 2025-10-20 11:44:03.551522+02
(1 row)
--- pg_stat_archiver ---
archived_count | last_archived_wal | last_archived_time | failed_count | last_failed_wal | last_failed_time | stats_reset
----------------+-------------------+--------------------+--------------+-----------------+------------------+-------------------------------
0 | | | 0 | | | 2025-10-20 11:44:03.551522+02
(1 row)
--- PostgreSQL RAM Monitoring ---
PostgreSQL RAM-Verbrauch: 38994.93 MB
System RAM: 65535.04 MB
Warnschwelle (90%): 51608.73 MB
PostgreSQL RAM-Verbrauch im grünen Bereich.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres access violation in pg_detoast_datum
2025-10-21 06:49 postgres access violation in pg_detoast_datum Arnd Empting <arnd.empting@koerber.com>
@ 2025-10-21 07:05 ` David Rowley <dgrowleyml@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: David Rowley @ 2025-10-21 07:05 UTC (permalink / raw)
To: Arnd Empting <arnd.empting@koerber.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres access violation in pg_detoast_datum
2025-10-21 06:49 postgres access violation in pg_detoast_datum Arnd Empting <arnd.empting@koerber.com>
@ 2025-10-21 08:21 ` Álvaro Herrera <alvherre@kurilemu.de>
1 sibling, 0 replies; 3+ messages in thread
From: Álvaro Herrera @ 2025-10-21 08:21 UTC (permalink / raw)
To: Arnd Empting <arnd.empting@koerber.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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"
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-10-21 08:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-10-21 06:49 postgres access violation in pg_detoast_datum Arnd Empting <arnd.empting@koerber.com>
2025-10-21 07:05 ` David Rowley <dgrowleyml@gmail.com>
2025-10-21 08:21 ` Álvaro Herrera <alvherre@kurilemu.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox