Sad to see yet another case of transaction ID wraparound in causing very long outage status.coveralls.io
It's important to monitor the horizons both for XID and multixact ID (check if you do the latter), have reliable alerts, and fight long-running transactions.
Conversation
they're on RDS and that's directly from their report that they can't.
on PG13 vacuum goes on append-only tables naturally so wraparound explosions should not happen, in theory.
2
1
Postgres 14's failsafe mechanism would very likely have saved the day here, without any DBA intervention. VACUUM now stops caring about indexes and stops applying cost delays when table's relfrozenxid starts to look dangerously old (per vacuum_failsafe_age GUC).
I wonder how many installs will "explode" with vacuum right after upgrade.
1
I suspect there won't be that many, but who knows? In any case the failsafe log output is very likely useful information -- an early warning system. If it isn't useful (e.g., for an advanced user), then it's easy to avoid by increasing vacuum_failsafe_age.
2
Show replies