From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: zxwsbg12138@gmail.com
Subject: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
Date: Tue, 13 Dec 2022 07:50:36 +0000
Message-ID: <17716-1fe42e7b44fc2f25@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17716
Logged by: bowenshi
Email address: zxwsbg12138@gmail.com
PostgreSQL version: 13.9
Operating system: centos
Description:
Dears, I have found a problem while using logical decoding. I have two
publications, and the walsender process hang while decoding DROP PUBLICATION
XLOG of another publication. The pstack looks like following:
#0 0x00000000008b9c24 in hash_seq_search ()
#1 0x00007fd14340590c in rel_sync_cache_publication_cb () from
pgoutput.so
#2 0x0000000000897a1a in CallSyscacheCallbacks ()
#3 0x000000000073682e in ReorderBufferCommit ()
#4 0x000000000072b988 in DecodeXactOp ()
#5 0x000000000072bd52 in LogicalDecodingProcessRecord ()
#6 0x000000000074d14f in XLogSendLogical ()
#7 0x000000000074f562 in WalSndLoop ()
#8 0x0000000000750322 in exec_replication_command ()
#9 0x0000000000792301 in PostgresMain ()
#10 0x000000000048854f in ServerLoop ()
#11 0x000000000071b579 in PostmasterMain ()
#12 0x000000000048948d in main ()
When I user perl to analyze, it spend almost 99% time in `hash_seq_search`
function.
This problem can be reproduced , and I will send the shell script later.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, zxwsbg12138@gmail.com
Subject: Re: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
In-Reply-To: <17716-1fe42e7b44fc2f25@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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