Date: Mon, 31 May 2021 12:33:51 +0900
From: Michael Paquier <michael@paquier.xyz>
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,
	Andreas Seltenreich <seltenreich@gmx.de>,
	Bruce Momjian <bruce@momjian.us>
Subject: Re: Multiple hosts in connection string failed to failover in
 non-hot standby mode
Message-ID: <YLRZH6CWs9N6Pusy@paquier.xyz>
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>
 <20210531012500.GP2082@telsasoft.com>
 <YLRDV0MqQnGRIo4c@paquier.xyz>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="2Le2LocKj4wHJvVr"
Content-Disposition: inline
In-Reply-To: <YLRDV0MqQnGRIo4c@paquier.xyz>
Archived-At: 
 <https://www.postgresql.org/message-id/YLRZH6CWs9N6Pusy%40paquier.xyz>
Precedence: bulk


--2Le2LocKj4wHJvVr
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, May 31, 2021 at 11:00:55AM +0900, Michael Paquier wrote:
> Yeah.  On the contrary, it could be confusing if one sees an error
> message but there is nothing to worry about, because things are
> working in the scope of what the user wanted at connection time.

In my recent quest to look at GSSAPI builds on Windows, I have bumped
into another failure that's related to this thread.  hamerkop
summarizes the situation here:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dhamerkop&dt=3D202=
1-05-29%2010%3A15%3A42

There are two failures like this one as errorMessage piles up on
failures, as of connect/test5:
-[NO_PID]: ECPGconnect: connection to server failed: FATAL:  database
 "regress_ecpg_user2" does not exist
+[NO_PID]: ECPGconnect: connection to server failed: could not
 initiate GSSAPI security context: Unspecified GSS failure.  Minor
 code may provide more information: Credential cache is empty
+connection to server failed: FATAL:  database "regress_ecpg_user2"
 does not exist=20
--
Michael

--2Le2LocKj4wHJvVr
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmC0WR8ACgkQnvQgOdby
QH2uYw//Wi2xY2Be7aQhIJtIBMmfSdnNb3HoqXPM/hiUU7rDJXfGIpNM3PmgffOb
023t32xfuNmSPD36JUYrYxB8CqDDCam7FYJ3M4udOBa4ZUivpdAWCp/g1Xo/uoeI
cJ7g0/lWe5mZeHBkVIZ9CVWOf/DH05BqW2pG0F7vzg4yP/kTBWLUeG2f5yZEszwh
WqH9tpeS/UrW4O8MZNxOy0touTF0y5sUqyX4sIsXGs2L8UMRMIgSexRnIeEWfkL8
wVuj7pqKs9plpTU2WjZvO7KiB3/vlCdNw9J6mFNBt7oXvy308ddp2weVafn5cd4b
MRTes5oAJawQvUyRHZIw0mxv41P3ygVA0JJT0JSEsjjGKOvu4TkdyPomAVAzb+Xz
K7gliLajhwKnL0e507O048SiEXMALaMfU7VWiV7omDjmmyv4LuM0G/cQc6UsryKx
KVBrW8DelYck8hbR/Zdnz6lXi0RAr7PVT46v2TJ4cykUeAW2hnxdIG2l+sypAwVp
gpj3TLVk3JTrHv4g67PyrbiqTS/ZJ+hzs/aV8OXoc1Q+5XXJueWLAVyegcXgxiEr
PbR/bJCf7BNOt0X5MTFJh2n0vgLi3GepMm6ZNazXFm9uQUDV+s+R3P+tjLYwDoqB
xTgGXpcg6aw1ZWVjITI4XYLBcXU62Rc3KL9IlVt3enrVvhG2s1w=
=BR5v
-----END PGP SIGNATURE-----

--2Le2LocKj4wHJvVr--