Re: No such file or directory in pg_replslot

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: No such file or directory in pg_replslot
Дата
Msg-id CAMa1XUiz+DckOA9H1zhX9-cL_qQR4cpuJjYekmm27rWm2U63xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: No such file or directory in pg_replslot  (Andres Freund <andres@anarazel.de>)
Ответы Re: No such file or directory in pg_replslot  (Jeremy Finzel <finzelj@gmail.com>)
Re: No such file or directory in pg_replslot  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Список pgsql-hackers
That doesn't indicate an error.  You need to provide more details what made you consider things wedged...

Andres

Thank you very much for the reply.  We typically see no visible replication delay over 5 minutes ever.  Today we saw a delay of over 3 hours, and no obvious increase in workload either on the provider or the subscriber.  I also did not see the LSN advancing whatsoever in terms of applying changes.

I first checked for long-running transactions on the master but there was nothing too unusual except an ANALYZE which I promptly killed, but with no improvement to the situation.

I found the messages above using strace after canceling the subscription and finding that the process was taking extremely long to cancel.  There are 2.1 million files in pg_replslot which I don't think is normal?  Any ideas as to where I should be looking or what could cause this?

Thanks,
Jeremy


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: No such file or directory in pg_replslot
Следующее
От: Pavel Stehule
Дата:
Сообщение: proposal: new polymorphic types - commontype and commontypearray