Re: Mutex error 22 - Postgres version 14

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sireesha <sireesha(dot)padmini(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Mutex error 22 - Postgres version 14
Date: 2023-02-01 23:02:36
Message-ID: 1428133.1675292556@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

sireesha <sireesha(dot)padmini(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Geoghegan 2023-02-02 00:14:21 Re: Mutex error 22 - Postgres version 14
Previous Message David G. Johnston 2023-02-01 22:52:33 Re: Mutex error 22 - Postgres version 14