Reset temp schema on connection to prevent XID wraparound

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Tags

Created

2018-02-05 03:25:45

Last modified

2018-08-13 09:55:53 (6 years ago)

Latest email

2018-08-20 23:38:34 (6 years ago)

Status

2018-09 (2018-09-01 - 2018-09-30): Committed

2018-07 (2018-07-01 - 2018-07-31): Moved to different CF

2018-03 (2018-03-01 - 2018-03-31): Moved to different CF

Target version

Authors

Takayuki Tsunakawa (maumau)

Reviewers

Michael Paquier (michael-kun)Become reviewer

Committer

Michael Paquier (michael-kun)

Links

Emails

Temporary tables prevent autovacuum, leading to XID wraparound: First at 2018-01-25 06:14:41 by "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com>
Latest at 2018-08-20 23:38:34 by Michael Paquier <michael at paquier.xyz>
Latest attachment (temp-namespace-comments-2.patch) at 2018-08-14 16:53:32 from Michael Paquier <michael at paquier.xyz>
    Attachment (temp-namespace-comments-2.patch) at 2018-08-14 16:53:32 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (temp-namespace-comments.patch) at 2018-08-13 17:03:59 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Make-autovacuum-more-aggressive-to-remove-orphaned-t.patch) at 2018-08-09 07:00:29 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Make-autovacuum-more-aggressive-to-remove-orphaned-t.patch) at 2018-07-30 07:59:16 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (reset_temp_schema_v3.patch) at 2018-07-27 06:28:40 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (reset_temp_schema_v2.patch) at 2018-03-13 08:08:48 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (reset_temp_schema_on_connect.patch) at 2018-02-05 03:10:17 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)

History

When	Who	What
2018-08-13 09:55:53	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Committed
2018-08-10 22:44:36	Andrew Dunstan (adunstan)	New status: Waiting on Author
2018-08-10 22:33:54	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:33:48	Andrew Dunstan (adunstan)	New status: Needs review
2018-07-27 06:30:16	Michael Paquier (michael-kun)	Changed committer to michael-kun
2018-07-13 04:53:10	Michael Paquier (michael-kun)	New status: Waiting on Author
2018-07-13 04:53:06	Michael Paquier (michael-kun)	Changed reviewers to Michael Paquier (michael-kun)
2018-04-10 18:19:20	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-02-05 03:28:11	Takayuki Tsunakawa (maumau)	Changed authors to Takayuki Tsunakawa (maumau)
2018-02-05 03:25:45	Takayuki Tsunakawa (maumau)	Attached mail thread 0A3221C70F24FB45833433255569204D1F8A4DC6@G01JPEXMBYT05
2018-02-05 03:25:45	Takayuki Tsunakawa (maumau)	Created patch record