REINDEX INDEX results in a crash for an index of pg

REINDEX INDEX results in a crash for an index of pg_class since 9.6

Title

REINDEX INDEX results in a crash for an index of pg_class since 9.6

Topic

Bug Fixes

Created

2019-04-23 07:12:54

Last modified

2019-05-11 12:03:56 (5 years, 6 months ago)

Latest email

2019-05-10 20:29:18 (5 years, 6 months ago)

Status

2019-07: Committed

Target version

Authors

Michael Paquier (michael-kun)

Reviewers

Committer

Andres Freund (andresfreund)

Links

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/2101
git checkout commitfest/cf/2101

Emails

REINDEX INDEX results in a crash for an index of pg_class since 9.6: First at 2019-04-18 01:14:30 by Michael Paquier <michael at paquier.xyz>
Latest at 2019-05-10 20:29:18 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (fix-reindex-on-pg-class-2.patch) at 2019-05-02 16:59:55 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (fix-reindex-on-pg-class-2.patch) at 2019-05-02 16:59:55 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (fix-reindex-on-pg-class.patch) at 2019-05-02 02:01:53 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (cca.diff) at 2019-05-01 17:21:15 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (locking.diff) at 2019-04-30 17:34:57 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (wip.diff) at 2019-04-26 02:02:48 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (reindex-pgclass-v1.patch) at 2019-04-23 04:56:09 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)

History

When	Who	What
2019-05-11 12:03:56	Michael Paquier (michael-kun)	Closed in commitfest 2019-07 with status: Committed
2019-05-11 12:03:56	Michael Paquier (michael-kun)	Changed committer to andresfreund
2019-04-23 07:13:01	Michael Paquier (michael-kun)	Changed authors to Michael Paquier (michael-kun)
2019-04-23 07:12:54	Michael Paquier (michael-kun)	Attached mail thread 20190418011430.GA19133@paquier.xyz
2019-04-23 07:12:54	Michael Paquier (michael-kun)	Created patch record