Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed
Date
Msg-id 5549.1539063826@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641)failed: Identifier removed  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Raghavendra Rao J S V <raghavendrajsv@gmail.com> writes:
> Receiving below error while taking the backup using pg_dump. Please help me
> why and how to resolve this.

> pg_dump: [archiver (db)] query failed: FATAL:  semop(id=10649641) failed:
> Identifier removed

Are you running on a platform that uses systemd?  If so, see

https://www.postgresql.org/docs/current/static/kernel-resources.html#SYSTEMD-REMOVEIPC

If it's not systemd, I'd still say that something kneecapped your PG
server by removing its semaphores.  Restarting the postmaster will
clear the problem transiently, but do nothing to prevent a recurrence.

            regards, tom lane



pgsql-general by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641)failed: Identifier removed
Next
From: magodo
Date:
Subject: Re: pg9.6: no backup history file (*.backup) created on hot standby