From: Andreas Seltenreich <seltenreich@gmx.de>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,  Hubert Zhang <zhubert@vmware.com>,
  tsunakawa.takay@fujitsu.com,  pgsql-hackers@postgresql.org,
  Bruce Momjian <bruce@momjian.us>,
 Michael Meskes <michael.meskes@credativ.de>,
 Robert Treat <robert.treat@credativ.us>
Subject: Re: Multiple hosts in connection string failed to failover in non-hot
 standby mode
References: 
 <BN6PR05MB3492948E4FD76C156E747E8BC9160@BN6PR05MB3492.namprd05.prod.outlook.com>
	<TYAPR01MB299012CAC510D2644AEC2246FE160@TYAPR01MB2990.jpnprd01.prod.outlook.com>
	<BN6PR05MB3492DFB2FF32B771172CC2F2C9170@BN6PR05MB3492.namprd05.prod.outlook.com>
	<229507.1610056206@sss.pgh.pa.us> <770711.1610318330@sss.pgh.pa.us>
	<20210506162651.GJ27406@telsasoft.com>
	<4170264.1620321747@sss.pgh.pa.us>
	<20210506173813.GN27406@telsasoft.com>
Date: Thu, 06 May 2021 22:24:21 +0200
In-Reply-To: <20210506173813.GN27406@telsasoft.com> (Justin Pryzby's message
	of "Thu, 6 May 2021 12:38:13 -0500")
Message-ID: <87v97vobka.fsf@aurora.ydns.eu>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3.50 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
Archived-At: 
 <https://www.postgresql.org/message-id/87v97vobka.fsf%40aurora.ydns.eu>
Precedence: bulk

> On Thu, May 06, 2021 at 01:22:27PM -0400, Tom Lane wrote:
>> I'm curious though why it took this long for anyone to complain.
>> I'd supposed that people were running sqlsmith against HEAD on
>> a pretty regular basis.

Last time I ran it was November 27.  I'm neglecting it on my spare time
and there is hardly any opportunity to sneak it onto my agenda at work.
I'll do my best to try to get either of these fixed.

Justin Pryzby writes:
> I think it's also becase sqlsmith would need to run against the v14 *client*
> library.  I don't know about anyone else's workflow, but I tend not to "make
> install", but work with binaries out of ./tmp_install.

My playbooks don't grab the client libraries of the test target either.
I'll change them.

> There's a few changes needed on sqlsmith HEAD, but I guess nobody would have
> gotten that far if the connection was failing (or rather, detected as such).

Thanks for the patch.

regards,
andreas