diff options
author | Brian Campbell <unlambda@gmail.com> | 2022-12-15 12:08:40 -0500 |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-12-15 18:08:40 +0100 |
commit | 2d1294822089a8f1467723bed425eed51dd7db79 (patch) | |
tree | 4cdad2c90cbda674ac2eb20868d80cd7f7fb9105 /db/post_migrate/20210308133107_remove_subscription_expires_at_from_accounts.rb | |
parent | ebf1d74e409ece10864a8615691cd80c434c9055 (diff) |
Fix idempotency when database writes are slow (#21840)
There is an idempotency key generated by clients when authoring a post, and stored in Redis, to ensure that if a user or client retries posting the same status, we don't get a duplicate. Hachyderm.io has been experiencing some filesystem and database performance issues, causing database writes to be slow. This can mean that there are successful posts, but the reverse proxy returns 504 Gateway Timeout before the idempotency status has been updated; users or clients who retry (such as Tusky which retries automatically, see tuskyapp/Tusky#2951) can re-try the same post with the same idempotency key before it has actually been recorded in Redis, leading to duplicate posts. To address this issue, move all of the database updates after the initial transaction that creates the status into the `postprocess_status!` method, so we can insert the idempotency key immediately after the status has been created, significantly reducing the window in which the status could be created but the idempotency key not yet stored. Note: this has not yet been tested; I'm submitting this PR for discussion and to offer to the Hachyderm.io admins to try out to fix the multiple posting problem. Co-authored-by: Brian Campbell <brcampbell@beta.team>
Diffstat (limited to 'db/post_migrate/20210308133107_remove_subscription_expires_at_from_accounts.rb')
0 files changed, 0 insertions, 0 deletions