Fix handling of invalid index on TOAST tables during reindex

2479

Title

Topic

Bug Fixes

Created

2020-02-26 13:08:40

Last modified

2020-03-10 06:53:57 (4 years, 8 months ago)

Latest email

2020-03-13 16:58:25 (4 years, 8 months ago)

Status

2020-03: Committed

Target version

Authors

Julien Rouhaud (rjuju)

Reviewers

Michael Paquier (michael-kun)Become reviewer

Committer

Michael Paquier (michael-kun)

Links

CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2479
git checkout commitfest/cf/2479

Emails

reindex concurrently and two toast indexes: First at 2020-02-16 19:08:35 by Justin Pryzby <pryzby at telsasoft.com>
Latest at 2020-03-13 16:58:25 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v2-0001-Add-an-optional-cancel-on-clause-to-isolationtest.patch) at 2020-03-10 13:53:36 from Julien Rouhaud <rjuju123 at gmail.com>
    Attachment (v2-0001-Add-an-optional-cancel-on-clause-to-isolationtest.patch) at 2020-03-10 13:53:36 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-isolation-test-to-check-dependency-handling-of-i.patch) at 2020-03-10 03:09:42 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v2-0001-Forbid-reindex-of-invalid-indexes-on-TOAST-tables.patch) at 2020-03-09 05:52:31 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Add-an-optional-timeout-value-to-isolationtester-ste-v1.patch) at 2020-03-06 13:15:47 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (0001-Don-t-reindex-invalid-indexes-on-TOAST-tables-v4.patch) at 2020-03-06 12:36:48 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (0001-Don-t-reindex-invalid-indexes-on-TOAST-tables-v3.patch) at 2020-03-05 16:57:07 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (reindex-deps-v3.patch) at 2020-03-04 05:15:10 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (reindex-deps-v2.patch) at 2020-03-03 09:25:51 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (reindex-deps-v1.patch) at 2020-03-03 08:06:42 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Don-t-reindex-invalid-indexes-on-TOAST-tables-v2.patch) at 2020-02-22 15:06:57 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (0001-Don-t-reindex-invalid-indexes-on-TOAST-tables-v1.patch) at 2020-02-22 07:09:24 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)

History

When	Who	What
2020-03-10 06:53:57	Michael Paquier (michael-kun)	Closed in commitfest 2020-03 with status: Committed
2020-03-10 06:53:57	Michael Paquier (michael-kun)	Changed committer to michael-kun
2020-02-27 07:32:30	Michael Paquier (michael-kun)	Added michael-kun as reviewer
2020-02-26 13:09:03	Julien Rouhaud (rjuju)	Changed authors to Julien Rouhaud (rjuju)
2020-02-26 13:08:41	Julien Rouhaud (rjuju)	Attached mail thread 20200216190835.GA21832@telsasoft.com
2020-02-26 13:08:40	Julien Rouhaud (rjuju)	Created patch record