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
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=#
ler=# select version();
version
-----------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 11.4 on amd64-portbld-freebsd12.0, compiled by FreeBSD clang
version 8.0.0 (tags/RELEASE_800/final 356365) (based on LLVM 8.0.0),
64-bit
(1 row)
ler=#
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
