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

Run wal_checkpoint during housekeeping #6089

Open
link2xt opened this issue Oct 21, 2024 · 0 comments
Open

Run wal_checkpoint during housekeeping #6089

link2xt opened this issue Oct 21, 2024 · 0 comments

Comments

@link2xt
Copy link
Collaborator

link2xt commented Oct 21, 2024

Otherwise WAL file may grow to 200M:
#6066 (comment)

Need to decide what type of wal_checkpoint to run, but probably TRUNCATE:
https://www.sqlite.org/pragma.html#pragma_wal_checkpoint

Before running it we should acquire all connections from the pool to make sure we don't run busy-handler. Then still better use block_on because some other process such as sqlitebrowser may open the database.

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

No branches or pull requests

1 participant