BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
От | PG Bug reporting form |
---|---|
Тема | BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG |
Дата | |
Msg-id | 17716-1fe42e7b44fc2f25@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #17716: walsender process hang while decoding 'DROP PUBLICATION' XLOG
|
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: