How am I supposed to fix this?
От | Larry Rosenman |
---|---|
Тема | How am I supposed to fix this? |
Дата | |
Msg-id | fd38e05d106ec9335e4a063fb672e802@lerctr.org обсуждение исходный текст |
Ответы |
Re: How am I supposed to fix this?
Re: How am I supposed to fix this? |
Список | 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@lerctr.org US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
В списке pgsql-hackers по дате отправления: