How am I supposed to fix this?

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: How am I supposed to fix this?
Date: 2019-08-06 17:06:45
Message-ID: fd38e05d106ec9335e4a063fb672e802@lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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: ler(at)lerctr(dot)org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2019-08-06 17:17:40 Re: Problem with default partition pruning
Previous Message Alvaro Herrera 2019-08-06 16:35:35 Re: The unused_oids script should have a reminder to use the 8000-8999 OID range