From: Tom Lane <tgl@sss.pgh.pa.us>
To: sireesha <sireesha.padmini@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Mutex error 22 - Postgres version 14
Date: Wed, 01 Feb 2023 18:02:36 -0500
Message-ID: <1428133.1675292556@sss.pgh.pa.us> (raw)
In-Reply-To: <CAAM4KK1PPc7coV80AZ6D_f=kDDC7qygnRqkXLemabj=y1Q=f=Q@mail.gmail.com>
References: <CAAM4KK3_J1bpv6ZHgZiC8_zKNrCp1AA747qUFRaL13Qubf5VKw@mail.gmail.com>
<1423181.1675289897@sss.pgh.pa.us>
<CAAM4KK1PPc7coV80AZ6D_f=kDDC7qygnRqkXLemabj=y1Q=f=Q@mail.gmail.com>
sireesha <sireesha.padmini@gmail.com> writes:
> This error is reported in Postgresql log and exact message from the log is
> below .
> 2023-01-24 02:35:45.833 PST [3424807] LOG: PID 0 in cancel request did not
> match any process
> *Error locking mutex 22*
The first of those lines comes from this bit in postmaster.c:
/* No matching backend */
ereport(LOG,
(errmsg("PID %d in cancel request did not match any process",
backendPID)));
As you can see, that would not have generated anything about a mutex.
The string "locking mutex" appears nowhere in the Postgres sources;
in fact, so far as I can find we don't use the word "mutex" in any
message whatever. So that second line is coming from something else.
Given that it's showing up in postmaster stderr, it might be coming
from libc, or from some third-party extension. But with zero context
about your system, it's hard for anyone to guess what exactly.
> Please let me know if i have to provide any other trouble report.
I take it you still didn't read the "Guide to reporting problems".
You need to err on the side of providing more information, not less.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, sireesha.padmini@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Mutex error 22 - Postgres version 14
In-Reply-To: <1428133.1675292556@sss.pgh.pa.us>
* 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