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 > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general
DIFF
Description: Binary data
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
