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.

Sign up for GitHub

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

Jump to bottom

deterministic indexer backup so that all nodes produce the same bit-by-bit snapshot #1289

Open
altergui opened this issue Apr 2, 2024 · 0 comments · May be fixed by #1338
Open

deterministic indexer backup so that all nodes produce the same bit-by-bit snapshot #1289

altergui opened this issue Apr 2, 2024 · 0 comments · May be fixed by #1338
Assignees
@altergui

Comments

@altergui
Copy link
Contributor

altergui commented Apr 2, 2024 •
edited
Loading

right now the content of the indexer db is deterministic, but the backup is not since it's in binary format. to make it deterministic we should instead do something equivalent of a "sqlite3 .dump"
i.e. that the backup is a (compressed) bunch of SQL INSERT (etc) statements instead of native binary sqlite3 format
@altergui altergui mentioned this issue Apr 2, 2024
Closed
6 tasks
@altergui altergui self-assigned this Apr 2, 2024
@altergui altergui linked a pull request Jun 13, 2024 that will close this issue
indexer: backups are now a deterministic set of SQL statements #1338
Draft
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@altergui altergui

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

indexer: backups are now a deterministic set of SQL statements vocdoni/vocdoni-node
1 participant
@altergui