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.
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 |