[pgpool-committers: 3789] pgpool: Fix load balancing bug in streaming replication mode.

Tatsuo Ishii ishii at postgresql.org
Mon Jan 30 16:39:37 JST 2017


Fix load balancing bug in streaming replication mode.

In an explicit transaction, any SELECT will be load balanced until
write query is sent. After writing query is sent, any SELECT should be
sent to the primary node. However if a SELECT is sent before a sync
message is sent, this does not work since the treatment of writing
query is done after ready for query message arrives. Solution is, the
treatment for writing query is done in executing the writing query as
well.

The bug has been there since V3.5.

Branch
------
V3_6_STABLE

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=fb58877ee895c087836c0e725769599b2095d4c1

Modified Files
--------------
src/protocol/pool_proto_modules.c | 25 +++++++++++++++++++++++++
1 file changed, 25 insertions(+)



More information about the pgpool-committers mailing list