Re: [BUGS] BUG #14594: postgres dies with fatal error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14594: postgres dies with fatal error
Date
Msg-id 31585.1490108576@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14594: postgres dies with fatal error  (gnareshdba@gmail.com)
List pgsql-bugs
gnareshdba@gmail.com writes:
> Operating system:   RHEL 7.2

> postgresql (9.4.5) instance restarts with below error during backup times

> 2017-03-19 19:00:21 EDT PANIC: semop(id=152698887) failed: Invalid argument

You need to prevent systemd from deleting Postgres' semaphores.
See the discussion of RemoveIPC here:

https://wiki.postgresql.org/wiki/Systemd

> on RHEL 7.2, and UID set to (id -u postgres) 2011

That's not the UID typically used on RHEL for Postgres, which is probably
why systemd doesn't know to exempt it from RemoveIPC.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: [BUGS] BUG #14594: postgres dies with fatal error
Next
From: gnareshdba@gmail.com
Date:
Subject: [BUGS] BUG #14595: postgres dies with fatal error