diff options
| author | Erik Johnston <erikj@jki.re> | 2016-08-31 15:07:33 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-08-31 15:07:33 +0100 |
| commit | 1671913287e1f63ccd40de6d09254b5d2c386b0f (patch) | |
| tree | 14142bb3e9d15f5a6b12d067e1601fe4e5df6057 /synapse/storage/transactions.py | |
| parent | Merge pull request #1057 from matrix-org/erikj/fix_email_name (diff) | |
| parent | Clean up old sent transactions (diff) | |
| download | synapse-1671913287e1f63ccd40de6d09254b5d2c386b0f.tar.xz | |
Merge pull request #1059 from matrix-org/erikj/sent_transaction_delete
Clean up old sent transactions
Diffstat (limited to 'synapse/storage/transactions.py')
| -rw-r--r-- | synapse/storage/transactions.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/synapse/storage/transactions.py b/synapse/storage/transactions.py index 58d4de4f1d..1c588bd46b 100644 --- a/synapse/storage/transactions.py +++ b/synapse/storage/transactions.py @@ -387,8 +387,10 @@ class TransactionStore(SQLBaseStore): def _cleanup_transactions(self): now = self._clock.time_msec() month_ago = now - 30 * 24 * 60 * 60 * 1000 + six_hours_ago = now - 6 * 60 * 60 * 1000 def _cleanup_transactions_txn(txn): txn.execute("DELETE FROM received_transactions WHERE ts < ?", (month_ago,)) + txn.execute("DELETE FROM sent_transactions WHERE ts < ?", (six_hours_ago,)) return self.runInteraction("_persist_in_mem_txns", _cleanup_transactions_txn) |