pgsql: Fix bogus completion tag usage in walsender - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Fix bogus completion tag usage in walsender
Date
Msg-id E1kIhcm-0000FG-0p@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix bogus completion tag usage in walsender

Since commit fd5942c18f97 (2012, 9.3-era), walsender has been sending
completion tags for certain replication commands twice -- and they're
not even consistent.  Apparently neither libpq nor JDBC have a problem
with it, but it's not kosher.  Fix by remove the EndCommand() call in
the common code path for them all, and inserting specific calls to
EndReplicationCommand() specifically in those places where it's needed.

EndReplicationCommand() is a new simple function to send the completion
tag for replication commands.  Do this instead of sending a generic
SELECT completion tag for them all, which was also pretty bogus (if
innocuous).  While at it, change StartReplication() to use
EndReplicationCommand() instead of pg_puttextmessage().

In commit 2f9661311b83, I failed to realize that replication commands
are not close-enough kin of regular SQL commands, so the
DROP_REPLICATION_SLOT tag I added is undeserved and a type pun.  Take it
out.

Backpatch to 13, where the latter commit appeared.  The duplicate tag
has been sent since 9.3, but since nothing is broken, it doesn't seem
worth fixing.

Per complaints from Tom Lane.

Discussion: https://postgr.es/m/1347966.1600195735@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/07082b08cc5d3c378d22c105c65841ec0952e3ed

Modified Files
--------------
src/backend/replication/walsender.c | 34 +++++++++++++++++++++-------------
src/backend/tcop/dest.c             | 12 ++++++++++++
src/include/tcop/cmdtaglist.h       |  1 -
src/include/tcop/dest.h             |  1 +
4 files changed, 34 insertions(+), 14 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Centralize setup of SIGQUIT handling for postmaster child proces
Next
From: Tom Lane
Date:
Subject: pgsql: Improve formatting of create_help.pl and plperl_opmask.pl output