From: | "Benjamin Arai, Ph(dot)D(dot)" <benjamin(at)araisoft(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157" |
Date: | 2010-09-21 20:32:40 |
Message-ID: | AANLkTi=dR5V2Yx8T7w40yqTYcqv8Qg1iiJ6z2VpQ0xmU@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
The server is still running but pg_dumps output the following error. What
should I do?
Thanks,
Benjamin
OUTPUT:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: cache lookup failed for index
1531353157
pg_dump: The command was: SELECT t.tableoid, t.oid, t.relname as indexname,
pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, t.relnatts as
indnkeys, i.indkey, i.indisclustered, c.contype, c.conname, c.tableoid as
contableoid, c.oid as conoid, (SELECT spcname FROM pg_catalog.pg_tablespace
s WHERE s.oid = t.reltablespace) as tablespace FROM pg_catalog.pg_index i
JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) LEFT JOIN
pg_catalog.pg_depend d ON (d.classid = t.tableoid AND d.objid = t.oid AND
d.deptype = 'i') LEFT JOIN pg_catalog.pg_constraint c ON (d.refclassid =
c.tableoid AND d.refobjid = c.oid) WHERE i.indrelid =
'1531340182'::pg_catalog.oid ORDER BY indexname
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2010-09-21 20:57:30 | Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157" |
Previous Message | Benjamin Arai, Ph.D. | 2010-09-21 20:24:00 | pg_dump fails with "ERROR: cache lookup failed for index 1531353157" |