Re: BUG #14594: postgres dies with fatal error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gnareshdba(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14594: postgres dies with fatal error
Date: 2017-03-21 15:02:56
Message-ID: 31585.1490108576@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message gnareshdba 2017-03-21 19:47:14 BUG #14595: postgres dies with fatal error
Previous Message John R Pierce 2017-03-21 08:32:52 Re: BUG #14594: postgres dies with fatal error