[pgpool-committers: 3791] 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_5_STABLE

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

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



More information about the pgpool-committers mailing list