Re: per backend WAL statistics

Hi,

On 2025-03-05 13:03:07 +0000, Bertrand Drouvot wrote:
> But yeah, if 0002 in [1] does not go in, then your concern is valid, so adding
> the extra check in the attached.

This crashes in cfbot:

https://cirrus-ci.com/task/5111872610893824

[13:42:37.315] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores
[13:42:37.620] dumping /tmp/cores/postgres.7656.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
[13:42:37.749] [New LWP 101860]
[13:42:37.831] Core was generated by `postgres: primary: checkpointer '.
[13:42:37.831] Program terminated with signal SIGABRT, Aborted.
[13:42:37.831] Sent by thr_kill() from pid 7656 and user 1003.
[13:42:37.831] #0 0x000000082c0f941a in thr_kill () from /lib/libc.so.7
[13:42:37.860]
[13:42:37.860] Thread 1 (LWP 101860):
[13:42:37.860] #0 0x000000082c0f941a in thr_kill () from /lib/libc.so.7
[13:42:37.860] No symbol table info available.
[13:42:37.860] #1 0x000000082c072e64 in raise () from /lib/libc.so.7
[13:42:37.860] No symbol table info available.
[13:42:37.860] #2 0x000000082c1236f9 in abort () from /lib/libc.so.7
[13:42:37.860] No symbol table info available.
[13:42:37.860] #3 0x0000000000ab2125 in ExceptionalCondition (conditionName=0x340512 "!pgStatLocal.shmem->is_shutdown", fileName=<optimized out>, lineNumber=lineNumber(at)entry=746) at ../src/backend/utils/error/assert.c:66
[13:42:37.860] No locals.
[13:42:37.860] #4 0x000000000096bcd4 in pgstat_report_stat (force=true) at ../src/backend/utils/activity/pgstat.c:746
[13:42:37.860] pending_since = 0
[13:42:37.860] last_flush = 794496967784484
[13:42:37.860] now = <optimized out>
[13:42:37.860] partial_flush = <optimized out>
[13:42:37.860] nowait = <optimized out>
[13:42:37.860] #5 0x000000000096bef9 in pgstat_shutdown_hook (code=<optimized out>, arg=<optimized out>) at ../src/backend/utils/activity/pgstat.c:616
[13:42:37.860] No locals.
[13:42:37.860] #6 0x00000000009221b1 in shmem_exit (code=code(at)entry=0) at ../src/backend/storage/ipc/ipc.c:243
[13:42:37.860] No locals.
[13:42:37.860] #7 0x00000000009220a8 in proc_exit_prepare (code=101860, code(at)entry=0) at ../src/backend/storage/ipc/ipc.c:198
[13:42:37.860] No locals.
[13:42:37.860] #8 0x0000000000921fef in proc_exit (code=code(at)entry=0) at ../src/backend/storage/ipc/ipc.c:111
[13:42:37.860] No locals.
[13:42:37.860] #9 0x00000000008a265e in CheckpointerMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at ../src/backend/postmaster/checkpointer.c:630
[13:42:37.860] local_sigjmp_buf = {{_sjb = {9052188, 34925197376, 34925197368, 34925197536, 12666224, 11, 1, 35301277696, 895, -2147815357, -1, 34359738369}}}
[13:42:37.860] checkpointer_context = <optimized out>
[13:42:37.860] #10 0x00000000008a35a5 in postmaster_child_launch (child_type=child_type(at)entry=B_CHECKPOINTER, child_slot=56, startup_data=startup_data(at)entry=0x0, startup_data_len=startup_data_len(at)entry=0, client_sock=client_sock(at)entry=0x0) at ../src/backend/postmaster/launch_backend.c:274
[13:42:37.860] pid = <optimized out>
[13:42:37.860] #11 0x00000000008a61a7 in StartChildProcess (type=type(at)entry=B_CHECKPOINTER) at ../src/backend/postmaster/postmaster.c:3905
[13:42:37.860] pmchild = 0x0
[13:42:37.860] pid = <optimized out>
[13:42:37.860] #12 0x00000000008a5d16 in PostmasterMain (argc=argc(at)entry=4, argv=argv(at)entry=0x821b43e68) at ../src/backend/postmaster/postmaster.c:1371
[13:42:37.860] userDoption = <optimized out>
[13:42:37.860] listen_addr_saved = false
[13:42:37.860] output_config_variable = <optimized out>
[13:42:37.860] opt = <optimized out>
[13:42:37.860] status = <optimized out>
[13:42:37.860] #13 0x00000000007da2e0 in main (argc=4, argv=0x821b43e68) at ../src/backend/main/main.c:230
[13:42:37.860] do_check_root = <optimized out>
[13:42:37.860] dispatch_option = DISPATCH_POSTMASTER
[13:42:37.870]