[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