BUG #18876: HINT messages for mxid wrap-around say "drop stale slots", but that may not be appropriate
PG Bug reporting form <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: harukat@sraoss.co.jp
Date: 2025-04-04T03:05:12Z
Lists: pgsql-bugs
The following bug has been logged on the website: Bug reference: 18876 Logged by: TAKATSUKA Haruka Email address: harukat@sraoss.co.jp PostgreSQL version: 17.4 Operating system: any Description: In src/backend/access/transam/multixact.c, there are the following hint messages: "Execute a database-wide VACUUM in that database.\n" "You might also need to commit or roll back old prepared transactions, or drop stale replication slots." "To avoid MultiXactId assignment failures, execute a database-wide VACUUM in that database.\n" "You might also need to commit or roll back old prepared transactions, or drop stale replication slots." I think that their "drop stale replication slots" is not appropriate. Because NewRelminMxid is determined by GetOldestMultiXactId() and its comment says: * Return the oldest MultiXactId that's still possibly still seen as live by * any running transaction. Older ones might still exist on disk, but they no * longer have any running member transaction. Thus, the presence of an old mxid in a tuple pending removal by a slot is not considered to affect it. In addition, as far as I have tested, leaving the old inactive replication slot does not cause mxid_age(relminmxid) not to decrease after VACUUM. Thanks,
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Remove replication slot advice from MultiXact wraparound hints
- 802dc79df63b 14 (unreleased) landed
- 814df787f68a 15 (unreleased) landed
- 82427eea4ddc 16 (unreleased) landed
- a287fd85d2c5 17 (unreleased) landed
- c8d68bfd52d7 18 (unreleased) landed
- 4ebbf001882f 19 (unreleased) landed
- 084734ff5a42 master landed