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

Tatsuo Ishii ishii at postgresql.org
Fri Aug 9 20:01:59 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_4_STABLE

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

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



More information about the pgpool-committers mailing list