pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Alex Hunsaker <badalex@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
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, 8 Dec 2016 08:44:18 -0500
Message-ID: <589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com> (raw)
In-Reply-To: <CAFaPBrQZQ=wPy9RXpJZaE=XNg9H2xQS7Hh=JrjQ+6nqm6baDmw@mail.gmail.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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

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.)

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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



view thread (28+ messages)  latest in thread

Message-ID: <589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com>
Permalink:  ../589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com/
Also on:    postgresql.org/message-id/589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com

 · 

reply
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: peter.eisentraut@2ndquadrant.com, badalex@gmail.com, tgl@sss.pgh.pa.us, robertmhaas@gmail.com
  Subject: Re: Back-patch use of unnamed POSIX semaphores for Linux?
  In-Reply-To: <589cde75-0d41-52b7-74bc-a1069bba967b@2ndquadrant.com>

* 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