[Pgpool-general] SELECTs sometimes being redirected (incorrectly) to master

[Henry]

On Wed, April 23, 2008 4:06 pm, Tatsuo Ishii wrote:
> Thanks for the report. If you try to use pgpool-II with replication
> mode, I could help you as far as I can. I hope your project going
> well.

Hi there Tatsuo Ishii,

As promised, here's the feedback (albeit belatedly).  Following on with
regards the issue with PgPool 1 sometimes sending SELECTs to the master
when it's not supposed to, it looks like PgPool 2 is doing the same (ie,
with backend_weight0 = 0).  I'm still seeing the occasional SELECT from
the slaves being executed on the master.

The patch you provided was for PgPool 1, any idea on what changes would be
required for PgPool 2?  ie, if backend_weightN = 0, then do *not* load
balance SELECTs to node N.  I had a look at the code and noticed that the
logic has changed a bit, but I'm not sure what to tweak to test (sadly, I
don't have the time to really study the code).

Regards
Henry