Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

Purging rooms can be cancelled by the Postgres statement timeout #16322

Closed
reivilibre opened this issue Sep 14, 2023 · 0 comments · Fixed by #16455
Closed

Purging rooms can be cancelled by the Postgres statement timeout #16322

reivilibre opened this issue Sep 14, 2023 · 0 comments · Fixed by #16455
Assignees
@reivilibre
Labels
O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.

Comments

@reivilibre
Copy link
Contributor

As noticed in #16193 (v1.90.0)

We need a statement timeout override for the relevant bits of purging so that we can still purge large rooms.

(Ideally we might make it more incremental and avoid the long transactions, but that luxury would take more time)
@reivilibre reivilibre added S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. O-Uncommon Most users are unlikely to come across this or unexpected workflow labels Sep 14, 2023
@reivilibre reivilibre self-assigned this Sep 14, 2023
@DMRobertson DMRobertson mentioned this issue Sep 18, 2023
Open
@reivilibre reivilibre mentioned this issue Oct 9, 2023
Merged
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@reivilibre reivilibre

Labels
O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Disable statement timeout whilst purging rooms matrix-org/synapse
1 participant
@reivilibre