[pgpool-committers: 3790] 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
------
master

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

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



More information about the pgpool-committers mailing list