Hi hackers,

There was a random buildfarm failure for 030_pg_recvlogical [1].

It tests that pg_recvlogical can re connect to the server if it the connection 
is
lost. And we try to ensure by motnitoring the active_pid of the 
pg_replication_slots
is changed.

According to the logfile in [1], the PID of the first walsender was 4360, and
pg_terminate_backend() was done toward it. But while waiting a slot was acquired
by the different process, another walsender whose PID was 4360 (!) was started
and it acquired the slot. The test finally failed because the slot was not
acquired by the different process.

Not sure, does it indicate some other issues? If no, we can wait log output like
"STATEMENT:  START_REPLICATION SLOT "reconnect_test" LOGICAL"
to make the test robust.

[1]: 
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-07-30%2009%3A58%3A12

Best regards,
Hayato Kuroda
FUJITSU LIMITED



Reply via email to