1 files changed, 5 insertions, 4 deletions
diff --git a/synapse/storage/databases/main/purge_events.py b/synapse/storage/databases/main/purge_events.py
index 1a5b5731bb..56c8198149 100644
--- a/synapse/storage/databases/main/purge_events.py
+++ b/synapse/storage/databases/main/purge_events.py
@@ -89,10 +89,11 @@ class PurgeEventsStore(StateGroupWorkerStore, CacheInvalidationWorkerStore):
# furthermore, we might already have the table from a previous (failed)
# purge attempt, so let's drop the table first.
- if isinstance(self.database_engine, PostgresEngine):
- # Disable statement timeouts for this transaction; purging rooms can
- # take a while!
- txn.execute("SET LOCAL statement_timeout = 0")
+ # Disable statement timeouts for this transaction; purging rooms can
+ # take a while!
+ self.database_engine.attempt_to_set_statement_timeout(
+ txn, 0, for_transaction=True
+ )
txn.execute("DROP TABLE IF EXISTS events_to_purge")
|