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

[Tatsuo Ishii]

It seems it's a bug with pgpool (and with pgpool-II as well).

pgpool choose a node using random() in the load balance mode. Current
code does not seem to take account of the case when random() returns
0. Can you try out the included patches?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hello,
> 
> My reading of the mailing list archives shows that my issue below is
> experienced by others (but I cannot find a solution).
> 
> Does pgpool-II 2.1 beta1 address this issue?  If so, would it best for me
> to wait for a stable pgpool-II version and upgrade, or is there a solution
> for pgpool-I?
> 
> *any* kind of response from someone who knows would be appreciated.
> 
> Thanks
> Henry
> 
> On Wed, March 12, 2008 12:41 pm, Henry wrote:
> > Hello all,
> >
> > Pgpool: 3.4.1
> > Pg: 8.2.6
> > OS: CentOS 5
> >
> > I've configured multiple slaves to use pgpool in conjunction with slony.
> > Updates/deletes/inserts get redirected (via pgpool) to the master, and
> > selects are performed locally on the slaves.
> >
> > Relevant entries in pgpool.conf:
> > replication_mode = false
> > replication_strict = true
> > weight_master = 0
> > weight_secondary = 1
> >
> > Now, for the most part, things work fine.  99.99% of selects are executed
> > locally, mods go to the master as expected.
> >
> > Problem is, occasionally (actually, many times a day) on our (very) busy
> > cluster, SELECTs from the slaves will appear on the master (despite
> > "weight_master = 0").
> >
> > Is there any way I can *force* SELECTs to *always* be performed locally?
> > In our case, these occasional selects being incorrectly directed to the
> > master are a problem (performance-wise).
> >
> > Any suggestions are appreciated.
> >
> > Thanks
> > Henry
> >
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
> >
> 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DIFF
Type: application/octet-stream
Size: 862 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080318/29a8cfe2/attachment.obj