From 44f727446a6434f070de41ae3323d5eb53245bfa Mon Sep 17 00:00:00 2001 From: Erik Johnston Date: Wed, 21 Oct 2020 18:01:25 +0100 Subject: Fix port script --- scripts/synapse_port_db | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'scripts/synapse_port_db') diff --git a/scripts/synapse_port_db b/scripts/synapse_port_db index 6c7664ad4a..9794d004f5 100755 --- 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 -- cgit 1.5.1