pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed
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
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