[pgpool-general: 8804] Re: queries not redirecting to primary when "delay_threshold_by_time" is exceeded
Tatsuo Ishii
ishii at sraoss.co.jp
Mon Jun 5 08:46:15 JST 2023
> Hi
>
> We have pgpool 4.4.2 with streaming replication setup using PG 14.7
> (primary+1 replica)
>
> The configuration is set up to check for replication lag every 5 seconds
> and we have also set up "delay_treshold_by_time=1" (meaning 1 second)
>
> We can see replication lag messages in the log as well as check the
> replication lag using SHOW POOL_NODES and pcp_node_info.
> All that works fine...
>
> However, we are noticing that even after the lag is detected and
> exceeds 1 second, the SELECT queries are NOT being routed back to the
> primary server!
>
> Attached file has config and sample taken from the log (with
> log_per_node_statement=on)
> This is a rather impactful issue for us because the application is
> getting stale data.
> I know we can redirect all queries to go to primary on per application
> basis but would rather leverage load balancing when possible.
I will look into this.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list