On Tue, Aug 06, 2019 at 12:06:45PM -0500, Larry Rosenman wrote:
I'm getting the below, and am unaware of how to fix it....
11.4 on FreeBSD 12.
ler=# reindex (verbose) table dns_query ;
INFO: index "dns_query_pkey" was reindexed
DETAIL: CPU: user: 114.29 s, system: 207.94 s, elapsed: 698.87 s
ERROR: index "pg_toast_17760_index" contains unexpected zero page at
block 23686
HINT: Please REINDEX it.
CONTEXT: parallel worker
ler=# reindex index pg_toast_17760_index;
ERROR: relation "pg_toast_17760_index" does not exist
You probably need to explicitly say pg_toast.pg_toast_17760_index here,
because pg_toast schema is not part of the search_path by default.
ler=# reindex (verbose) database ler;
INFO: index "pg_class_oid_index" was reindexed
DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
INFO: index "pg_class_relname_nsp_index" was reindexed
DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
INFO: index "pg_class_tblspc_relfilenode_index" was reindexed
DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
INFO: table "pg_catalog.pg_class" was reindexed
load: 14.53 cmd: psql 2675 [select] 2765.27r 0.01u 0.01s 0% 8292k
INFO: index "dns_query_pkey" was reindexed
DETAIL: CPU: user: 112.91 s, system: 205.51 s, elapsed: 688.28 s
ERROR: index "pg_toast_17760_index" contains unexpected zero page at
block 23686
HINT: Please REINDEX it.
ler=#
Assuming the toast index is corrupted, this is kinda expected (when trying
to reindex an index on the toasted data).
The question is how much other data corruption is there ...
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
