From: | Thomas RAFFIN <traffin(at)sirap(dot)fr> |
---|---|
To: | pgsql-fr-generale(at)postgresql(dot)org |
Subject: | Réparer pg_depend |
Date: | 2015-10-05 12:42:15 |
Message-ID: | 56127027.6080508@sirap.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-fr-generale |
Bonjour,
Un dump de ma BDD à planté il y a peu. Voilà l'erreur :
ERROR: invalid page in block 252 of relation base/24585/12003
STATEMENT: SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind,
c.relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid =
c.relowner) AS rolname, c.relchecks, c.relhastriggers, c.relhasindex,
c.relhasrules, c.relhasoids, c.relfrozenxid, c.relminmxid, tc.oid AS
toid, tc.relfrozenxid AS tfrozenxid, tc.relminmxid AS tminmxid,
c.relpersistence, c.relispopulated, c.relreplident, c.relpages, CASE
WHEN c.reloftype <> 0 THEN c.reloftype::pg_catalog.regtype ELSE NULL END
AS reloftype, d.refobjid AS owning_tab, d.refobjsubid AS owning_col,
(SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS
reltablespace,
array_to_string(array_remove(array_remove(c.reloptions,'check_option=local'),'check_option=cascaded'),
', ') AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions)
THEN 'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions)
THEN 'CASCADED'::text ELSE NULL END AS checkoption,
array_to_string(array(SELECT 'toast.' || x FROM unnest(tc.reloptions)
x), ', ') AS toast_reloptions FROM pg_class c LEFT JOIN pg_depend d ON
(c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND
d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype = 'a') LEFT
JOIN pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.relkind in ('r',
'S', 'v', 'c', 'm', 'f') ORDER BY c.oid
J'ai donc cherché ce qui n'allait pas :
select relfilenode,relname from pg_class where relfilenode = 12003
=> 12003;"pg_depend"
En voulant reindexer :
REINDEX TABLE pg_depend;
=> ERROR: invalid page in block 252 of relation base/24585/12003
OS : Windows 2012 R2 64bits
PG : "PostgreSQL 9.4.4, compiled by Visual C++ build 1800, 64-bit"
Merci de votre aide.
--
Envoi via la liste pgsql-fr-generale (pgsql-fr-generale(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Flavio Henrique Araque Gurgel | 2015-10-05 13:04:07 | Re: Réparer pg_depend |
Previous Message | Dimitri Fontaine | 2015-09-27 19:08:00 | Re: Lib python pour lire pg_catalog |