Re: CREATE REPLICATION SLOT fails on a timeout

Поиск
Список
Период
Сортировка
От andres@anarazel.de (Andres Freund)
Тема Re: CREATE REPLICATION SLOT fails on a timeout
Дата
Msg-id 20140528224156.GE27914@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: CREATE REPLICATION SLOT fails on a timeout  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: CREATE REPLICATION SLOT fails on a timeout
Список pgsql-hackers
Hi,

On 2014-05-17 01:34:25 +0200, Andres Freund wrote:
> On 2014-05-16 17:02:33 -0400, Steve Singer wrote:
> > >I don't think that's going to cut it though. The creation can take
> > >longer than whatever wal_sender_timeout is set to (when there's lots of
> > >longrunning transactions). I think checking whether last_reply_timestamp
> > >= 0 during timeout checking is more robust.
> 
> > That makes sense.
> > A patch that does that is attached.
> 
> I've attached a heavily revised version of that patch. Didn't touch all
> the necessary places...
> 
> Survives creation of logical replication slots under 'intensive
> pressure', with a wal_sender_timeout=10ms.
> 
> Thanks for the bugreport!

Pushed a fix for it. I am pretty sure it will, but could you still test
that it fixes your problem?

Thanks!

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SP-GiST bug.
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: json casts