Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

WIP Test xid wraparound #403

Draft
wants to merge 2 commits into
base: main
Choose a base branch
from
Draft

WIP Test xid wraparound #403

wants to merge 2 commits into from

Conversation

lubennikovaav
Copy link
Contributor

@lubennikovaav lubennikovaav commented Aug 9, 2021

This test uses test_consume_xids() and takes about 15min to complete.
Another way to test xid wraparound is to use pg_resetwal -x, but it turned out to be too hacky and hard to debug. And also it doesn't test clog truncation.

The commit also contains a few fixes to update_next_xid() function to restore nextXid properly.

@lubennikovaav lubennikovaav force-pushed the test_xid_wraparound branch 4 times, most recently from 78b0248 to dbe96bd Compare August 10, 2021 13:29
@lubennikovaav lubennikovaav linked an issue Aug 10, 2021 that may be closed by this pull request
@lubennikovaav lubennikovaav force-pushed the test_xid_wraparound branch 2 times, most recently from ea0b421 to 3b60b87 Compare August 30, 2021 14:42
@lubennikovaav
Copy link
Contributor Author

@hlinnaka, I guess the error caught here is related to #502
IIUC, the problem is that we don't see SLRU segment that was created after drop.
I don't think it is clog-specific, it's just hard to catch in other tests because we rarely (never?) reuse filenames.

- Advance next_xid only when incoming xlog record has one.
- Advance next_xid by one. Remove XID_CHECKPOINT_INTERVAL.
@petergeoghegan
Copy link

The commit also contains a few fixes to update_next_xid() function to restore nextXid properly.

Have you seen postgres/postgres@74cf7d46?

@kelvich
Copy link
Contributor

kelvich commented Nov 1, 2021

@lubennikovaav so what with that? should we commit it or close it?

@LizardWizzard
Copy link
Contributor

As discussed moving to draft.

@LizardWizzard LizardWizzard marked this pull request as draft March 21, 2023 15:18
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Add tests for xid, multixid and oid wraparound
4 participants