Postgres Pro
Downloads
Home   >   mailing lists

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

From Raghavendra Rao J S V
Subject pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641)failed: Identifier removed
Date
Msg-id CAEHH7R4RK5K+5tMvwpNb2=9RE23LiaeQCBV5qHvrGu0VMztj+g@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg9.6: no backup history file (*.backup) created on hot standby
Next
From: Tom Lane
Date:
Subject: Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed