[pgpool-committers: 3837] pgpool: Fix issue with bug271.

Tatsuo Ishii ishii at postgresql.org
Thu Mar 16 14:24:26 JST 2017


Fix issue with bug271.

When an INSERT is executed in a transaction, a "writing_transaction"
is set. The flag is checked by a succeeding SELECT to decide if
parse_before_bind (which resend the parse message to primary node if
it is executed on the standby) needs to be executed.  The flag is
reset when a command complete message for BEGIN is arrived.  Problem
is, it is possible that the command complete message could arrive
before the bind for the SELECT is executed, and at this point the flag
is already cleared.

Solution is, do not reset the flag when the command complete message
arrives if in streaming replication mode.

Branch
------
bug271

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=9bf8eccff8fa54e2491ee3cb5b15ce17a1310ed9

Modified Files
--------------
src/protocol/CommandComplete.c    | 2 +-
src/protocol/pool_proto_modules.c | 3 +++
2 files changed, 4 insertions(+), 1 deletion(-)



More information about the pgpool-committers mailing list