issue with synchronized_standby_slots

Поиск
Список
Период
Сортировка
От Fabrice Chapuis
Тема issue with synchronized_standby_slots
Дата
Msg-id CAA5-nLCeO4MQzWipCXH58qf0arruiw0OeUc1+Q=Z=4GM+=v1NQ@mail.gmail.com
обсуждение исходный текст
Ответы RE: issue with synchronized_standby_slots
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления: