summary refs log tree commit diff
diff options
context:
space:
mode:
authorPatrick Cloke <clokep@users.noreply.github.com>2020-06-17 10:01:18 -0400
committerGitHub <noreply@github.com>2020-06-17 10:01:18 -0400
commit6418b0379fe8a7fcd0561444b1388bd70379155a (patch)
treee627b51389209a7e584f4f0393cfa909da27ed6e
parentAdd support for using rust-python-jaeger-reporter (#7697) (diff)
downloadsynapse-6418b0379fe8a7fcd0561444b1388bd70379155a.tar.xz
Ignore the UI Auth sessions when porting from sqlite to postgresql (#7711)
-rw-r--r--changelog.d/7711.bugfix1
-rwxr-xr-xscripts/synapse_port_db19
2 files changed, 13 insertions, 7 deletions
diff --git a/changelog.d/7711.bugfix b/changelog.d/7711.bugfix
new file mode 100644
index 0000000000..180de08405
--- /dev/null
+++ b/changelog.d/7711.bugfix
@@ -0,0 +1 @@
+The `synapse_port_db` script no longer fails when the `ui_auth_sessions` table is non-empty. This bug has existed since v1.13.0rc1.
diff --git a/scripts/synapse_port_db b/scripts/synapse_port_db
index a0d81c77c2..810e08beb5 100755
--- a/scripts/synapse_port_db
+++ b/scripts/synapse_port_db
@@ -127,6 +127,16 @@ APPEND_ONLY_TABLES = [
 ]
 
 
+IGNORED_TABLES = {
+    "user_directory",
+    "user_directory_search",
+    "users_who_share_rooms",
+    "users_in_pubic_room",
+    "ui_auth_sessions",
+    "ui_auth_sessions_credentials",
+}
+
+
 # Error returned by the run function. Used at the top-level part of the script to
 # handle errors and return codes.
 end_error = None
@@ -289,13 +299,8 @@ class Porter(object):
             )
             return
 
-        if table in (
-            "user_directory",
-            "user_directory_search",
-            "users_who_share_rooms",
-            "users_in_pubic_room",
-        ):
-            # We don't port these tables, as they're a faff and we can regenreate
+        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