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

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed
Date: 2018-10-09 05:31:04
Message-ID: CAEHH7R4RK5K+5tMvwpNb2=9RE23LiaeQCBV5qHvrGu0VMztj+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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: ERROR: could not open relation with
OID 14132724
pg_dump: [archiver (db)] query was: SELECT
pg_catalog.pg_get_viewdef('14132724'::pg_catalog.oid) AS viewdef
pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed:
Identifier removed
FATAL: semop(id=10649641) failed: Identifier removed
FATAL: semop(id=10649641) failed: Identifier removed
FATAL: semop(id=10649641) failed: Identifier removed
pg_dump: [archiver (db)] query was: DECLARE bloboid CURSOR FOR SELECT oid
FROM pg_largeobject_metadata
pg_dump: [archiver (db)] query failed: FATAL: semop(id=12943400) failed:
Identifier removed
FATAL: semop(id=12943400) failed: Identifier removed
FATAL: semop(id=12943400) failed: Identifier removed
FATAL: semop(id=12943400) failed: Identifier removed
pg_dump: [archiver (db)] query was: DECLARE bloboid CURSOR FOR SELECT oid
FROM pg_largeobject_metadata
pg_dump: [archiver (db)] query failed: FATAL: semop(id=15466542) failed:
Identifier removed
FATAL: semop(id=15466542) failed: Identifier removed
FATAL: semop(id=15466542) failed: Identifier removed
FATAL: semop(id=15466542) failed: Identifier removed
pg_dump: [archiver (db)] query was: DECLARE bloboid CURSOR FOR SELECT oid
FROM pg_largeobject_metadata
pg_dump: [archiver (db)] query failed: FATAL: semop(id=17432611) failed:
Identifier removed
FATAL: semop(id=17432611) failed: Identifier removed
FATAL: semop(id=17432611) failed: Identifier removed
FATAL: semop(id=17432611) failed: Identifier removed
pg_dump: [archiver (db)] query was: DECLARE bloboid CURSOR FOR SELECT oid
FROM pg_largeobject_metadata
pg_dump: [archiver (db)] query failed: FATAL: semop(id=19759139) failed:
Identifier removed
FATAL: semop(id=19759139) failed: Identifier removed
FATAL: semop(id=19759139) failed: Identifier removed
FATAL: semop(id=19759139) failed: Identifier removed
pg_dump: [archiver (db)] query was: DECLARE bloboid CURSOR FOR SELECT oid
FROM pg_largeobject_metadata

--
Regards,
Raghavendra Rao J S V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-10-09 05:43:46 Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed
Previous Message Michael Paquier 2018-10-09 03:53:34 Re: pg9.6: no backup history file (*.backup) created on hot standby