[pgpool-committers: 3086] pgpool: Fix extended query hangs
Tatsuo Ishii
ishii at postgresql.org
Tue Mar 29 21:11:53 JST 2016
Fix extended query hangs
Deal with bug 167. The problem is in the following sequence:
Parse(BEGIN)
Bind
:
Execute
Parse(SELECT)
Bind
:
(Notice that no Sync message between Execute and Parse)
BEGIN is sent to all db nodes while select is sent to one of db
nodes. So pgpool is confused which DB node to read the response. To
fix this, after each Execute, send flash message to backend to get
response. This will ensure that the responses of BEGIN etc. are read
from all DB nodes while the responses of SELECT etc. are read from
only one of DB node.
Branch
------
master
Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=39e07ea13a7f318f2c50a8aec7baa93e13a347d3
Modified Files
--------------
src/protocol/CommandComplete.c | 3 +++
src/protocol/pool_proto_modules.c | 26 ++++++++++++++++++++++++++
2 files changed, 29 insertions(+)
More information about the pgpool-committers
mailing list