Hi,
In HEAD, I encountered the following assertion failure when I enabled
summarize_wal
and ran pg_createsubscriber.
2024-07-01 14:42:15.697 JST [19195] LOG: database system is ready to accept
connections
TRAP: failed Assert("switchpoint >= state->EndRecPtr"), File:
"walsummarizer.c", Line: 1382, PID: 19200
0 postgres 0x0000000105c46c5d ExceptionalCondition
+ 189
1 postgres 0x000000010590b1e4
summarizer_read_local_xlog_page + 340
2 postgres 0x00000001054e401e ReadPageInternal +
542
3 postgres 0x00000001054e24c0 XLogDecodeNextRecord
+ 464
4 postgres 0x00000001054e2283 XLogReadAhead + 67
5 postgres 0x00000001054e2185 XLogReadRecord + 53
6 postgres 0x000000010590a3ab SummarizeWAL + 1115
7 postgres 0x000000010590963a WalSummarizerMain +
1242
8 postgres 0x00000001058fd10a
postmaster_child_launch + 234
9 postgres 0x000000010590133d StartChildProcess +
29
10 postgres 0x0000000105904582
MaybeStartWalSummarizer + 82
11 postgres 0x0000000105901af1 ServerLoop + 1153
12 postgres 0x00000001059007ca PostmasterMain + 6554
13 postgres 0x00000001057a3782 main + 818
14 dyld 0x00007ff80e5e2366 start + 1942
2024-07-01 14:42:15.912 JST [19195] LOG: WAL summarizer process (PID 19200)
was terminated by signal 6: Abort trap: 6
2024-07-01 14:42:15.913 JST [19195] LOG: terminating any other active server
processes
Here are the steps to reproduce this issue.
--------------------------------
initdb -D pub
cat <<EOF >> pub/postgresql.conf
wal_level = 'logical'
summarize_wal = on
EOF
pg_ctl -D pub start
pgbench -i
pgbench -T 600 &
pg_basebackup -D sub -c fast -R
pg_createsubscriber -d postgres -D sub -p 5433 -P "port=5432"
--------------------------------
Is this the known issue?
Regards,
--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION
