Re: How am I supposed to fix this?

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