[pgpool-committers: 10052] pgpool: Fix bug in replication mode and snapshot isolation mode.

Tatsuo Ishii ishii at postgresql.org
Fri Aug 9 20:01:54 JST 2024


Fix bug in replication mode and snapshot isolation mode.

In replication mode and snapshot isolation mode when a command fishes,
pgpool waits for a ready for query message but forgot that some
commands (for example SET ROLE) produces a parameter status
message. As a result pgpool errors out that other message arrives
before the ready for query message.  Deal with the case when a
parameter status message arrives.

Here is the test case written in pgproto data format.

'P'     ""      "SET ROLE TO foo"
'B'     ""      ""      0       0       0
'E'     ""      0
'P'     ""      "SELECT 1"
'B'     ""      ""      0       0       0
'E'     ""      0
'S'
'Y'

Backpatch-through: v4.1.

Branch
------
V4_3_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=01c7229221e7694315eabc5cc2af92e2a13c83eb

Modified Files
--------------
src/protocol/pool_proto_modules.c | 28 +++++++++++++++++++++++++---
1 file changed, 25 insertions(+), 3 deletions(-)



More information about the pgpool-committers mailing list