[pgpool-hackers: 2186] Re: [pgpool-committers: 3874] pgpool: Fix the case when duplicate statement remains.

Tatsuo Ishii ishii at sraoss.co.jp
Fri Mar 24 17:58:55 JST 2017


Sergey,

I have found a nasty bug with Pgpool-II and pushed the fix to git
repository. You might want to test the fix.

> Fix the case when duplicate statement remains.
> 
> By using parse_before_bind, it is possible a parsed statement remains
> on the load balance node even if explicit close is issued because the
> close is redirected to the primary node. Fix is, issue close to both
> primary and load balance node anytime. This sounds is a little bit
> over killing but I think there's no way to remember the statement
> remains on a load balance node.
> 
> Also clean up some ifdef NOT_USED garbage.
> 
> Branch
> ------
> bug271
> 
> Details
> -------
> http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=2277a500042c8bbe2a4e2a069d23cece0e6ecded
> 
> Modified Files
> --------------
> src/auth/pool_auth.c                       |  11 ---
> src/context/pool_session_context.c         |  19 ++++
> src/include/context/pool_session_context.h |   1 +
> src/protocol/pool_process_query.c          | 142 ++---------------------------
> src/protocol/pool_proto_modules.c          | 109 +++-------------------
> 5 files changed, 40 insertions(+), 242 deletions(-)
> 


More information about the pgpool-hackers mailing list