Message-ID: <de57761c-b99b-3435-b0a6-474c72b1149a@enterprisedb.com>
Date: Fri, 6 May 2022 15:49:28 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
 Gecko/20100101 Thunderbird/91.9.0
Subject: Re: libpq async duplicate error results
Content-Language: en-US
To: Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
References: <202202081500.xl3iwa7doscz@alvherre.pgsql>
 <394797.1645388816@sss.pgh.pa.us> <1262938.1645658107@sss.pgh.pa.us>
 <1421785.1645723238@sss.pgh.pa.us>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: <1421785.1645723238@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/de57761c-b99b-3435-b0a6-474c72b1149a%40enterprisedb.com>
Precedence: bulk

I took another look at this.  The output from the test program at the 
beginning of the thread is now (master branch):

command = SELECT 'before';
result 1 status = PGRES_TUPLES_OK
error message = ""

command = SELECT pg_terminate_backend(pg_backend_pid());
result 1 status = PGRES_FATAL_ERROR
error message = "FATAL:  terminating connection due to administrator command
"
result 2 status = PGRES_FATAL_ERROR
error message = "server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
"

command = SELECT 'after';
PQsendQuery() error: FATAL:  terminating connection due to administrator 
command
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
no connection to the server


It appears the "after" query is getting the error message from the 
previous cycle somehow.


The output in PG14 and PG13 is:

command = SELECT 'after';
PQsendQuery() error: no connection to the server


Is the change intended or do we need to think about more tweaking?