Feedback-ID: i0fe9450f:Fastmail
Date: Mon, 6 Apr 2026 15:19:57 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Andres Freund <andres@anarazel.de>
Cc: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>,
	Jeff Davis <pgsql@j-davis.com>,
	Greg Sabino Mullane <htamfids@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: Adding locks statistics
Message-ID: <adNQjbY7QvWe_W4m@paquier.xyz>
References: <hlkdrplgrmudbspibsuq6xooxrqxqsgwo6x5b6x5ptvkgjbe7w@xogt6xgua6dz>
 <acMiT69EEGKHWGM5@paquier.xyz>
 <acNTR1lLHwQJ0o+P@ip-10-97-1-34.eu-west-3.compute.internal>
 <acNxrWn2bvDARnC3@paquier.xyz>
 <acQ9gnE84897xHfQ@ip-10-97-1-34.eu-west-3.compute.internal>
 <acRqbLtT-aJDRSRl@paquier.xyz>
 <acSwlC46/WhYZuy5@ip-10-97-1-34.eu-west-3.compute.internal>
 <acTX8bbXh9lgOvZL@paquier.xyz>
 <adL4u897hLceqYmc@paquier.xyz>
 <rp6wz4lnz5qn4zlh7uxtavzfrmqvycy2g42z4zasfss2gxi54f@zzcsjdvdflwp>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="oO+QiBsRhwn8HFVf"
Content-Disposition: inline
In-Reply-To: <rp6wz4lnz5qn4zlh7uxtavzfrmqvycy2g42z4zasfss2gxi54f@zzcsjdvdflwp>
Archived-At: 
 <https://www.postgresql.org/message-id/adNQjbY7QvWe_W4m%40paquier.xyz>
Precedence: bulk


--oO+QiBsRhwn8HFVf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Apr 06, 2026 at 01:22:23AM -0400, Andres Freund wrote:
> https://cirrus-ci.com/task/6253659454963712
> https://api.cirrus-ci.com/v1/artifact/task/6253659454963712/testrun/build=
/testrun/test_misc/011_lock_stats/log/regress_log_011_lock_stats
>=20
> [04:33:31.756](0.067s) # die: error running SQL: 'psql:<stdin>:1: ERROR: =
 could not detach injection point "deadlock-timeout-fired"'

I got a way to reproduce the same error pattern with the following
trick:
--- a/src/backend/utils/misc/injection_point.c
+++ b/src/backend/utils/misc/injection_point.c
@@ -357,6 +357,8 @@ InjectionPointDetach(const char *name)
    int         idx;
    int         max_inuse;

+   pg_usleep(5 * 1000000L);
+
    LWLockAcquire(InjectionPointLock, LW_EXCLUSIVE);

Now looking at it, and for the reason why 010 for concurrent indexes
does not complain..
--
Michael

--oO+QiBsRhwn8HFVf
Content-Type: application/pgp-signature; name=signature.asc

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

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnTUI0ACgkQnvQgOdby
QH0N0Q//Yq+VAYVwnh/M1926aiXKJg+6ivu4dowTYOIxK9jJXPJ3gtMAbXDbyGZV
Vco9Ny6mO8urqQqqZ+3qy3p1hOMTZH0WHv/Oxxw3noemYXtJnPgpzTSkDl/Wx6RA
OCjazucsjYMgZrCcwCdXE3FCsgq19P9rJKM9YVz2mkS5/iam/MQcRUVYJSNR7w1b
bm8WI/b+AAUYn/aJGvxN+gFK7389Gzai/OvNYfXjdGsoZtRr8qM2Clyy4kA7H+o2
x6tvsS4v9MUVJMLaP5d4D94iim27ZVTe31RiMIKKHOBZwRWT6T/cxuMe4Pag4ip5
m9F7RPgIwXUhHmo68eXxXe4lthrSegVK9YDQ2sp7hDAIOKcUO1sUMIgPe0Zx3guz
IKyP3mkLm3hs3c4RIwnzCugwHQaU89KtCXIDozG6TkRHbiO5EcA6Y0i1Yb5u0GKl
dHXpR2JBvZG3hdn4HhWf8t6hgVLzfqiWlSchHMJ3ZdDupQtbMQHPZxs9cm3LiSjl
unjeS+B1SesygjQRlo93mIa+cgShuy0SNs8bw58Hc2DD6+lXWRS3b1HnpgoBj+ql
2h7d5kiFku0YyOSclgig2oRrJI9W2+MR4HXSTHcmwWhJSFyiiZ5A2kEWAz6thPWX
9TBcjmwOrxPwIlnAJRKc2mj//6hRFtuw+WKOWcbp6H0+w0912bs=
=xbME
-----END PGP SIGNATURE-----

--oO+QiBsRhwn8HFVf--