summary refs log tree commit diff
path: root/dev-docs
diff options
context:
space:
mode:
authorPatrick Cloke <clokep@users.noreply.github.com>2023-05-26 13:16:08 -0400
committerGitHub <noreply@github.com>2023-05-26 13:16:08 -0400
commit2ad91ec628126753590c1a90c432270d6c8fa8fd (patch)
treed437ff10f3a4c604719146cb4b1e201dec0095d1 /dev-docs
parentMerge branch 'master' into develop (diff)
downloadsynapse-2ad91ec628126753590c1a90c432270d6c8fa8fd.tar.xz
Set thread_id column to non-null for event_push_{actions,actions_staging,summary} (#15597)
Updates the database schema to require a thread_id (by adding a
constraint that the column is non-null) for event_push_actions,
event_push_actions_staging, and event_push_actions_summary.

For PostgreSQL we add the constraint as NOT VALID, then
VALIDATE the constraint a background job to avoid locking
the table during an upgrade.

Each table is updated as a separate schema delta to avoid
deadlocks between them.

For SQLite we simply rebuild the table & copy the data.
Diffstat (limited to 'dev-docs')
0 files changed, 0 insertions, 0 deletions