Skip to content

Correct transaction ID wraparound recovery in the v5.6 Maintenance guide #476

Open

Description

@Hanabi9248

Both v5.6 Maintenance guides say the server shuts down at the XID wraparound protection threshold and that the only way to run VACUUM is to stop the postmaster and enter single-user mode. Following those instructions can take a running server offline during recovery. English guide Chinese guide

IvorySQL v5.6 blocks commands that need a new XID at this threshold. The server’s hint directs the operator to run a database-wide VACUUM in the affected database, and the release manual confirms that plain VACUUM can still run in normal multi-user mode. Update both Maintenance guides to show the current warning and error excerpts and describe recovery with plain VACUUM while the server remains running. VACUUM FULL requires an XID. Release XID guard and messages Release recovery guidance Plain VACUUM and VACUUM FULL

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions