Assertion failure with summarize_wal enabled during pg_createsubscriber

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Assertion failure with summarize_wal enabled during pg_createsubscriber
Date: 2024-07-01 05:54:56
Message-ID: 2a6fe324-3008-4e44-9ff6-b5bba9232490@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2024-07-01 05:55:56 Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)
Previous Message Michael Paquier 2024-07-01 05:48:19 Re: Use pgstat_kind_infos to read fixed shared stats structs