pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: Diagnose !indisvalid in more SQL functions.
7+ messages / 1 participants
[nested] [flat]

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/0a7b183fdc1bbd221acf88b03ee4b4cfd23e0abe

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e633e9b132ffda7f4afd9248c7385bdd282d32d4

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/123b0d1115113eb8322e1d4899f951733ce548ba

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/13503eb5905b51d22d86a3c2065c241a61cedd44

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/975ae05537fadcba6ea55b781b142eef887e6ffe

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/bae063db499fbe29b62a18fe3a9227a59ca2ef0f

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Diagnose !indisvalid in more SQL functions.
@ 2023-10-30 21:47  Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Noah Misch @ 2023-10-30 21:47 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/1a368dd3ecefef041721628baf9564862088c377

Modified Files
--------------
contrib/pgstattuple/pgstatindex.c | 26 ++++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple.c |  7 +++++++
src/backend/access/brin/brin.c    | 27 +++++++++++++++++++++------
src/backend/access/gin/ginfast.c  | 23 ++++++++++++++++++++---
4 files changed, 74 insertions(+), 9 deletions(-)



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2023-10-30 21:47 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>
2023-10-30 21:47 pgsql: Diagnose !indisvalid in more SQL functions. Noah Misch <noah@leadboat.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox