Re: snapshot too old issues, first around wraparound and then more.
Peter Geoghegan <pg@bowt.ie>
From: Peter Geoghegan <pg@bowt.ie>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, Kevin Grittner <kgrittn@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2020-04-01T22:00:16Z
Lists: pgsql-hackers
On Wed, Apr 1, 2020 at 1:25 PM Robert Haas <robertmhaas@gmail.com> wrote: > Maybe that contrib module could even have some functions to simulate > aging without the passage of any real time. Like, say you have a > function or procedure old_snapshot_pretend_time_has_passed(integer), > and it moves oldSnapshotControl->head_timestamp backwards by that > amount. Maybe that would require updating some other fields in > oldSnapshotControl too but it doesn't seem like we'd need to do a > whole lot. I like that idea. I think that I've spotted what may be an independent bug, but I have to wait around for a minute or two to reproduce it each time. Makes it hard to get to a minimal test case. -- Peter Geoghegan
Commits
-
Remove the "snapshot too old" feature.
- f691f5b80a85 17.0 landed
-
Improve timeout.c's handling of repeated timeout set/cancel.
- 09cf1d522676 14.0 cited
-
Fix two bugs in MaintainOldSnapshotTimeMapping.
- 55b7e2f4d78d 14.0 cited