Hi,
With PG 17.5 and using logical replication failover slots.
When trying to change the value of synchronized_standby_slots, node2 was
not running then the error * invalid value for parameter
"synchronized_standby_slots": "node1,node2"  *was generated.
The problem is that statement were affected by this and they can't execute.

STATEMENT:  select service_period,sp1_0.address_line_1 from tbl1  where
sp1_0.vn=$1 order by sp1_0.start_of_period
2025-08-24 13:14:29.417 CEST [848477]: [1-1] user=,db=,client=,application=
ERROR:  invalid value for parameter "synchronized_standby_slots":
"node1,node2"
2025-08-24 13:14:29.417 CEST [848477]: [2-1] user=,db=,client=,application=
DETAIL:  replication slot "s029054a" does not exist
2025-08-24 13:14:29.417 CEST [848477]: [3-1] user=,db=,client=,application=
CONTEXT:  while setting parameter "synchronized_standby_slots" to
"node1,node2"
2025-08-24 13:14:29.418 CEST [777453]: [48-1]
user=,db=,client=,application= LOG:  background worker "parallel worker"
(PID 848476) exited with exit code 1
2025-08-24 13:14:29.418 CEST [777453]: [49-1]
user=,db=,client=,application= LOG:  background worker "parallel worker"
(PID 848477) exited with exit code 1

Is this issue already observed

Thanks for your feedback

Fabrice

Reply via email to