VACUUM, TRUNCATE, REINDEX -- Canceling authentication due to timeout aka Denial of Service Attack

Edit

Title

Topic

Bug Fixes

Created

2018-07-26 05:36:03

Last modified

2018-08-27 00:17:47 (5 years, 8 months ago)

Latest email

2018-08-29 01:34:41 (5 years, 8 months ago)

Status

2018-09: Committed

Target version

Authors

Michael Paquier (michael-kun)

Reviewers

Kyotaro Horiguchi (horiguti), Nathan Bossart (bossartn)Become reviewer

Committer

Michael Paquier (michael-kun)

Links

Emails

BUG #15182: Canceling authentication due to timeout aka Denial of Service Attack: First at 2018-04-30 20:41:11 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2018-08-29 01:34:41 by Michael Paquier <michael at paquier.xyz>
Latest attachment (reindex-priv-93.patch) at 2018-07-30 00:34:22 from Michael Paquier <michael at paquier.xyz>
    Attachment (reindex-priv-93.patch) at 2018-07-30 00:34:22 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0002-idea.patch) at 2018-07-27 14:40:42 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0001-Refactor-TRUNCATE-execution-to-avoid-early-lock-look.patch) at 2018-07-27 02:31:23 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Refactor-TRUNCATE-execution-to-avoid-early-lock-look.patch) at 2018-07-26 05:24:16 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
REINDEX and shared catalogs: First at 2018-08-05 21:10:59 by Michael Paquier <michael at paquier.xyz>
Latest at 2018-08-09 07:56:07 by Michael Paquier <michael at paquier.xyz>
Latest attachment (reindex-priv-93.patch) at 2018-08-05 21:10:59 from Michael Paquier <michael at paquier.xyz>
Attachment (reindex-priv-93.patch) at 2018-08-05 21:10:59 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
Improve behavior of concurrent TRUNCATE: First at 2018-08-06 16:58:16 by Michael Paquier <michael at paquier.xyz>
Latest at 2018-08-16 02:08:05 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest attachment (0001-Refactor-TRUNCATE-execution-to-avoid-too-early-lock-.patch) at 2018-08-09 16:30:02 from Michael Paquier <michael at paquier.xyz>
    Attachment (0001-Refactor-TRUNCATE-execution-to-avoid-too-early-lock-.patch) at 2018-08-09 16:30:02 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Refactor-TRUNCATE-execution-to-avoid-too-early-lock-.patch) at 2018-08-09 10:28:33 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Refactor-TRUNCATE-execution-to-avoid-too-early-lock-.patch) at 2018-08-06 16:58:16 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
Improve behavior of concurrent ANALYZE/VACUUM: First at 2018-08-12 22:21:42 by Michael Paquier <michael at paquier.xyz>
Latest at 2018-08-27 00:16:43 by Michael Paquier <michael at paquier.xyz>
Latest attachment (vacuum-locks-v5.patch) at 2018-08-24 02:15:27 from Michael Paquier <michael at paquier.xyz>
    Attachment (vacuum-locks-v5.patch) at 2018-08-24 02:15:27 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (vacuum_permission_checks_v2.patch) at 2018-08-23 05:08:13 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (vacuum_permission_checks.patch) at 2018-08-22 15:49:16 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0001-Add-regression-tests-for-VACUUM-and-ANALYZE-with-rel.patch) at 2018-08-21 01:28:15 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Improve-VACUUM-and-ANALYZE-by-avoiding-early-lock-qu.patch) at 2018-08-17 06:42:23 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Improve-VACUUM-and-ANALYZE-by-avoiding-early-lock-qu.patch) at 2018-08-12 22:21:42 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)

History

When	Who	What
2018-08-27 00:17:47	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Committed
2018-08-27 00:17:40	Michael Paquier (michael-kun)	Changed reviewers to Kyotaro Horiguchi (horiguti), Nathan Bossart (bossartn)
2018-08-27 00:17:40	Michael Paquier (michael-kun)	Changed committer to michael-kun
2018-08-24 08:40:26	Dmitry Dolgov (erthalion)	Attached mail thread 20180806165816.GA19883@paquier.xyz
2018-08-24 08:39:56	Dmitry Dolgov (erthalion)	Attached mail thread 20180805211059.GA2185@paquier.xyz
2018-08-12 22:23:44	Michael Paquier (michael-kun)	Attached mail thread 20180812222142.GA6097@paquier.xyz
2018-08-01 10:55:11	ahsan hadi (ahsan.hadi)	Posted comment with messageid <153312091109.1561.3443797127986711435.pgcf@coridan.postgresql.org>
2018-07-26 05:36:10	Michael Paquier (michael-kun)	Changed authors to Michael Paquier (michael-kun)
2018-07-26 05:36:03	Michael Paquier (michael-kun)	Attached mail thread 152512087100.19803.12733865831237526317@wrigleys.postgresql.org
2018-07-26 05:36:03	Michael Paquier (michael-kun)	Created patch record

Edit