Fix port script

2025-12-05 01:10:13 +00:00 · 2020-10-21 18:01:25 +01:00
1 changed files with 1 additions and 1 deletions
--- a/scripts/synapse_port_db
+++ b/scripts/synapse_port_db
@@ -818,7 +818,7 @@ class Porter(object):
                    "ALTER SEQUENCE events_stream_seq RESTART WITH %s", (next_id,)
                )

-            txn.execute("SELECT -MIN(stream_ordering) FROM events")
+            txn.execute("SELECT GREATEST(-MIN(stream_ordering), 1) FROM events")
            curr_id = txn.fetchone()[0]
            if curr_id:
                next_id = curr_id + 1