From: Christoph Berg <myon@debian.org>
To: Tomas Vondra <tomas@vondra.me>
Cc: Jakub Wartak <jakub.wartak@enterprisedb.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: failed NUMA pages inquiry status: Operation not permitted
Date: Tue, 16 Dec 2025 15:48:38 +0100
Message-ID: <aUFxRjXb7dYj1e8P@msg.df7cb.de> (raw)
In-Reply-To: <aUFbrmKrYPBuTZ1c@msg.df7cb.de>
References: <7bbc582b-cc70-4a6f-bbf2-b5fd9b13a867@vondra.me>
<aPEHINwaAxsQNAIP@msg.df7cb.de>
<aPEJ7yH7ZJAF_MYW@msg.df7cb.de>
<aPENGAkcrLyB_NLC@msg.df7cb.de>
<a05ca971-a8ea-422f-85cd-b5edc46c5a9a@vondra.me>
<aRcmK8Bpi77yKbq1@msg.df7cb.de>
<54329add-59b6-4c08-96f0-a025a7804174@vondra.me>
<aTq5Gt_n-oS_QSpL@msg.df7cb.de>
<4ff9578d-1de2-45c1-98c4-29caf99334ff@vondra.me>
<aUFbrmKrYPBuTZ1c@msg.df7cb.de>
Re: To Tomas Vondra
> I've managed to reproduce it once, running this loop on
> 18-as-of-today. It errored out after a few 100 iterations:
>
> while psql -c 'SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa'; do :; done
>
> 2025-12-16 11:49:35.982 UTC [621807] myon@postgres ERROR: invalid NUMA node id outside of allowed range [0, 0]: -2
> 2025-12-16 11:49:35.982 UTC [621807] myon@postgres STATEMENT: SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa
>
> That was on the apt.pg.o amd64 build machine while a few things were
> just building. Maybe ENOENT "The page is not present" means something
> was just swapped out because the machine was under heavy load.
I played a bit more with it.
* It seems to trigger only once for a running cluster. The next one
needs a restart
* If it doesn't trigger within the first 30s, it probably never will
* It seems easier to trigger on a system that is under load (I started
a few pgmodeler compile runs in parallel (C++))
But none of that answers the "why".
Christoph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: myon@debian.org, tomas@vondra.me, jakub.wartak@enterprisedb.com, pgsql-hackers@lists.postgresql.org
Subject: Re: failed NUMA pages inquiry status: Operation not permitted
In-Reply-To: <aUFxRjXb7dYj1e8P@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox