BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: zxwsbg12138(at)gmail(dot)com
Subject: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
Date: 2022-12-13 07:50:36
Message-ID: 17716-1fe42e7b44fc2f25@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17716
Logged by: bowenshi
Email address: zxwsbg12138(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-12-13 10:57:39 BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue)
Previous Message Sergey Shinderuk 2022-12-13 06:58:12 Re: BUG #17706: ALTER TYPE leads to crash