A61: Database must be vacuumed within N transactions (TXID Wraparound Warning)

Work in Progress

This documentation page is currently being worked on. We apologize for the page being incomplete or not available yet.

Category: Autovacuum Events
SQLSTATE: n/a
Urgency: high

Example Postgres Log Output:

WARNING: database "template1" must be vacuumed within 938860 transactions
HINT: To avoid a database shutdown, execute a database-wide VACUUM in that database.
You might also need to commit or roll back old prepared transactions.
WARNING: database with OID 16992 must be vacuumed within 532942 transactions
HINT: To avoid a database shutdown, execute a database-wide VACUUM in that database.
You might also need to commit or roll back old prepared transactions.

Explanation:

...

Recommended Action:

...

Learn More:

No additional resources available.


Download Free eBook: The Top 6 Postgres Log Events
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →