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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed
Date: 2018-10-09 05:43:46
Message-ID: 5549.1539063826@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message magodo 2018-10-09 07:26:35 Re: pg9.6: no backup history file (*.backup) created on hot standby
Previous Message Raghavendra Rao J S V 2018-10-09 05:31:04 pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed