public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kashif Zeeshan <[email protected]>
To: Nick Renders <[email protected]>
Cc: [email protected]
Subject: Re: could not open file "global/pg_filenode.map": Operation not permitted
Date: Thu, 25 Apr 2024 13:04:57 +0500
Message-ID: <CAAPsdhcu0m8Ybk6mhSo0DGUJiq=00Lvu4SoNKzyb1aNt7Y0eAA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Hi Nick
On Thu, Apr 25, 2024 at 12:56 PM Nick Renders <[email protected]> wrote:
> Hello,
>
> We have a Postgres server that intermittently logs the following:
>
> 2024-02-26 10:29:41.580 CET [63962] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:30:11.147 CET [90610] LOG: could not open file
> "postmaster.pid": Operation not permitted; continuing anyway
> 2024-02-26 10:30:11.149 CET [63975] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:30:35.941 CET [63986] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:30:41.546 CET [63991] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:30:44.398 CET [63994] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:31:11.149 CET [90610] LOG: could not open file
> "postmaster.pid": Operation not permitted; continuing anyway
> 2024-02-26 10:31:11.151 CET [64008] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:31:41.546 CET [64023] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:32:11.150 CET [90610] LOG: could not open file
> "postmaster.pid": Operation not permitted; continuing anyway
> 2024-02-26 10:32:11.153 CET [64035] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:32:41.547 CET [64050] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:33:11.151 CET [90610] LOG: could not open file
> "postmaster.pid": Operation not permitted; continuing anyway
> 2024-02-26 10:33:11.153 CET [64062] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
> 2024-02-26 10:33:41.548 CET [64087] FATAL: could not open file
> "global/pg_filenode.map": Operation not permitted
>
>
> This has happened 3 times over the last 2 weeks now, without any
> indication what caused it.
> The privileges of those 2 files are all in order.
> When this happens, the server is no longer accessible, and we need to
> restart the service (pg_ctl restart).
> Once restarted, Popstgres runs fine again for a couple of days.
>
Hi
This issue seems to be related to the permission issue, please check your
script if it's changing the permissions.
Regards
Kashif Zeeshan
Bitnine Global
>
> We are running PostgreSQL 16.2 on macOS 14.3.1.
>
> Any idea what might be causing this issue, or how to resolve it?
>
>
> Best regards,
>
> Nick Renders
>
>
>
>
>
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: could not open file "global/pg_filenode.map": Operation not permitted
In-Reply-To: <CAAPsdhcu0m8Ybk6mhSo0DGUJiq=00Lvu4SoNKzyb1aNt7Y0eAA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox