Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15617: walsender hang if sync replica disconnected from network - Mailing list pgsql-bugs

From Evgeniy Efimkin
Subject Re: BUG #15617: walsender hang if sync replica disconnected from network
Date
Msg-id 1117411552068004@sas2-76706d252d16.qloud-c.yandex.net
Whole thread Raw
In response to Re: BUG #15617: walsender hang if sync replica disconnected fromnetwork  (Evgeniy Efimkin <efimkin@yandex-team.ru>)
List pgsql-bugs
Tree view 
Hi!
Maybe need additional diagnostic?

02.02.2019, 20:41, "Evgeniy Efimkin" <efimkin@yandex-team.ru>:
> Hi!
> I reproduced it.
> 1. Make some write load on master: `pgbench -i -s 100000 testdb`
> 2. On sync replica drop output connections, while pgbench init database: `ip6tables -A OUTPUT -p tcp --dport 5432 -j
DROP`
> 3. Until was_sender_timeout reached, i send SIGHUB on master: `select pg_reload_conf();`
> After that walsender forever stay in WaitEventSetWait, because no timeout
>
> src/backend/libpq/be-secure.c:273
> WaitEventSetWait(FeBeWaitSet, -1 /* no timeout */ , &event, 1,
>                  WAIT_EVENT_CLIENT_READ);

-------- 
Efimkin Evgeny

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15678: The postgresql.conf string does not define server behavior (default_transaction_isolation)
Next
From: Andres Freund
Date:
Subject: Re: BUG #15678: The postgresql.conf string does not define serverbehavior (default_transaction_isolation)