From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Alex Hunsaker <badalex@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: Back-patch use of unnamed POSIX semaphores for Linux?
Date: Thu, 08 Dec 2016 12:40:27 -0500
Message-ID: <5915.1481218827@sss.pgh.pa.us> (raw)
In-Reply-To: <589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com>
References: <32387.1481079186@sss.pgh.pa.us>
<CA+TgmoYU=Pr2A805tYLNVd4qFVKNfpYXJRRWq-YcU5bL2cdO8w@mail.gmail.com>
<4886.1481086483@sss.pgh.pa.us>
<CA+Tgmobz3KBoZ_3oDHx7zEM8QR9KpgcxPg_wRd8khB33oCKvZA@mail.gmail.com>
<27282.1481141564@sss.pgh.pa.us>
<CAFaPBrTFYV_mJyAMU0UY+vSz6KcQmzoD2va02nOD+GL9Uty-sw@mail.gmail.com>
<32665.1481150572@sss.pgh.pa.us>
<CAFaPBrQZQ=wPy9RXpJZaE=XNg9H2xQS7Hh=JrjQ+6nqm6baDmw@mail.gmail.com>
<589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> On 12/7/16 9:28 PM, Alex Hunsaker wrote:
>> Hrm, the following incantation seems to break for me on a fresh Fedora
>> 25 system:
>> 1) As root su to $USER and start postgres.
>> 2) ssh in as $USER and then logout
>> 3) # psql localhost
>>
>> FATAL: semctl(4980742, 3, SETVAL, 0) failed: Invalid argument
>> LOG: server process (PID 14569) exited with exit code 1
> Yeah, the way to trigger this is to run the postgres server not in a
> "session", then log in interactively as that same user, thus creating a
> session, and then logging out from that session, thus completely logging
> out that user from all sessions.
> (Thus, the way to trigger the KillUserProcesses behavior is quite the
> opposite, because that only happens if you have the postgres server
> running in a session.)
Ah-hah, thanks for the insight. I can now reproduce it, and I confirm
that aside from removing the semaphores, our POSIX shmem segment(s)
are removed from /dev/shm. They presumably still are attached to whatever
processes have them mapped already, but this behavior is going to break
DSM usage in any case. (The SysV shm segment does survive, presumably
because systemd notices its positive attach count.)
So I now agree that getting out from under SysV semaphores isn't going to
fix our problems with systemd ... at least, not unless we migrate *to*
not away from SysV shared memory for DSM. Even then, we'd have to be
careful that standard usage patterns keep every DSM segment continually
attached to at least one process. Dunno how practical that is. And it
blows chunks in the goal of not being constrained by SHMMAX.
Oh well.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter.eisentraut@2ndquadrant.com, badalex@gmail.com, robertmhaas@gmail.com
Subject: Re: Back-patch use of unnamed POSIX semaphores for Linux?
In-Reply-To: <5915.1481218827@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