diff options
| author | Patrick Cloke <clokep@users.noreply.github.com> | 2023-05-26 13:16:08 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-05-26 13:16:08 -0400 |
| commit | 2ad91ec628126753590c1a90c432270d6c8fa8fd (patch) | |
| tree | d437ff10f3a4c604719146cb4b1e201dec0095d1 /changelog.d | |
| parent | Merge branch 'master' into develop (diff) | |
| download | synapse-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 'changelog.d')
| -rw-r--r-- | changelog.d/15597.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/15597.misc b/changelog.d/15597.misc new file mode 100644 index 0000000000..2dea23784f --- /dev/null +++ b/changelog.d/15597.misc @@ -0,0 +1 @@ +Make the `thread_id` column on `event_push_actions`, `event_push_actions_staging`, and `event_push_summary` non-null. |