一、问题现象:
Postgresql 11.2版本物理复制,startup 进程命令行有时会出现waiting 标识。本文分析了出现waiting 标识的原因。
二、问题分析:
通过ps -ef | grep startup 监控startup 进程。
postgres: startup process recovering 0000000100000000000000A6
当startup 进程出现waiting的标识。通过pstack查看startup 进程调用堆栈
[postgres@sscloud21 ~]$ pstack 197120
#0 0x00007f695b6faf53 in __select_nocancel () from /lib64/libc.so.6
#1 0x000000000088c97a in pg_usleep (microsec=) at pgsleep.c:56
#2 0x0000000000729ef9 in WaitExceedsMaxStandbyDelay () at standby.c:201
#3 ResolveRecoveryConflictWithVirtualXIDs (waitlist=0x1c706e0, reason=reason@entry=PROCSIG_RECOVERY_CONFLICT_SNAPSHOT) at standby.c:262
#4 0x000000000072a10e in ResolveRecoveryConflictWithVirtualXIDs (reason=PROCSIG_RECOVERY_CONFLICT_SNAPSHOT, waitlist=) at standby.c:315
#5 ResolveRecoveryConflictWithSnapshot (latestRemovedXid=, node=…) at standby.c:313
#6 0x00000000004c23be