[pgpool-committers: 3078] pgpool: Fix pgpool hang bug (deal with bug 167)

Tatsuo Ishii ishii at postgresql.org
Mon Mar 28 10:53:44 JST 2016

Fix pgpool hang bug (deal with bug 167)

pgpool-II 3.5 or after in streaming replication mode does not wait for
response from each phase such parse, bind anymore.  However, if
do_query is called, it sends flush message to retrieve the result of
system catalog look up. This is only sent to primary node which may
results in retrieving previous message results, for example parse
complete. If standby is assigned to load balance node, the node does
not return parse complete message, which will cause a problem in
bug167 case, because parse message for "BEGIN" was sent to both the
primary and the standby. Fix is, send flush message in do_query if the
load balance node is one of standbys.



Modified Files
src/context/pool_session_context.c | 22 +++++++++++++++++++++-
src/protocol/pool_process_query.c  | 24 ++++++++++++++++++++++++
2 files changed, 45 insertions(+), 1 deletion(-)

More information about the pgpool-committers mailing list