RE: incorrect wal removal due to max_slot_wal_keep_size

Поиск
Список
Период
Сортировка
От Hayato Kuroda (Fujitsu)
Тема RE: incorrect wal removal due to max_slot_wal_keep_size
Дата
Msg-id TYAPR01MB56927540236C5618DDF88355F5782@TYAPR01MB5692.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на incorrect wal removal due to max_slot_wal_keep_size  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Dear Jeff,

Thanks for reporting the issue. I've tried to reproduce the issue (by adding delay
on worker-side and immediate shut-down), but not done yet. If possible, could you
please share a script to reproduce? It is helpful to analyze.

> I'm going to try to reproduce this on 17.0, but in the meantime any other suggestions for investigating this?x

It is very helpful to check the content of pg_stat_replication_slots view and pg_wal
directory of the postgres, when you succeed to reproduce. Also, please set
log_min_messages = DEBUG2 to check logs from RemoveOldXlogFiles() and RemoveXlogFile().
I want to see the log when you can reproduce.

They are inspired by [1]. I doubt the thread and yours are the same issue or not.

[1]: https://www.postgresql.org/message-id/flat/Yz2hivgyjS1RfMKs%40depesz.com

Best regards,
Hayato Kuroda
FUJITSU LIMITED


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