diff options
| -rw-r--r-- | changelog.d/7717.bugfix | 1 | ||||
| -rwxr-xr-x | scripts/synapse_port_db | 16 |
2 files changed, 13 insertions, 4 deletions
diff --git a/changelog.d/7717.bugfix b/changelog.d/7717.bugfix new file mode 100644 index 0000000000..bcbf146fea --- /dev/null +++ b/changelog.d/7717.bugfix @@ -0,0 +1 @@ +Fix the tables ignored by `synapse_port_db` to be in sync the current database schema. diff --git a/scripts/synapse_port_db b/scripts/synapse_port_db index c2023f3e4d..2eb795192f 100755 --- a/scripts/synapse_port_db +++ b/scripts/synapse_port_db @@ -129,10 +129,20 @@ APPEND_ONLY_TABLES = [ IGNORED_TABLES = { + # We don't port these tables, as they're a faff and we can regenerate + # them anyway. "user_directory", "user_directory_search", - "users_who_share_rooms", - "users_in_pubic_room", + "user_directory_search_content", + "user_directory_search_docsize", + "user_directory_search_segdir", + "user_directory_search_segments", + "user_directory_search_stat", + "user_directory_search_pos", + "users_who_share_private_rooms", + "users_in_public_room", + # UI auth sessions have foreign keys so additional care needs to be taken, + # the sessions are transient anyway, so ignore them. "ui_auth_sessions", "ui_auth_sessions_credentials", } @@ -301,8 +311,6 @@ class Porter(object): return if table in IGNORED_TABLES: - # We don't port these tables, as they're a faff and we can regenerate - # them anyway. self.progress.update(table, table_size) # Mark table as done return |