[pgpool-committers: 3087] 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
------
V3_5_STABLE
Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=a6f15a0480c910bcb5c041950342d2a5bba74a4f
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