We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
This is related to: lijunwangs/solana-postgres-rpc-server#3
When slots that were on forks end up being skipped, we're storing inconsistent state data in the accounts table.
accounts
Proposed solution:
Add a trigger that will delete entries from accounts table which are on status processed whenever a new slot is rooted. Something like:
processed
delete from accounts where slot < new_rooted_slot and slot.status=processed'
For this to work it would require that previous entries exists in accounts_audit table.
accounts_audit
The text was updated successfully, but these errors were encountered:
No branches or pull requests
This is related to: lijunwangs/solana-postgres-rpc-server#3
When slots that were on forks end up being skipped, we're storing inconsistent state data in the
accounts
table.Proposed solution:
Add a trigger that will delete entries from
accounts
table which are on statusprocessed
whenever a new slot is rooted. Something like:delete from accounts where slot < new_rooted_slot and slot.status=processed'
For this to work it would require that previous entries exists in
accounts_audit
table.The text was updated successfully, but these errors were encountered: