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
[YSQL][LST] Upgrade: ERROR: The catalog snapshot used for this transaction has been invalidated: MISMATCHED_SCHEMA #12621
Comments
This is also happening inside the upgrade_ysql itself during 2.12.10.0-b41 -> 2.17.1.0-b290 upgrade. Should upgrade_ysql handle this or are users expected to retry upgrade_ysql until it succeeds? (Which it never might if the system is under load)
postgres log:
Full logs: https://drive.google.com/file/d/1S0HytReLQQhOqhNQuT-X78dIZR1xMj-b/view?usp=share_link |
This was not seen in LST in latest upgrades in 2.20 and 2.21 but on one itest-system runs, we did see this error on 2.18: |
I was able to see this issue in one of the CDC stress runs on 2.20.2: Again, have seen only once: test_cdc_tx_colocation_nemesis (This was colocation + CDC) Testcase had failed. When went into sample apps log, saw:
SampleAppWorkloads_SQL_DATA_LOAD_WITH_DDLS was run with DELETE_ROW,UPDATE_ROW,UPDATE_ROWS,INSERT_ROW |
Jira Link: DB-483
Description
After upgrading database from 2.12.3.0-b19 to 2.13.3.0-b41 with LST as workload running I'm getting this error:
Other than the DB upgrade only select and set config queries were running. Is this an expected failure during upgrades? See also #2323.
The text was updated successfully, but these errors were encountered: