summary refs log tree commit diff
diff options
context:
space:
mode:
authorPatrick Cloke <clokep@users.noreply.github.com>2020-06-23 07:33:25 -0400
committerGitHub <noreply@github.com>2020-06-23 07:33:25 -0400
commit24110255cd5f304bd380e8f58c30137489e7522e (patch)
tree77b5307520eb29e1d2d9e715ee1eb5fd3234f6f4
parentAllow local media to be marked as safe from being quarantined. (#7718) (diff)
downloadsynapse-24110255cd5f304bd380e8f58c30137489e7522e.tar.xz
Sync ignored table names in synapse_port_db to current database schema (#7717)
-rw-r--r--changelog.d/7717.bugfix1
-rwxr-xr-xscripts/synapse_port_db16
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