Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vpxf3-001yGh-13 for pgsql-admin@arkaria.postgresql.org; Wed, 11 Feb 2026 00:00:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpxf1-001dJP-0c for pgsql-admin@arkaria.postgresql.org; Wed, 11 Feb 2026 00:00:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vpxf0-001dJF-19 for pgsql-admin@lists.postgresql.org; Wed, 11 Feb 2026 00:00:51 +0000 Received: from mail-westcentralusazolkn190130001.outbound.protection.outlook.com ([2a01:111:f403:d123::1] helo=CY3PR05CU001.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vpxew-000000002ed-20aD for pgsql-admin@lists.postgresql.org; Wed, 11 Feb 2026 00:00:48 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=oUGPH3RrKiIh8LQ/RvNWahoYJC6pZRBLVgXmTS7cKHFQv5esxLZ/PrNYr3unE5eVAIN2c4lMR5P+WPWGQH6aYCC/Qil6UAnXPXxX/lYPXMqJsvwJeP2Ax/Q3cCcgkPEzFhEKTC5Ovd2SNVEtmGeKxSkbgvp0o4gOFggo9Dn8M2qO7maa3P8EoU1KVApjcBSsVnScqD1zWmpTeCMrc52Xi1Ne5spqplORnBVYZIFB005R2OuxIw4htrg6VFqeEecLqs9Xijdwfnx+DdZznOtkOfco1gW7YLWWIsGN7AikQtdYCxi0KQZw7ksrEc5N4i9Jeik0+H3Bl91Fvtb+vMgy+w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=dyNI8H873a9FznETOgI3PuUKWI6vuyRn3ONnwXiB3aI=; b=f9S+zHDcvNSWAKkUFSYxUe2whArcBs+e9S+f2AQ7yMqEioz/nXODbun/8anT+YTKK2sZaP1iAMy9eILXMD3sEr65yd8xxa3cQGEgQ1TmbXh/MluN6cy3DnKHlpX4T7udyztFAacid8iWwSQGfhZ1S2/U7PYhxrQKPyevn+PiYIu5tj6KzxMWOfbjcX+t/OAdLIT/u2smzhugG+1rQfbzz87OIq2XF/IDLqCq9jbrwCRiYMEYeyv8+lSt3jpoQL4ii+qATSh0cF0ExCraVb7KU7tSBh7FrD4qkVtIJ3yH9Q8JkUKlir2CvnZ+P3TH6s+5qBWSwswTLnJdQ99Stecw4w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=dyNI8H873a9FznETOgI3PuUKWI6vuyRn3ONnwXiB3aI=; b=IHgwGHVjgAMetkfanMTP9TimMqcFa6J/9OjnqvkNxPietG+8CNnerTj57anFu01X1zU7VPhTtdl04UhvPnQnXFNl/3xCo0MUwFKwMiTWnsC1AtONazmZMqYe/Re+Fd72CuQDiVEM/nJlO6RU67VIsZ6EM3RDzIMeayk9Sqsp7Y8LGEkADiTgKQdb070baPDhf9QTTl1Z2FZYUCAChJAr0v121T+egIcJRLEme2dwNruhplkKiagjK3oI+1DRGYiXfto56QwXEW2JpsC+kPSzatV2yixnEMBfb83dZ6DzupZHa1RMurXmrE0RO0Ko0yehtwvhOkMDJ/4mryY4YHtbfA== Received: from SN7P223MB0580.NAMP223.PROD.OUTLOOK.COM (2603:10b6:806:26c::22) by BN0P223MB0310.NAMP223.PROD.OUTLOOK.COM (2603:10b6:408:147::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9611.8; Wed, 11 Feb 2026 00:00:43 +0000 Received: from SN7P223MB0580.NAMP223.PROD.OUTLOOK.COM ([fe80::e0cd:d81f:dcbe:7c96]) by SN7P223MB0580.NAMP223.PROD.OUTLOOK.COM ([fe80::e0cd:d81f:dcbe:7c96%5]) with mapi id 15.20.9611.006; Wed, 11 Feb 2026 00:00:43 +0000 From: Aislan Luiz Wendling To: Scott Ribe , Pgsql-admin Subject: Re: debug a lockup Thread-Topic: debug a lockup Thread-Index: AQHcmrHRWC0Ormh/HkSPUbnIHTD3E7V8mvNd Date: Wed, 11 Feb 2026 00:00:43 +0000 Message-ID: References: <62854B1F-FE6F-47BD-8B8C-5BEAA33EE3AD@elevated-dev.com> In-Reply-To: <62854B1F-FE6F-47BD-8B8C-5BEAA33EE3AD@elevated-dev.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SN7P223MB0580:EE_|BN0P223MB0310:EE_ x-ms-office365-filtering-correlation-id: 70391e79-11b5-4ccd-6ceb-08de690099d7 x-microsoft-antispam: BCL:0;ARA:14566002|12050799012|461199028|8060799015|8062599012|15080799012|15030799006|19110799012|9400799043|31061999003|10035399007|440099028|3412199025|4302099013|102099032|1602099012|52005399003|40105399003; x-microsoft-antispam-message-info: =?iso-8859-1?Q?pm16UCshs2S4SjmzUWLgE/Uqin4IHyVWD1gIIbQo2xZg4V2dyzSvIRf08W?= =?iso-8859-1?Q?hv0BvRChV+wWn/ZC+H1ahYx1ffYZyhpYu8+h4pUPPwrM+/Ef4YIl1+gCES?= =?iso-8859-1?Q?Hzega3P2o5iR8i3O8qoyShHjL7pVlqWIsHXMgFmmFlNV8RaCLFfC8/E85M?= =?iso-8859-1?Q?OEuhJi724vbrXmUx6RkQTnEB5U6q8nfSdbsB/fdpEDNGNDE9CzW/XLv0h6?= =?iso-8859-1?Q?IXBbpNYvrseBrANmDHBt3DJbpQUV0kD/Ao0MdKNbR/+bKayx8ZiNB/Flmu?= =?iso-8859-1?Q?9PK5xO9SiOXWA8/OqhC3Gx+A9XZI9aXrnRPxrfJn4Yw6kNhM2X/+uelDIK?= =?iso-8859-1?Q?W+zFS0fEArKqtqpaOK4NGYAXdF7F/EzGmCqYd39ozZcE0zWYbpxUSQu0T6?= =?iso-8859-1?Q?qIwYo6EReihQd6KUB+rpWIyK5Y50zEknC6e22JleiAjcHnV/Upp5lz/xhA?= =?iso-8859-1?Q?9xNYDJbzk+7TBqQSgLtS0nLyVzDNt8qaXAl0Htme2PHUgCjOQ+ivFbpcbQ?= =?iso-8859-1?Q?YK6h/CB7+j30mAYl/frKL4q9/AM1vQoR0GlR/LQu/reXeV0mP3k06ODi79?= =?iso-8859-1?Q?GkWVsu23Hrxk96r4vBr4aIzz5RJWuKieIEBbPmmidBY4EBT57yHTZloxNm?= =?iso-8859-1?Q?cO9k8kL9J/VlvspRUi+lK5oMQgYqee6MEwAFNWHvusgAZLxXYACsdNoZvO?= =?iso-8859-1?Q?teflaqzGa2bHnJQdfGXjVmzXKpfCIQAFTK8RBOEbr56yoyzr1fGiBtHIC0?= =?iso-8859-1?Q?g3QL/ICPM6iQ8cHCBq9n+7VjNUo/PGezTdxeFtJOk6ouifzQ+Gm5QjBUQB?= =?iso-8859-1?Q?02xEe4Wk6MWLJb2clnShYDSPD/TR1uYzmEu5W6YVDHyBDBv3u3ujUPRnqC?= =?iso-8859-1?Q?3x5Uw5MHHxGqcFxhibDjj6d7J2W/PiWt+BD3sYI2nki8a8PO1FtSevpZ5i?= =?iso-8859-1?Q?oafYNz59Jv1UDhQ+m2TOM0l82G9FolXT6D6X5qruQfYqqVxYZUX8/5kGSb?= =?iso-8859-1?Q?o37SmKs1KQRRRrlYUOs0sL4NhIl9n+xHoEgXlZeAaB6etitiZhnIWIZQGf?= =?iso-8859-1?Q?wqcfoHYrMtMUBlQFRiR8zlvRtp9ehX+0DTP18sxCmn65WM5xG75+/oVJvD?= =?iso-8859-1?Q?f4+QIcj8V0u/SVbN6Bb98Ky6UyavPEQVSuDNl+GrKxCIsSYKVegxeBpCEp?= =?iso-8859-1?Q?+0bVlbaC8Y0WN49+judVAK4+FzWSZ4Ji2xX7Zkr6+wxCxGIU7ywFdE3Yex?= =?iso-8859-1?Q?lXPWOV0humUlo0iWtM6sVSQvPvLsnJvpiqvNJ7y1MTWvJEPISXhBi9tgRI?= =?iso-8859-1?Q?3M5gEaYehwDQLlvU9wj7OJP7WugavVOdxZNScDp05lIXEeaS4EjNwgBgP+?= =?iso-8859-1?Q?bcZUodczVLP9V9+RlLcM3rZBcPYI4k3BNCGLsYIKN5fe0Hlg108W8=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?IwSru2pMYzzWzSg2BwRLtgEn8IneDZTXaidwMQC7WJZws0O3m+/ilmd8q8?= =?iso-8859-1?Q?JjwMf1xYZ02Np6/69bPo6h8IxLxOYhzDmnJoPIQSpU+BpjOZHluCunYE4/?= =?iso-8859-1?Q?TDBiGF1E9DX+RIB6ZmAEqDdvd+Sr9hlJfp/0Rz/8lkIrLeNU2dRT/fLVt8?= =?iso-8859-1?Q?u1GjfQf7sZKl0ngEMeT3+TtvELPz1tJ1CgixcWuASBwL9IoAuFwpnVbluj?= =?iso-8859-1?Q?eb435w69zvRVW17htwMyEArUb9Oa5xlrnmrwFO6jH5L/2ieDHhR/eaJr9G?= =?iso-8859-1?Q?KT58VqkNCnfzTDMx4w6k8xesffQBj0mCwyn2u+dn61XyltJ9CoR02IAX0K?= =?iso-8859-1?Q?5KA1dPTsyQTl1e2JS7pv1r2ep+/9V47vkNYIXCAix79fgWyoSs0KPSwiap?= =?iso-8859-1?Q?zKOxYepfRFf7pVWRhnfcXM/XQjppqejy6A3VzI6+bWcXHfAhkBtlUGO6CQ?= =?iso-8859-1?Q?aVCBJtT8wBq5wqfSnTcshBhwLA77nscY/PZVz7kY1V+INTikC/WX2SURn5?= =?iso-8859-1?Q?Vs+99H56/LLTmfCGGa4QVkgsgx1Q+GLgOKLKTtcUTrezgnDMdLQB8FLKo6?= =?iso-8859-1?Q?wKvtVZ774JscVpCHZZa9KhxrxMrM0oQ/2rQ1QBYeoQLjnkG/JH+iR7iVyW?= =?iso-8859-1?Q?rWNw5kCloPQIoou3ff2MHhNL+g85IFEUshBfIBzJBHC/Yo1hOUUbuKexaz?= =?iso-8859-1?Q?w34/Hw8UROYnLZNHMK7+QbaOqnO5qTEtonCcELP4VmFsUXLRe1Ib2/KwL8?= =?iso-8859-1?Q?kzt2K5fgGn8822WB9TkhQrA7PDYgAA9YpmahG2w83wfoNNloy5We+jdyeq?= =?iso-8859-1?Q?00yl5IXaryaXR5K1p8TuNYygBk8M/kne+RCUjnNv4QJsh8ACTmTGpUvHGK?= =?iso-8859-1?Q?1rCBPXFYBddP/sKyq5y8wgb1eu1//kRC58d8bjcJKKPEWgDaudLx/6R4CQ?= =?iso-8859-1?Q?vuzPZeSwaFFMTM9QFWQzl/Agu5z0RXO9LnlYqQlLusVyy8ZqHXSEFPBUQ2?= =?iso-8859-1?Q?Vi8Tl38pr3H7368vQG8YghS0Zqbbre0wK/Qorl3R/jGYPiU7bVz5ip7bZJ?= =?iso-8859-1?Q?UNd8EXJC17BODczyTyub7HdWlDpT76tn9ahynGoSi60U4r4J1KBZBZcasO?= =?iso-8859-1?Q?5hKw7akRxhllSfeG/N0Tqv74qlZlHljVjk+tQUSIArcbhRy3oexr62uGe6?= =?iso-8859-1?Q?0TNmm2dDvupWr+WYBBQSA1Es5i2nhlZp1m0cSRNNnQVsFIPPC5WyurxItX?= =?iso-8859-1?Q?bY8SmjGFBzNg8GnLZuSzNvkv/nds6g2ssbOTtY+pZgcOugdGVDmad2SfVd?= =?iso-8859-1?Q?l+sofjisqqS5e4HTw+/oLsS3Yw7v1/fNYCMC6Egyyu85vxEYk9WoUv1uYL?= =?iso-8859-1?Q?W4uIlYUz1RB9b8ttxW/kd2UH/aS61VwSCDn/shGepGR95ywc9YQBUXd2Zr?= =?iso-8859-1?Q?Nz28P2dhnareM9tTgxdLdmXwAaWY5BUtRgcpwQ=3D=3D?= Content-Type: multipart/alternative; boundary="_000_SN7P223MB05809AA60554BD2253269B6DDD62ASN7P223MB0580NAMP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-9412-4-msonline-outlook-1679e.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SN7P223MB0580.NAMP223.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 70391e79-11b5-4ccd-6ceb-08de690099d7 X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Feb 2026 00:00:43.4664 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN0P223MB0310 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SN7P223MB05809AA60554BD2253269B6DDD62ASN7P223MB0580NAMP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Does it repeat on every run? If it is possible, try to gracefully stop postgresql. Not working? Try stop immediate and last resort stop abort. If postgrres service does not stop, try to kill pgbench process. First try kill -15 and if it does not work, kill -9 Nothing works, reboot the vm. Open two terminals, start pgbench process in one. In the other ps -ef | gre= p pgbench Find the parent process ID and do a strace -f -p (maybe your kernel h= as a different syntax, but it is to trace a process and its forks) It can show which set of instructions is waiting. You will know because usu= ally you are not able to read due to its speed, but when it stops, it is wa= iting for something. Hope it helps. ALW ________________________________ From: Scott Ribe Sent: Tuesday, February 10, 2026 11:55 AM To: Pgsql-admin Subject: debug a lockup PostgreSQL appears locked up. pgbench run that should have completed in a f= ew seconds has been running 14 hours. psql invocation locks up. No CPU usa= ge showing in top. I personally suspect infra issues. (k8s pod, Pure block storage) But I'm ge= tting pushback pointing the finger at PG. It's 18.1, and pgbench is the onl= y client FWIW. Any way to introspect the current non-debug build to get a clue what's goin= g on in there? -- Scott Ribe scott_ribe@elevated-dev.com https://www.linkedin.com/in/scottribe/ --_000_SN7P223MB05809AA60554BD2253269B6DDD62ASN7P223MB0580NAMP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,

Does it repeat on every run?

If it is possible, try to gracefully stop postgresql.

Not working? Try stop immediate and last resort stop abort.

If postgrres service does not stop, try to kill pgbench process.
First try kill -15 <pgbench PID> and if it does not work, kill -9

Nothing works, reboot the vm.

Open two terminals, start pgbench process in one. In the other ps -ef | gre= p pgbench

Find the parent process ID and do a strace -f -p <PID> (maybe your ke= rnel has a different syntax, but it is to trace a process and its forks)

It can show which set of instructions is waiting. You will know because usu= ally you are not able to read due to its speed, but when it stops, it is wa= iting for something.


Hope it helps.

ALW
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Tuesday, February 10, 2026 11:55 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: debug a lockup
 
PostgreSQL appears locked up. pgbench run t= hat should have completed in a few seconds has been running  14 hours.= psql invocation locks up. No CPU usage showing in top.

I personally suspect infra issues. (k8s pod, Pure block storage) But I'm ge= tting pushback pointing the finger at PG. It's 18.1, and pgbench is the onl= y client FWIW.

Any way to introspect the current non-debug build to get a clue what's goin= g on in there?

--
Scott Ribe
scott_ribe@elevated-dev.com
ht= tps://www.linkedin.com/in/scottribe/





--_000_SN7P223MB05809AA60554BD2253269B6DDD62ASN7P223MB0580NAMP_--