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

Tatsuo Ishii ishii at postgresql.org
Fri Aug 9 20:02:10 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
------
master

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

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



More information about the pgpool-committers mailing list