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

Deprecate SQL for Ledger state #4502

Closed
SirTyson opened this issue Oct 10, 2024 · 0 comments · Fixed by #4562
Closed

Deprecate SQL for Ledger state #4502

SirTyson opened this issue Oct 10, 2024 · 0 comments · Fixed by #4562
Assignees
Labels

Comments

@SirTyson
Copy link
Contributor

SQL support for ledger state should be removed, as it has been deprecated and is not compatible with upcoming changes in protocol 23.

@SirTyson SirTyson added the bug label Oct 10, 2024
@SirTyson SirTyson self-assigned this Oct 10, 2024
This was referenced Dec 9, 2024
github-merge-queue bot pushed a commit that referenced this issue Dec 13, 2024
# Description

Resolves #4501 and partially resolves #4502

This PR removes `--in-memory`. Specifically, core will not crash if this
flag is passed in for Horizon compatibility reasons, but will ignore it
and related flags.

Additionally, `--in-memory` has been cannibalized to use in testing.
Previously, any test that committed changes directly to the root ltx was
incompatible with BucketListDB and required SQL. This is an issue, as we
are deprecating SQL for ledger state, and it would not make sense to
maintain this SQL overhead for testing only. While I've removed most of
the `in-memory` code, I've saved the bits regarding the never committing
ledger root to use for the direct ltx commit test cases. Thus we remove
the test dependency for SQL.

In order to properly test the orderbook, the `in-memory` testing mode
still maintains and queries a SQL database just for offers (similar to
what BucketListDB does).

Originally I did one PR for removing SQL, `--in-memory` and mandating
background eviction. This was way to big to merge but may be helpful in
providing context on what changes are in flight after this PR:
#4504.

Currently everything works except for the "herder externalizes values"
test. With BucketListDB testing mode, nodes can be restarted, but direct
ltx commits are not supported. With the in-memory mode testing, ltx can
be committed to directly, but nodes can not be restarted.

~~For all tests except for "herder externalizes values", this if fine.
However, "herder externalizes values" is the only test that both
directly commits to the ltx and restarts nodes. In particular, the
`setupUpgradeAtNextLedger` function directly commits to the ltx. I've
seperated the test into two helper functions, one that doesn't require
restart and one that does. I _think_ that the restart test doesn't
actually require an upgrade to occur. I think the test just used
upgrades in order to populate ledgers with some meaningful, detectable
work to make sure externalized ledgers aren't applied several times. If
the upgrade operation is not integral to this test, we can probably find
a workaround. Alternatively, we can maybe go through the full upgrade
arming process with BucketListDB support instead of cutting corners with
direct ltx commits. I'm not well versed in herder tests though, so I've
left the failing test as is. If we can remove the upgrade and check the
condition some other way, this is the path of least resistance.~~

Test has been fixed to use upgrades compatible with BucketListDB.

# Checklist
- [x] Reviewed the
[contributing](https://github.com/stellar/stellar-core/blob/master/CONTRIBUTING.md#submitting-changes)
document
- [x] Rebased on top of master (no merge commits)
- [x] Ran `clang-format` v8.0.0 (via `make format` or the Visual Studio
extension)
- [x] Compiles
- [x] Ran all tests
- [ ] If change impacts performance, include supporting evidence per the
[performance
document](https://github.com/stellar/stellar-core/blob/master/performance-eval/performance-eval.md)
@marta-lokhova marta-lokhova reopened this Dec 16, 2024
github-merge-queue bot pushed a commit that referenced this issue Dec 18, 2024
# Description

Resolves #4503 and #4502

This change removes SQL support for all ledger state, except for the
offers table. It also enforces background eviction. In order to not
break Horizon, core will not crash if any of the old flags or config
settings are used. Instead it will print a warning and ignore the flags.
The flags should be removed in the next protocol release.

# Checklist
- [x] Reviewed the
[contributing](https://github.com/stellar/stellar-core/blob/master/CONTRIBUTING.md#submitting-changes)
document
- [x] Rebased on top of master (no merge commits)
- [x] Ran `clang-format` v8.0.0 (via `make format` or the Visual Studio
extension)
- [x] Compiles
- [x] Ran all tests
- [ ] If change impacts performance, include supporting evidence per the
[performance
document](https://github.com/stellar/stellar-core/blob/master/performance-eval/performance-eval.md)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants