[pgpool-committers: 10054] pgpool: Fix bug in replication mode and snapshot isolation mode.
Tatsuo Ishii
ishii at postgresql.org
Fri Aug 9 20:02:05 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_5_STABLE
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=4c2c06fe3256ad787c5ea5aa7bc1bb6158fc0104
Modified Files
--------------
src/protocol/pool_proto_modules.c | 28 +++++++++++++++++++++++++---
1 file changed, 25 insertions(+), 3 deletions(-)
More information about the pgpool-committers
mailing list