Diagnose !indisvalid in more SQL functions.
Noah Misch <noah@leadboat.com>
Diagnose !indisvalid in more SQL functions. pgstatindex failed with ERRCODE_DATA_CORRUPTED, of the "can't-happen" class XX. The other functions succeeded on an empty index; they might have malfunctioned if the failed index build left torn I/O or other complex state. Report an ERROR in statistics functions pgstatindex, pgstatginindex, pgstathashindex, and pgstattuple. Report DEBUG1 and skip all index I/O in maintenance functions brin_desummarize_range, brin_summarize_new_values, brin_summarize_range, and gin_clean_pending_list. Back-patch to v11 (all supported versions). Discussion: https://postgr.es/m/20231001195309.a3@google.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pgstattuple/pgstatindex.c | modified | +26 −0 |
| contrib/pgstattuple/pgstattuple.c | modified | +7 −0 |
| src/backend/access/brin/brin.c | modified | +21 −6 |
| src/backend/access/gin/ginfast.c | modified | +20 −3 |
Discussion
- pgstatindex vs. !indisready 10 messages · 2023-10-01 → 2023-10-23