From: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: BF animal malleefowl reported an failure in 001_password.pl
Thread-Topic: BF animal malleefowl reported an failure in 001_password.pl
Thread-Index: AdknVpcFuzIRIXuCQ8+BxklTBKwb2A==
Date: Fri, 13 Jan 2023 13:55:31 +0000
Message-ID:
 <OS0PR01MB57163D3BF2AB42ECAA94E5C394C29@OS0PR01MB5716.jpnprd01.prod.outlook.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels:
 =?iso-2022-jp?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZl?=
 =?iso-2022-jp?B?Y2UwNTBfQWN0aW9uSWQ9NDc5YzM5YTQtYjM5OS00ZmI0LWIwMTktNGVk?=
 =?iso-2022-jp?B?OTQ2ZDY5ODdhO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFi?=
 =?iso-2022-jp?B?NGQtM2IwZjRmZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9h?=
 =?iso-2022-jp?B?NzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxl?=
 =?iso-2022-jp?B?ZD10cnVlO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQt?=
 =?iso-2022-jp?B?M2IwZjRmZWNlMDUwX01ldGhvZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3?=
 =?iso-2022-jp?B?Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9OYW1lPUZV?=
 =?iso-2022-jp?B?SklUU1UtUkVTVFJJQ1RFRBskQiJMJT8lUhsoQjtNU0lQX0xhYmVsX2E3?=
 =?iso-2022-jp?B?Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRl?=
 =?iso-2022-jp?B?PTIwMjMtMDEtMTNUMTM6MzU6MjdaO01TSVBfTGFiZWxfYTcyOTVjYzEt?=
 =?iso-2022-jp?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?=
 =?iso-2022-jp?B?ZC04MWUxLTQ4NTgtYTlkOC03MzZlMjY3ZmQ0Yzc7?=
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=fujitsu.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: OS0PR01MB5716:EE_|TYAPR01MB5627:EE_
x-ms-office365-filtering-correlation-id: 9f4aa178-8979-45e2-3fe8-08daf56dd636
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info:
 OjQT4kXASZ4NdBMGFIi/+EdC1LxR+K/w5xxXMjZ8ZRDluM9nKRamin/LQiM0lBaDY6FS0/QIsC8dHOLWhk4RvdY88kzJLB+l4WXwj72D04T8hhvvDDcfz1nVd8gkBrqOevh3qsBUf1KhVuT3RsqSN6I00X3/YUIU6wDRmzm9SlDEfQlKqf8IcRViY/KHVr7hvF2XBTfqilUoGfmuvdiP/m7xbOV1ls/qa33ySS5F5IhwpDaAzjhddZ+F50+kBiEnP99hw12fc8D/aQMWFcyyL988pj5fEcKQC9D4/IEe9qeuUXi7Uy8DtcMPOI823jr3kUPC5CXawZ798eYnv3IsaF+SPFsZUusLQpgx7GqtpgDORc8mfpUPhoY2GRinBcQCTMvR+vuaKceAiwD4fCg++Zy7eQylldY5EeQLoKb+gl49PBmUTQOATCGPX9xyTUPVRUj4GUzHMv2sA8vW3g8h0EW1nW/X05MbUZHA5bCsYI06s5tsnLHDUu3OuCC6IQvYDz6w1DtMoklepUR/jjV2QRl/shqWYpRQoJNGCcdl/Inqj3xJ3Ssrp2NARoNmERGozKcRKsbioz2W3CaBDzIcBe5xe+QG8U42kSq6BYuFBtyq9BHCTFWE+xNm3RVNaA6N/3IIxkA3t19LAqQwwTU/4RsO4j4ZVM/uo9S/UIkslJvadIzLefpt/pOnuHRlgh31n2Of7UeHC+OZBTc0+LILqXX+Gqo3lQffmq7xFd9lNPKl/w1XNh40t4odS9uvf37MnmsJrZdBVJwKqGS21e+8CQ==
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS0PR01MB5716.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230022)(4636009)(366004)(39860400002)(376002)(346002)(396003)(136003)(1590799012)(451199015)(66556008)(41300700001)(52536014)(8676002)(122000001)(6916009)(66476007)(66946007)(64756008)(76116006)(66446008)(5660300002)(1580799009)(82960400001)(38070700005)(8936002)(316002)(2906002)(86362001)(38100700002)(71200400001)(966005)(85182001)(7696005)(478600001)(9686003)(186003)(26005)(55016003)(6506007)(33656002)(83380400001)(21314003);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-2022-jp?B?STVUZkRrb0RrOFlpRGxGdUtnUXZxd3JmdHJZNmRCc2p4MVgvVFdKbXBJ?=
 =?iso-2022-jp?B?RTdzNEJTdDRUckxIN3MwL0JuU1NFMWJxWkJrdjZjK1gvSkNCUFhObmtp?=
 =?iso-2022-jp?B?QnlLbDFMdzRDZUI2YWN0UzFaZzVTYndoN0VPMGxSMTEwVDBzTkRIWW8r?=
 =?iso-2022-jp?B?VFNkaEN0czRwTFZJQW1JNkdiZGxjd3Z4SjZ5K1dETUVaZU52c1NtSVBm?=
 =?iso-2022-jp?B?aSt1RlgyWE9sNDZ0YVlpOVltMUlheFludlhnQ3AzRVBYc29oMFZkYzRu?=
 =?iso-2022-jp?B?ekdOeDRrekx4WGUrd2RrUHBTQUJwSm5hcytTcTBmVm1jUytISThUcU0r?=
 =?iso-2022-jp?B?cXlKbU5EQmN5YzZ1NU5xd2dUT0JtaVhpemlTd0Vyd202QlFJdTJLcVIy?=
 =?iso-2022-jp?B?aHJCMmlodm5wSTdZMFN0Z211TWYrN1VXNU9GSHFZSzJCWVdYdUFHa0pr?=
 =?iso-2022-jp?B?MDEzanA5U2p1RUprSDlTNGhlR0U2MnkxS2RtNU5uV1IwTlhCWFovTzI5?=
 =?iso-2022-jp?B?d1A4Y0JhaUVObWZMbk0xYVdIVzVvTTdwZ2p5U2wrVllZVXFLcWNGMDVY?=
 =?iso-2022-jp?B?dnJwN2lOanZKZmR3T2o5bWNuR09YZ1V0d0toQWFtTzNEYXEvSGdkcWZP?=
 =?iso-2022-jp?B?eDVUaFAxVlFubmNTUmQ2NWJ0UGhxWGJVbHdoZDVrSjRDV2NIbDlGcnpU?=
 =?iso-2022-jp?B?eVN2SWhMTXpQaFM0bkNlcmVuaXJtNzlSNHk3ZVNyMEFUM2hnUGhodThj?=
 =?iso-2022-jp?B?NTMrYURmNXo5WXRsWnZoVSt1MVRUOFZuK0tsdHdvNEYrbTFLSDJ3Z0VR?=
 =?iso-2022-jp?B?VFFhS1ZtTWhla29NYXd2UTBuQXB2Nm9SbnVlODNmZ1luR25LZ1hXNlls?=
 =?iso-2022-jp?B?VExvRTdCTm40UFJxdkliMWpRYUY5SzRqNVRsdE1RdTg4eitEV2ZaQzdq?=
 =?iso-2022-jp?B?ZFpDUFNyNnFEYWdOcVo5aEw3cUwrVlNyT3dST2hMQjdVMXBuSUlyL1pi?=
 =?iso-2022-jp?B?YklBYnlwWmg2YUM0WnRxTksvZ0RCaWdjcllYazh0YmVEbDJ5dXk0cCtl?=
 =?iso-2022-jp?B?UkFoNWE0cTMrN0Fkako4aDZBZTNiTGJDbE1kOUFKcy84V2FnTnNIdmd0?=
 =?iso-2022-jp?B?ZUFPaWhKaUNvTDhWbHMzQ1k4UDF6Um5oTXFCZUxlaUhjUHBqZWZwV3kz?=
 =?iso-2022-jp?B?R0YreXBLMjVmYmJ6WFZBanVqeUZ4QUhkSHRjRUw1QkFtZzFmaVBPcEpY?=
 =?iso-2022-jp?B?RkNIRFdPZDFmeHBnRW9uV25XKzM0QWIxc1Z6c0prZlFJeTdxcE41QUhB?=
 =?iso-2022-jp?B?bWRsOGhTOXZjdlA3TlhVYW1obXBta3dHQ25vd2V6N0VRNjNTV2k0K3J4?=
 =?iso-2022-jp?B?MWVDdThVODlKLzFsT1ZXWlhNdXpvcVpVTUNXYlVjUFkwbi9nZnVMUXlE?=
 =?iso-2022-jp?B?U3A4N2NDTWdNb283OXNYWkh4S1NPWEpkNUIwTi9XMllGYmZZVUpBbEt2?=
 =?iso-2022-jp?B?SlJNWWpPTktreXhFc1R5TWV2cmpMdDJPQ3hNdklSWG5GcnI3WG13MXRY?=
 =?iso-2022-jp?B?YkFyd2tGUGlTUjFvZTFDNmoxQ0ZuaTRtTGJTWC9weTFEbzdhMkUxaGc5?=
 =?iso-2022-jp?B?OWhIdHR4eFg3TFlZcHU0Q2hncXUrTjFJUDRhaVRtM0FnMkYvMDVreDZB?=
 =?iso-2022-jp?B?Si83MlhhY2YxdVZURTBHZHpTMW12blRNckFvT29HS0NrTk9qbDhKR0p1?=
 =?iso-2022-jp?B?SGp3YjhYUURyM1pPbGtoMllia3dORUN5U2FCM01XS1IyUVZTanY5blow?=
 =?iso-2022-jp?B?c1NsN1ZIWmxuMUFTYW9QcWtZYVJ1Zmk1QkxXL05yRWkxazd3NzZVOStT?=
 =?iso-2022-jp?B?M3laN2xaOHJjL3dOKzdtMlhtQitoUFpjNGJMZ0pBZ2tMY0s4emlMUjdZ?=
 =?iso-2022-jp?B?c0tzZVJoblVwMGFyV2pJQkR6RlhuVHp0bDAzNlo2OTFscm4yS0pMKzE0?=
 =?iso-2022-jp?B?TnBsKzQ0RHVpTnFDbk9ha0s0d0I4SHZYTVZldGJLZEJTekpZRkZVOEoy?=
 =?iso-2022-jp?B?MWREMTF6c2dGcTFhTEQ1dFFpUDNqdkx0eVNnM05Bb0hzemRIVnE5b01n?=
 =?iso-2022-jp?B?QUhEMGdMcDJJQWl3bGFlbkdXdHJoUVMxdiszdjYrQUR0NS9zUjhXUlhI?=
 =?iso-2022-jp?B?RWpKYUxYUHFvaEVKRjhvNkxwRkVEZ0VYMHpRd0FscktrdGZtcGphV2p5?=
 =?iso-2022-jp?B?a0Y5WERvNStyRjNLdFY1ckhKSXRBV0VlQVp2L2FKUDhYZzN1cDZnSC9E?=
 =?iso-2022-jp?B?Y0hSRg==?=
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0:
	a7cFbd9HMI2yvy0nbeBpR+9VdqMOPZF57TxiXVufFEaTCr8pvHdwbU/Izu5TkZDCuI65a4pVwerV7M5IQEtGiTuRp0JgzUcpotDyt82Bpr1/1vY+cCi3qqrzrFMJMGhlFX3VC8m+8wz4QWS9eeztekpVir7xU7Cm/qeQKQP6dv9I2nQwKGbyXZRalOu8lGimkaXDdjRMeFcSpABHLdF+xVNkcteMnR3SxydI9UnCJhysxoGKh9GEftz5t9p/vGn4cW8wcZS1MxW91bxyy/P2+HFUhqjZSkCtRJcbU/r8kEOKa6/sXda9euxWj03M+DIZ6mMo4uNCURQAyKQogulgNdQZ0JCnO5Qg79wldQDZuKQFvyo/oiYK2hZ0fZQCy4PD+JWbPptawbjLyKXHnpe7cAuielwI/qlf+Razy70yikplcgBbyBD7rOJhykANC4R6oMoIeZxcKH9tcO9Q2OfD9UhatiB4alfhe5CWJKSBZEsgEPxuQr/m6s+cKxxCmAlfO1vKOQ6i87LW8Big7cQf251JHqGvJkODJ/BjPea11ZMUrbORmJUlAT6XfLkcTyZWG2hduhKJmfKIqD510ytDHZjbL6o8i1maWCxhAYrVlmFKaIMt8VKA/8rVK31q6EO0pdxlvA+lMqzRvZOPhCp9LzJlsUt+FJE7RCi0KK73nJggdz8XtpHZmYN3puvQuuqhaYrX4ANvIs4pOfqJBS1/Bo7NMZZSsXwL/bqsgxYJwJJTiajEy5L/r++09vBUhHPEflyt9Cqj9TWoe8S/P5rZJNqcJW7PR7dl61W42A8/ceo=
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: OS0PR01MB5716.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 9f4aa178-8979-45e2-3fe8-08daf56dd636
X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Jan 2023 13:55:31.9997
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: LwO9YOcOc0uAUEPWQdymRTRCdybg+u0AYqpu1QpTu3QmOElcQbZ4kb/RbI7myBD7hh1SZt+ZapAn2NnX25kLmw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB5627
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/OS0PR01MB57163D3BF2AB42ECAA94E5C394C29%40OS0PR01MB5716.jpnprd01.prod.outlook.com>
Precedence: bulk

Hi,

I noticed one BF failure[1] when monitoring the BF for some other commit.

#   Failed test 'authentication success for method password, connstr user=
=3Dscram_role: log matches'
#   at t/001_password.pl line 120.
#                   '2023-01-13 07:33:46.741 EST [243628:5] LOG:  received =
SIGHUP, reloading configuration files
# 2023-01-13 07:33:46.742 EST [243662:1] [unknown] LOG:  connection receive=
d: host=3D[local]
# 2023-01-13 07:33:46.744 EST [243662:2] [unknown] LOG:  connection authori=
zed: user=3Dscram_role database=3Dpostgres application_name=3D001_password.=
pl
# 2023-01-13 07:33:46.748 EST [243662:3] 001_password.pl LOG:  statement: S=
ELECT $$connected with user=3Dscram_role$$
# '
#     doesn't match '(?^:connection authenticated: identity=3D"scram_role" =
method=3Dpassword)'
# Looks like you failed 1 test of 79.
[08:33:47] t/001_password.pl ........=20

After checking the test and log, I can see the test failed at the following=
 code:
----
# For plain "password" method, all users should also be able to connect.
reset_pg_hba($node, 'all', 'all', 'password');
test_conn($node, 'user=3Dscram_role', 'password', 0,
	log_like =3D>
	  [qr/connection authenticated: identity=3D"scram_role" method=3Dpassword/=
]);
----

From the log, the expected "xxx method=3Dpassword " log was not output, a s=
imple
"connection authorized: user=3Dscram_role database=3Dpostgres " was output =
Instead.
So it seems the connection happens before pg_ident.conf is actually reloade=
d ?
Not sure if we need to do something make sure the reload happen, because it=
's
looks like very rare failure which hasn't happen in last 90 days.

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dmalleefowl&dt=
=3D2023-01-13%2009%3A54%3A51

Best regards,
Hou zhijie