search

cloudfoundry / postgres-release

BOSH release for PostgreSQL
Apache License 2.0
14 stars 36 forks source link

could not open shared memory segment error in v46 #73

Closed jpalermo closed 1 year ago

jpalermo commented 1 year ago

psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL: could not open shared memory segment "/PostgreSQL.231763232": No such file or directory

The issue seems to be documented here and can be worked around by adding RemoveIPC=no to /etc/systemd/logind.conf and then systemctl restart systemd-logind.service

Not sure if we want to add that to the pre-start script, or figure out a better way to solve this problem.

cf-gitbot commented 1 year ago

We have created an issue in Pivotal Tracker to manage this:

https://www.pivotaltracker.com/story/show/185855262

The labels on this github issue will be updated when the story is started.

jpalermo commented 1 year ago

We've got a PR in progress for jammy stemcells to resolve the issue there.

For now, you can work around this by using the pre-start-script job of os-conf-release and using this as the script property:

echo 'RemoveIPC=no' >> /etc/systemd/logind.conf
systemctl restart systemd-logind.service
jochenehret commented 1 year ago

Automatic update of the postgres-release is currently failing: https://concourse.wg-ard.ci.cloudfoundry.org/teams/main/pipelines/update-releases/jobs/update-postgres/builds/6 We'll wait for the proposed fix and then try again.

jpalermo commented 1 year ago

Looks like the fix in Jammy 1.222 has resolved the problem.